Here is what I used to use on my SQL 2000 servers. Works great and there is no need to install any additional software on the SQL Server.

http://www.sqldev.net/xp/xpsmtp.htm

If you have configured database mail already, you may just need to enable SQL Server Agent to use database mail.

Right click SQL Server Agent from SQL Server Management Studuio and...

I use extended properties and create an html document using this script. It works pretty well for what I use it for, but the third party tools definately do a...

You don't have to loop through the tables. You should be able to do something like this...

DECLARE @TABLE1 TABLE(ID int, TotNum int)

DECLARE @TABLE2 TABLE(ID int, TotNum int)

INSERT @TABLE1

SELECT 1,...

I think this should work...

CASE WHEN weight < 1 THEN 'UPS'

WHEN weight BETWEEN 1.00 AND 2 THEN 'UPS2'

ELSE...

Try this...

SELECT D.name,

CAST(CAST((D.SIZE * 8 / 1024.0) AS DECIMAL(18,2)) AS VARCHAR(20)) FILESIZE_MB,

CAST((D.SIZE...

The Witness server will not automatically assume the role of the Principal server. The setting is just for the endpoint. If it is set to Witness, the server can...

I don't think you can use the select statement in the radians function. Try using a variable and see if it works.

DECLARE @lng float

Set @lng = (SELECT lng FROM...

You have to shrink the file to reclaim the space. See the following link...

http://msdn.microsoft.com/en-us/library/aa258824(SQL.80).aspx

I see Chris beat me to it. Here is a really good whitepaper that covers all of the failover scenarios.

http://technet.microsoft.com/en-us/library/cc917680.aspx

When you take the Mirror server down, the logs will contiue to build up on the Princiapl server until the Mirror server comes online again. Then the Principal server will...

You can setup database mirroring without a Witness server so it will not automatically fail over when you do maintenance on the Principal server. Using synchronous mode without a witness...

I would detach the databases, move the data files, and then reattach the databases. Look up attaching and detaching databases in Books Online or MSDN. This will not affect your...

Here is what I use...

http://www.mssqltips.com/tip.asp?tip=1622

Here is an article with some examples that should help.

http://www.mssqltips.com/tip.asp?tip=1525

You will specifically want to look at the last code sample.