Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2001
    Posts
    36

    Question Unanswered: Output of Stored Procedure

    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.

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    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
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Nov 2001
    Posts
    36
    Thnaks a lot man

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •