Alternatively, we can use this too.. it takes about an hour to delete a million records

set rowcount 50000

DELETE FROM EventTracking.dbo.Event

while @@rowcount>0

begin

set rowcount 50000

DELETE FROM EventTracking.dbo.Event

END

set rowcount...

Hi SSCrazy -

In that case, please explain about the filegroup restoration chain..:-)

Nothing worked except the below mentioned solution.

Open command prompt as Administrator and enter the following commands

C:\> net stop msdtc

C:\> msdtc -uninstall

C:\> msdtc -install

followed by server restart..

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/eb4eda65-1759-4266-a304-1f34c4b93680/%5B/url%5D

http://36chambers.wordpress.com/2011/04/08/msdtc-no-transaction-is-active/%5B/url%5D

this worked for me. many thanks.

It will be helpful if someone could let us know about the reason for such corruption. If master DB is corrupted how will the WMI component too got corrupted? Is...

migration is to migrate a database from sql server to oracle/mysql or any other database server...

upgradation will refer to upgrade the sql server from sql server 2000 to 2005