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 this, make...

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

Make use of COLUMNS_UPDATED()

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

MJ

During the installation, there is no opportunity to select the database instance before the setup program runs the checks and so therefore the installer must assume that the installation will...