Post reply

xp_cmdshell

  • September 15, 2005 at 10:21 pm

    #110199

    Hi,

    Is there any way to put the information in  a table executing xp_cmdshell

    ex: exec master..xp_cmdshell 'dir c:\'

     

    from

    killer

  • September 15, 2005 at 11:24 pm

    #590428

    As per Books Online, you can use the EXECUTE option of the INSERT statement.

     

    --------------------
    Colt 45 - the original point and click interface

  • September 15, 2005 at 11:40 pm

    #590429

    like this

    create table #temp

    (mycolumn varchar(1000))

    insert into #temp execute master.dbo.xp_cmdshell 'dir c:\'

    select * from #temp

  • September 16, 2005 at 12:00 am

    #590431

    Thanx

    Nashi for ur help.

     

    from

    Killer

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply