Alternative to using xp_cmdshell

Question

Alternative to using xp_cmdshell

Viewing 2 posts - 31 through 32 (of 32 total)

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

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

Note that I use a certificate signed assembly and a certificate login in that example as well. I'd forgo CLR for this, you can accomplish it with SQL Agent and you still have the certificate and login with permissions.

C# Gnu SSCertifiable Points: 5973 More actions · Answer 2

I found a useful link explaining how to sign a stored procedure with a certificate : I think I will have a go at this ....

http://msdn.microsoft.com/en-us/library/bb283630.aspx

Nice one Jonathan!

C# Gnu
____________________________________________________

Excel Database Tasks : efficient business data processing
Version 3.3 released February 2015