System databases can't be upgraded by backup/restore.

1. Do a inplace upgrade from SQL 7 to SQL 2000 and then backup/restore will work as system database will be upgraded to 8.0...

This warning was the symptom of the pressure in MemToLeave area in SQL Memory.

What is the current build of SQL Server? Run @@version in query analyzer and post the results.

Bad...

Chad,

DBCC CHECKDB runs DBCC CHECKCATALOG also in SQL 2005.

As per my understanding there is some reference for columns in stored procedure which are not available.

Its my assumption. To prove the...

interesting....

Could you please run below query in specific database

sp_fulltext_service

'verify_signature', 0

After running above, restart Full Text service for that instance and...

Did you get chance to run when you are waiting for 45 seconds?

select * from sys.sysprocesses

I feel that your query is blocked by something. Please let us know waittype,...

How to configure SQL Server to use more than 2 GB of physical memory

http://support.microsoft.com/kb/274750/en-us

my 2 cents...

1. Check if PAE is enabled.  I am sure it is, that's why OS is seeing 17 GB of RAM. To check go to

Start>Run>msconfig and select BOOT.INI...

Most of the schedules things are set to send alerts... so checking mail is the most important thing

Aaron is pointing to below...

I would suggest to open a case with Microsoft PSS. $249 is not a big deal

Another question! was this database restored from SQL 2000 backup?

Jay.

In SQL 2005, checkdb is more strict then in SQL 2000.

Please note that 'exec sp_configure 'allow updates', 1' is not allowed in SQL 2005.

To move forward, what are objects?...

Based on my understanding of the problem you want to connect to a SQL server which is listening on port other then 1433

Lets say my SQL is listening on 2012...

I agree with Dan.

Another link from Books on line

http://msdn2.microsoft.com/en-us/library/ms143694.aspx

Only one issue for which there is a KB

http://support.microsoft.com/kb/905618/en-us

"You may receive a connection error message when you try to connect...

1. You can look into error logs of SQL server and look for below row.

2006-09-02 05:54:25.660 Server Detected 2 CPUs. This is an informational message; no user action is required.

2. Open SQL...