There is an admistration part to WSS, but I haven't been able to find where it is yet, mostly because I am at home right now. We had an...

I had this issue a while back. You won't be able to do this through SSMS. Unfortuately, I don't remember exactly how I finally backed up and truncated...

Actually, since your stored proc sp_ResetDB, was created in the master database, by just saying EXEC sp_ResetDB, SQL Server looked first in the master database and finding it there ran...

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...