Post reply

Any Alternative for using xp_cmdshell?

  • April 2, 2009 at 11:59 pm

    #384276

    Hi,

    Just wanted to know if there is any alternative to xp_cmdshell in SQL SERVER.

    I do not want the extended stored procedure to be used anymore, is there a replacement for this....

    Is there anything available in SQL SERVER 2005 to overcome this?

    Thanks

  • April 3, 2009 at 2:26 am

    #971349

    Hi,

    You could use sp_OA* however these are not much better!

    CLR is generally used in SQL 2005 (from my experience) by developers to replace much of the functionality that xp_cmdshell provided.

  • April 3, 2009 at 8:46 am

    #971631

    powershell may give you some of the functionality as well

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

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