I am wondering: what were you looking for?

Try this:

ALTER DATABASE [abc123] SET MULTI_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE [abc123] SET READ_WRITE WITH NO_WAIT

GO

Post your query results.

Hope it Help you

You must be very careful using the Batch Separator Sentence: GO

If the previous batch failed, the result will be an error message, and the next batch will be executed. Example:

USE...

Hello saidapurs, you must be careful when changing the service's login user; you must disable the "password expiration policy" from those users (local and destination server's users) in order to...

May be a recently installed software or update.

If you are using a PC, you can backup the OS partition and restore a backup before you installed the software or update...

Hello Gail, you are right... I completely forgot about that. :(... I remember that I had to put it on Emergency Mode in order to recover data, because, we...

I had a similar problem. The only way, to stop it, was: doing a data migration to a database created directly on the instance with the compatibility level according to...

SQL Server 2008 R2 has an Repair option in the installation wizard, it re-creates master and tempdb databases... i used it a few months ago and helped me a lot.

Hope...

If only the Log File is corrupt you could try to attach only the Data File with:

sp_attach_single_file_db [@dbname=] 'dbname', [@physname=]'physical_name'

Example:

sp_attach_single_file_db @dbname='DataBaseName', @physname='C:\SQLServer\Data\DataBaseName_Data.mdf'

Edit :w00t::

you must Stop the Production SQL Server Instance...

First: Check Data Types

Second: you must be sure the destination table has an identity column :w00t: and be sure you include the identity column in the list of columns you...