Here is the Microsoft FAQ on SQL Mail:

http://support.microsoft.com/default.aspx?scid=kb;en-us;q311231

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Without using a subquery, he'd have to apply it. I apologize, I wasn't clear. By putting it in a view he's getting the same effect as your subquery.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

SQL Server will run even if the servername in the master database differs from the actual name of the server. There was a development server running for months where I...

Glad to be of help. Actually, being mistaken for Brian Knight is a good thing... for me. Probably not for him, though!

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Here's an article about moving system databases from one server to another:

http://support.microsoft.com/default.aspx?scid=kb;en-us;q304692

Typically, when SQL Server goes down it write information to its log files and/or the event log. Is the...

If you are going to use the UNION frequently, using a view is a good way to go. You can even assign permissions against the view, giving you some options...

When you say the transaction log does not grow, are you getting to the point where the transaction log is full and not auto-growing or is it that you've allocated...

I think you're confusing me with Brian Knight. Too many Brian's running around! He's a co-owner of this site and often responds in the forums as...

TempDB doesn't have to be in single-user mode in order to run the ALTER DATABASE commands cited in the article. I ran a successful test with two users explicitly connected...

Use the system stored procedure sp_who or the well-known but undocumented system stored procedure sp_who2 to find out what processes are accessing TempDB other than you. If it's a user...

A few resources come to mind:

Microsoft's White Paper on Upgrading to SQL Server 2000:

http://www.microsoft.com/sql/howtobuy/Upgrade_to_SQL_Server_2000.doc

SQL Server 2000 Resource Kit Chapter 11 on BLOBs:

http://www.microsoft.com/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

Articles at SQLTeam.com on Upgrading from SQL Server 7.0...

Here is an article from the Microsoft Knowledge Base:

http://support.microsoft.com/default.aspx?scid=kb;en-us;q224071

It gives step-by-step instructions on moving databases, including TempDB.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

You are welcome. Glad to be of help.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Please do not cross-post. This rightfully belongs in the administration forum so I've locked the topic in the General forum.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Do you mean not including foreign keys when scripting a given table?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/