how are you loading the data?

as GSquared has already pointed out you must set identity_insert on within the same session

in fact, don't start SQL Server in single user mode by modifying the startup parameters, stop the service and then use the command prompt to start your instance in single...

to find the Windows process id for an instance of SQL Server you can also use SQL Server configuration manager 😎

Minaz Amin (11/5/2011)

---

Iam not able to bring the MSDTC resorce online. This is on windows 2008 R2 (SP1). I have create computer objects permission and manually also I have created...

Everything Ok up to here

Just install the database onto the physical...

Don Bricker - Illinois (11/1/2011)

---

This is not the most elegant way, but it should work. Export all data to a temp table (identical structure as the original including identity field)....

the .NET framework is required for SSMS to be available!!

no, clusters are essentially mutli master

Seems good to me, although

The sql server installation routine takes care of this for you,...

you can't, the transaction log is used to recover the database during a restart!

.log?

is this an IIS issue?

You dont turn off logging to the SQL Server database. It sounds to...

/X:destination

rcaers (10/31/2011)

---

Hello,

I get the same error. Don't know what went wrong (it worked just fine), but when I now open SSMS I get the same error. Do you have a...

take your point but dont agree.

we'll agree to disagree on this one 😉

safeguard against what?

Presumably you mean you have RAID drive configurations not servers?

RAID is used for redundancy and performance,...