Thank you for your feedback.

Strange indeed that removing the pk would "solve" the issue.

- Can you find messages (that you can relate to your setup) in the sqlserver errorlog file ?

- did you run the troubleshooting scripts ? http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/

Jeff Moden (8/1/2010)

---

I actually don't believe it's a homework assignment...

Remote connections ?

- to linked servers ?

- for your applications ?

Did you enable TCP/IP for your instance ? Use Server configuration manager to enable tcp/ip.

bitbucket-25253 (7/31/2010)

---

Been there, in fact that is what introduced me to SQL Server back in the 7 days. Although it was rough going, and gave me a head full...

Correct ... but ...

What...

The way you're trying to handle the problem seems a bit awkward to me from an DA perspective.

- Why don't you just ad a "presentation_order" column and update that one...

can't you just drop the FK constraint on the dependant table(s) ?

Make sure you have scripted all PK/FK constraints you need for this operation.

play it safe, start...

I've seen that with offline databases being dropped, the files weren't removed. (I should test with which version this was)

I've also seen that when dropping a big database, but...

Don't use 'sa' for ANY login !! This is a worst practise !

If this is within the same domain, just use a windows service account to configure the mirroring stuff.

Use...

Wouldn't it be a wise idea to first test a little bit with the technology ?

- So you know how to:

* put...

Here's a nice example : Merge Demo by Bob Beauchemin

Sql server management studio.

Enable "include actual execution plan" to get the execution plans [Query\include actual execution...

Who am I ? Sometimes this is me[/url] :alien: and most of the time this is me :hehe:

Paul White NZ (7/29/2010)

.. but I was looking for the plan...

Missed it !

Here's the index(0) execution plan.

And the new full executions plan.

execution stats: ( time and io ON )

SQL Server parse and...