Try this:

DECLARE @database_name SYSNAME

DECLARE @iRowCount INT

DECLARE @t_TableNames_Temp TABLE

(table_name SYSNAME)

drop table #file_check

create table #file_check(DBName sysname,MDFFile sysname,LDFFile sysname)

INSERT @t_TableNames_Temp

SELECT name

FROM SYSDATABASES

WHERE name not in ('pubs','northwind','tempdb')

ORDER...

You don't need to change anything on system database. As somebody posted only change it for user databases one by one.

MJ

Check section named "To rebuild system databases for a default instance of SQL Server 2005 from the command prompt" at http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx

Manu

http://deepakrangarajan.blogspot.com/2007/08/how-to-rebuild-system-database-in-sql.html

HTH.

MJ

Under Run type services.msc and under the services console chek fr SQL Server service...

Mj

Use:

EXEC sp_configure 'show advanced options', '1'

RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'min server memory', '0'

EXEC sp_configure 'max server memory', '3000'

RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'show advanced options', '0'

RECONFIGURE WITH OVERRIDE

HTH.

MJ

Do this:

From: http://support.microsoft.com/kb/942861

To work around this problem, disable the TCP Chimney Offload feature.

To do this, follow these steps:

Click Start, click Run, type cmd, and then press ENTER.

At the command...

Bad suggestion from me. I forgot tht in 2005 mssqlsystemresource governs everything. Would be fine if you restore over the existing master database in any fresh test instalation.

Experts,

Please comment. I...

I did two changes and it worked:

domainvarcharno20--Increased length of domain column

Second:

WITH(FIELDTERMINATOR = ',',ROWTERMINATOR = '')--Changing row terminator.

MJ

If you have backup of yesterdays master database then restore it on test server(with new name and like normal database) and check this under the restored database:

select * from sys.server_principals

select...

Find it in the doc attached. Hope you have the backups of system databases with you.

MJ

Then try restarting it in single user mode by following the steps mentioned under this article:

http://blogs.techrepublic.com.com/window-on-windows/?p=390

HTH,

MJ

That means you are not sysadmin there. Right?

MJ

Check for any SSIS pkg or agent job running in background which drop/create linked servers and it has these RPC settings set to FALSE?

MJ

Do you want to switch roles of the primary and secondary databases?

If yes, then read Reversing Roles under http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx#EIF

HTH,

MJ