Abhay you are the best. i certainly owe you a champagne. please let me know, where do you want me to ship it? 🙂

You are amazing dude. hardly seen...

Chad - thanks for the info.

We have a large SQL footprint and if SQL 2008 can do what we need - then we want to avoid having any thirdparty's footprint...

John - thanks a million for providing you the info. The reason we are implementing the snapshot feature is to avoid blocking. the current application user base is like over...

Abhay - the article talks about running your queries on SQL 2005 as well. Please look into it and see, what am i missing?

Rajesh - if you could please post...

thanks for providing the detailed answer. indeed its very useful. i will follow the recommend solution.

thanks again,

one issue:

I registered my SQL 2008 under central management server along with another SQL 205 instance. when i try to run the query, system complains "Operation is not supported on...

Thanks for the detailed answer.

my scenarios: If i even see the blocking SPID, i can not do anything. the application code is all dynamically generated and have no control. thats...

Thanks Melton,

Thanks for modifying the cursor. Yes i wont be moving the system databases from my previous instance to new one. the newly provided script is working fine.

Thanks again for all...

Centuries thanks a million for sharing the script. it did worked in my environment and easy my migration process by a ton.

Thanks agian you guys are genius.

thanks for your contribution.

i dont have any packages on my sql 2005. i want to know, why do i see these errors?

I dont think - i believe it.

I myself ran it few times on SQL 2005 databases and it reports the following:

SQL Sever 2000 Meta data services packages are not...

Thanks for all your help.

thanks for sharing the doc. indeed its very help.