Thanks a Ton for your extended help!!!

I don’t know how much I understood but I am assuming that

DBCC SHRINKDATABSE, will try to move all the pages from the Higher...

Cant Believe my Eyes .. 🙂 Thanks a ton for the Reply / Help.

My Build is 9.00.3186.00.

We were not using online index operations, MARS, DML triggers at the same time...

Gail,

Thanks for the reply, As the Year-End procedure before making a database READONLY we Shrink it.

There is no error in DBCC CHECKDB output, the first thing I ran after...

Thanks Henrico Bekker.

Where I can found more about Azure related to SQL Server in detailed (Whitepaper).

Thanks,

Raj

Thanks a lot EdVassie.

Any kind of AD level changes and trusting other domain needs changes approved from top .. so i don't think its going to be get approved....

Just Adding More Weight .. Pushing it to top... 🙂

Is there any solution for the above.

Thanks,

Raj

M.I.

Thanks a lot 🙂

I got it.

Thanks,

Raj

SELECT * FROM msdb.dbo.sysjobactivity

WHERE job_id IN (

SELECT job_id FROM msdb..sysjobs WHERE name LIKE '%%')

It will say me the step details, i want to know what exact SQL Syntax its running.

Thanks,

Raj

Thanks, I know, but my SQL Handle is null...

Thanks a lot. For the Help!!!

Regards,

Raj

Terry B

I had a BioTech client, they had purchased AMD and the some value was mismatching from Intel to AMD, check that if not that the case with you for...

Sourav,

You will get your answers from the below link

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

Same you will get if you search deadlock in book online.

Thanks,

Raj

Sourav,

Good to hear that!!!

Any Data corruption or unwanted problem after failover?

Thanks

Raj

Gail Shaw

You are right, waiting is better than recycling.

I think we can control all these by restricting ADHOC and untested queries on PROD.

I have faced the problem in DEV /UAT...

Laszlo

What type of cluster is this, AA or AP?

Thanks

Raj