SQL Server desperately needs a backup product similar to the BMC DB2 backup, which includes a feature called 'Offline backup merge'.  This allows you to take a full backup and some...

I have developed a tool that can capture any of the SQL Server performance counters, plus some other details such as free disk space.  It works on SQL 2000 and...

SQL 2000 SP4 and SQL 2005 are both less tolerant of data type mismatches than earlier versions, and this can make queries run much slower. 

If you have a WHERE clause comparing...

Steve,

I recently got back from 3 weeks in Kolkata, helping out in a street kids school.  If you think Cambridge traffic drives close, try Kolkata.  Myriad cars, taxis, buses, tuc-tucs, cycle...

Another issue about upgrading in place...The SQL 2005 install can have problems if the system databases are not in their default locations. 

Our SQL 2000 standard is that each database...

The best approach for getting a fully functional and fully supported SQL 2005 is

a) Script out DTS, Jobs, Logins, etc from SQL 2000

b) Detach user databases

c) Uninstall SQL 2000

d)...

Personally, I would always use a clean install of SQL 2005 instead of an upgrade in place.  Doing an uninstall of SQL 2000 folled by a SQL 2005 install gives...

I had the same issue.  It is due to Microsoft splitting the install media into a Server components folder and a Tools component folder.  If you run the install from...

One of the most common reasons for getting a message about 'Unable to create SSPI context' is lack of permission to create the SPN.

Make sure the account that is running...

Glad it works!  The main thing with SQL mail is that the mail profile must be created using the same account that is used to run the SQL service. 

Also,...

I came across the same issue with SP2 and mssqlsystemresource. My view is the documented method of moving mssqlsystemresource is now broken, and it is not safe to move this DB. ...

Ask them for their detailed reasoning for removing the /3GB switch.  If they have trace information or specific incidents that show the /3GB was a problem, you have your answer. ...

We administer our SQL Servers from what we call our 'Admin Server'.  This has various client tools installed, including EM, SSMS, etc. 

It also has shutdown.exe, which allows us to reboot...

I think you have 2 separate issues...

1) Enabling the mail XPs.  I think this has worked fine from the results you have shown.

2) The AWE message.  I think you have...

Yes.

Setting the size of tempdb in SQL 2000 EM or SQL 2005 SSMS will do 2 things:

1) Increase the current size of tempdb to the values you haave given.

2) Use...