One small addition to Gails reply:

If you have db-access...

You could have fetched the schema using:

select object_schema_name(parent_object_id) as TheParentSchema

, object_name(parent_object_id) as TheParentObject

, object_schema_name(referenced_object_id) as TheRefSchema

...

does your service account have the authorities to read the attached file(s) ?

edit: yes, or it should have provided the error:

Msg 22051, Level 16, State 1, Line 0

Attachment file <filename>...

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