Retrieving Information outside of SQL Server

Question

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

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

Paul White SSC Guru Points: 150467 More actions · Answer 1

Grinja Hall of Fame Points: 3590 More actions · Answer 2

Paul White (3/15/2010)
SSC Article: http://www.sqlservercentral.com/articles/SQLCLR/65656/

Thanks, i'll give this one a read!

Paul White SSC Guru Points: 150467 More actions · Answer 3

There are other methods of course: xp_cmdshell, sp_OACreate, and so on. All pretty horrible.

CLR is the correct tool for this type of job. It is a good article, I hope you enjoy it.

Paul

Grinja Hall of Fame Points: 3590 More actions · Answer 4

Good article, especially since it shows both XP_CMDSHELL and the SQLCLR version.

I've never actually made use of SQLCLR but it looks like it may be the better solution for my problem.

Thanks again!