Try that and let us know the outcome. I posted tht a minute back after posting my previous reply.

MJ

Check whther AUTO SHRINK option is turned on for this database or is there anyone else running shrink command on it(check sp_who2 output).

MJ

try this.....

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFERS

MJ

If you don't want to restart then clear the procedure cache, I know it affects the performance but ..... If possible try tht.

Also, do u see too many unparameterized...

Can you include SET NOCOUNT ON in your SP(if its not going to brk anything) and see if tht helps.

Also, do u see too many unparameterized queries hitting ur...

I would prefer second method as it will prevent failover.

If u dont click on checkboxof agent while taking agent offline then cluster will failover..

is that rite?

Right.

MJ

After you install SQL Server, you can use "SQL Server 2000 Licensing" in Control Panel. Double click on it and check that.

HTH!

MJ

Thanks for answering it Gail.

Manu

Gail,

What do we need to search for in case we manage to open the .mdf file in any HEXEditor?

Thanks in advance,

MJ

As i told you make it a member of sysadmin role and then it will allow u to execute this query.

MJ

I think this user is not a valid user under master database. Add it there and if this login id is not a sysadmin and there is no proxy account...

Why don't you try attaching it to sql 2005 test instance and check the compatibility level of db after attach?

MJ

Why not watch a video-->http://www.jumpstarttv.com/clustering-sql-server-2005_33.aspx

Free registration required.

MJ

Is there any option to use STATS keyword in redgate restore command like SQL has.

--Monitoring Options in Restore Command

| STATS [ = percentage ]

MJ

Add user to windows group named "SQLServer2005MSSQLUser$ServerName$SQLServerInstanceName" and login to machine with that account and login to sql server and try to change the password for "sa" account. Hope this...