Create a distribution list in Exchange, and use the name of the distribution list as the email address in your Agent Operator.

I am sure there was a KB article about this problem (or maybe we got the details direct from Product Support), but I cannot find any KB article now. ...

If all 3 files are on the same physical disk, there is no point in doing this. At best performance will be the sme as with 1 file but...

Temporary tables should be deleted automatically by SQL Server when the thing that created them ends.

If a #temp table is created in a stored procedure, it will be...

tempdb size does not depend on the size of your largest DB.

My advice is to follow the advice of The_SQL_DBA.

When you know how much space is actually used,...

The file size on disk and the file size shown by Windows may not always be the same.

The information shown to the end-user by the DIR command or in Windows...

To add to The_SQL_DBA... If you have multiple file in a filegroup that are all the same size and all allow autogrow, then growth is likely to be concentrated...

lucassouzace,

You should read the previous posts in this thread. A number of people thought the 'correct' answer was wrong or the question did not have a single answer.

I am...

Are you doing a command line install? There is a entry on Connect about this problem.

The /AGTSVCPASSWORD parameter does not like the password value to be in quotes. ...

The SQL Server install will put a lot of files in the GAC, which is always on the system drive. There are other files that are always put on...

It is a long time since I used SQL Server 2000, and it took me a long time to find the answer.

The good news is you do not need to...

Also be aware that the SQL Server 2005 install media has separate CDs for the server components and the client tools. If you ran your install from the Server...

If you are using Full Text search, the internals of this have been rewritten for SQL Server 2008. If you moved from SQL Server 2000 to 2005 and made...

Colin's question about how you are monitoring things deserves respect. Unless you know what is causing the problem, you are unlikely to get the right solution.

The discussion you report...

If you create a new database role, then add one of the system databases roles to your role, you do not inherit the rights of the system role.

You need to...