Tag Info

New answers tagged

2

I would like to post this as answer what is point in upgrading to SQL server 2000 which is outdated completely without any support. Even it is not good for testing purpose. Its like using typewriter in era or super computers. Dont uninstall personal edition first. Install enterprise move databses by backup restore method. If you restore master msdb ...


0

The best explanation is given in the PSS blog How It Works: Orphan DTC Transaction (Session/SPID = -2): Let me clarify the term Orphaned. A -2 is not Orphaned it means there are NO ENLISTED SESSIONS on the SQL Server but the transaction is active yet. Let me give you can example. Begin DTC Transaction with DTC Transaction Manager ...


2

How to get the 8.00.194 (!!!!!!) server to 8.00.2040: You can download Service Pack 4 (8.00.2039) from here, which you will need to install before you can install the 8.00.2040 hotfix. How to restore a 2000 .bak to a 2008 server: You may need to clarify your actual requirements and clean up the question, but if you are trying to ultimately restore a SQL ...



Top 50 recent answers are included