I took your code, made a couple of changes for my environment, and was able to send myself an email. If you would like, I can make another small...

I was comparing your call to sp_send_dbmail to one I have in a scheduled job and I see one thing missing from yours, this:

@execute_query_database = 'mydb',

Add this to your call...

I don't know, but I got the answer (per QoD) correct because it makes sense to me. There are two types of DML triggers: AFTER and INSTEAD OF. ...

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