Viewing 15 posts - 181 through 195 (of 341 total)
JohnG (6/18/2008)
Please show the code that can return the number of rows in a cursor using sp_describe_cursor_columns.
Agreed. The BOL referenced (as well as BOL I have installed on my computer)...
June 18, 2008 at 7:09 am
How can I check to see if we already have this installed?
June 17, 2008 at 9:20 am
As long as your investment is returning greater than 5% to account for your two noted factors, you are seeing a marginal return. Anything less than 5% and you are...
June 17, 2008 at 8:38 am
Samuel Clough (6/17/2008)
June 17, 2008 at 7:02 am
I'm glad to see I'm not the only person that answered correctly but got it incorrect.
June 16, 2008 at 7:41 am
When I take vacation, the laptop does go with me but ONLY for emergencies. I am always able to rest on vacation but since I'm the only DBA, I have...
June 13, 2008 at 8:39 am
Right now, I'm having the same type of problem. I issued a simple select statement that should have completed sub-second but did not. So I clicked on stop (I'm using...
June 13, 2008 at 6:50 am
Michael Earl (6/12/2008)
You need to install a 32 bit OS if you want to run 32 bit SQL...
June 12, 2008 at 1:08 pm
That is precisely how we are running for the time being. I wasn't here when it was setup so I just inherited it. I do see some performance issues where...
June 12, 2008 at 1:06 pm
rbarryyoung (6/12/2008)
June 12, 2008 at 7:55 am
Sounds like an interesting project. I don't know for sure if it will work but it seems that if VBScript code exists that could read the variable, it should be...
June 12, 2008 at 7:38 am
goodguy (6/12/2008)
I would like to know what the folks at Microsoft would say when they hear their beloved EM spelt out as Enterprise Mangler. LOL!
Must be my Microsoft keyboard that...
June 12, 2008 at 7:03 am
rbarryyoung (6/11/2008)
I just always kept a session open to each of my SQL Servers.
I had an EM session open before we started the batch. Once the batch was started, everything...
June 12, 2008 at 7:00 am
Your original message indicated you wanted to truncate the data and I assumed you meant you wanted to truncate the table and just insert all of the records from 2000...
June 11, 2008 at 2:54 pm
jon pill (6/11/2008)
June 11, 2008 at 2:01 pm
Viewing 15 posts - 181 through 195 (of 341 total)