Do you still see pkey and fkey relation on tht table? If yes then check sysobjects table for their creation date. It might have happened that someone dropped it and...

Clive,

That script is not mine(lol). I got it from this site only. Hope script works ok for Tara and saves her time and effort.

Manu

We might go foolish too. Please share the solution.

Thanks,

Manu

http://icu-mscrm.blogspot.com/2009/02/how-to-uninstall-sql-server-2008.html

When you start to uninstall SQL Server, you will be presented with options allowing you to choose which features of SQL Server you wish to remove. Before doing...

Tara,

Try the below mentioned script on test instance first. Also, you need to create a table named 'backupTable' under master database which will hold names of databases to be restored....

Try:

exec sp_trace_setfilter @TraceID, 10, 0, 7, N'REPLICATION MONITOR'

exec sp_trace_setfilter @TraceID, 11, 0, 6, N'e%'

Hope this works!

MJ

Recover the master database in SQL Server

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

MJ

What exactly you want to flter out?

Mj

What do you mean by restore resource database when instance is stopped?

MJ

Hoes it resolved then?

MJ

Is any of your stored procedure making use of NOCOUNT ON?

MJ

Did you try my script?

MJ

Try the below one(found it here only):

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[usp_DeleteOldMaintenancePlanLogFiles]

-- 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\', 17

@basedir...

Experts please comment.

MJ

Read section 'Running Multiple Instances of SQL Server' at

http://msdn.microsoft.com/en-us/library/ms178067.aspx

MJ