Use the below mentioned code:

Make sure first you create a table named servers under master database with servernames in it.

GO

/****** Object: StoredProcedure [dbo].[usp_linked_query] Script Date: 08/28/2008...

What is the sql server version, memory configuration, OS and CPU utilization?

MJ

Run the following statements on all nodes and compare the same.

Select serverproperty('productlevel')

go

Select serverproperty('productversion')

MJ

How much time it takes to backup this 2GB database? Also, check the following disk counters:

See PhysicalDisk counters:

· Disk sec/Read

· ...

How much records are there in temp1 table and how much out of these are getting updated by this code? Also, for making use of the present indexes try to...

Run this:

select * from sys.service_queues

These are messages from service broker queue. It looks from message that you need to recreate the notification procedure in question.

MJ

Add that non-dba guy as an valid login on server and then he will be able to view metadata by executing sp_helptext [stored procedure name] command in SSMS.

MJ

Any changes, editing under notification tab requires sysadmin privileges.

MJ

Check for any database maintenance related operations like reindexing or so.

MJ

Restart your sql server services and see if it then displays the right version.

MJ

Which network protocols are enabled for this new instance?

MJ

What are the network protocols enabled for this new instance?

MJ

Type .\Developer Edition in server name box under management studio.

MJ

A tool to try with:

http://www.codeproject.com/KB/database/ScriptLinkedServers.aspx

MJ

To remove witness:

http://msdn.microsoft.com/en-us/library/ms366340(SQL.90).aspx

To add witness:

http://msdn.microsoft.com/en-us/library/ms365603(SQL.90).aspx

MJ