Anything suspicious in cluster log file?

MJ

Please specify the monitor server edition and version.

MJ

Run profiler and see exactly where in job the code is stalling.

MJ

What message do you get when you execute "Use DBNAME" in management studio?

MJ

In my case this worked:http://support.microsoft.com/kb/942861

Risk is involved here as registry needs to be touched upon.

MJ

In 2005 if you have default trace running in background run the below mentioned code with the log file location as per your system:

SELECT

trc_evnt.name

,dflt_trc.DatabaseName

,dflt_trc.ApplicationName

,dflt_trc.TextData

,dflt_trc.FileName

,dflt_trc.LoginName

,dflt_trc.StartTime

FROM fn_trace_gettable('F:\SQL2005\MSSQL.1\MSSQL\LOG\log_313.trc', NULL) AS dflt_trc

INNER JOIN sys.trace_events...

Give this a try:

declare @sql varchar(8000)

Declare @DB_Objects varchar(8000)

Select @DB_Objects = ' name COLLATE DATABASE_DEFAULT as [Name]

From %D%.dbo.sysusers where uid not in (16384,16385,16386,16387,16389,16390,16391,16392,16393)and sid is not null

'

Select @sql = 'SELECT DBName,Name...

Make sure that the useid has "Log on as service" right. Rest try to start from command prompt. Also, sql server must be started at that time.

MJ

select st.name,sc.name from

sys.all_columns sc join sys.tables st

on st.object_id=sc.object_id

order by st.name

HTH!

MJ

Anything in cluster log file(cluster.log)?

MJ

I think you are running this statement in 2005 as this is 2000 forum. Also, is sql server instance started against which you are executing this query?

MJ

Complete query:

SELECT

object_name(I.[object_id]) AS tableName

, I.[name] AS indexName

, ...

No change in 2005 too.

Mj

Do you have more than one sql server instance running on your machine?

MJ

It depends on whether you have downtime or not. 1st technique requires downtime and also databases won't be avaiable on source instance once they are detached.

Backup/Restore process can do your...