Friday, 23 April 2010

To Get The Result in One Lane

create table #tmp7 (col1 varchar(2000))
insert #tmp7 exec master..xp_cmdshell 'osql -E -w2000 -Q "exec sp_helplogins"'

select * from #tmp7

drop table #tmp7

No comments:

Post a Comment