Have you tried executing like this: exec sp_ResetDB

Mike, I'd either end SQLCmd1 and SQLCmd2 or start SQLCmd2 and SQLCmd3 with the UNION operator.

Haven't had that big if a dynamic sql requirement that I am aware of at least. I have several sql scripts that I use to create tables, views, and...

Merry Christmas!

I have to agree with Jeff. There isn't much that I really want or could use. I have a great family that is supportive of my career...

True, true, but to say that a tinyint holds values between 0 and 255 not 0 and 127 is also misleading in the context of the question. The given...

Actually, SQL Mail on SQL Server 2000 requires a MAPI client be installed on the server (Outlook, not Outlook Express). xp_sendmail uses MAPI to send mail. I don't...

True, a tinyint can hold a value between 0 and 255, but the DOMAIN of a specific column defined as a tinyint may be 0 to 127. You can...

You need to use dynamic sql if that is what you are trying to do.

declare @SQLCmd nvarchar(4000)

set @SQLCmd = 'use ' + @DBName + ';select * from dbo.myTable'

exec (@SQLCmd)

The above...

Not being that familiar with SAN's myself, my answer is an unqualified yes. We are getting a new SAN here, and I expressly asked that the disks used by...

I'm with you...

Not directly, as SL Server does not allow you to use a stored procedure like a table. You will need to load the output of the stored procedure into...

Actually, nothing to apologize for there. Sometimes that is how you get help for problems you are facing. Someone mentions something in a thread that triggers a request...

Thanks Jeff. I should have figured that one out, but then I only worked for a Conference Call company for 2 months (contract job) before getting the position I...

It could just be me, but the world is full of acronyms especially TLA's. What is CDR? Not the code, the acronym.

As I am not commuting between Colorado Springs and Denver anymore (did that for 15 years), most of my driving today is city based, so the hybrid would be useful...