Hi,

I am trying to run sp_validatelogins on my dev box and store the output in some temp table.

Basically, when a stored procedure returns 'N' number of rows how do I directly put it in temp table. ( I am not looking for procedure return status, or any OUTPUT variable).

Thanks.

try:

if object_id('tempdb..#Tmp') is not null drop table #Tmp
create table #Tmp(SID varbinary(85), [NT Login] sysname)

insert into #Tmp
exec sp_validatelogins

select * from #Tmp

Thnaks a lot man