Viewing 3 posts - 1 through 3 (of 3 total)
Sean/Jeff:
Thank you. I read the articles AFTER I posed. :unsure:
I ran some tests and I'm amazed by DelimitedSplit8K's speed. I ran tests using both methods...
November 9, 2012 at 12:21 pm
The anwers above are pretty good; however, there's a short cut. use XML. In just a few lines you can get what you want and the performance is really...
November 9, 2012 at 8:26 am
This will show all the running SQL Server services.
Note: you will need to make sure srvinfo is available.
Have Fun!
CREATE TABLE #srvinfo (Txt VARCHAR(1024))
INSERT #srvinfo EXEC master..xp_cmdshell 'srvinfo'
IF @@ERROR=0
BEGIN
...
May 21, 2008 at 10:48 am
Viewing 3 posts - 1 through 3 (of 3 total)