Don't check this box. This is for when your Windows user account is passed through to the database "auto-magically." You've gone through...

Yelena Varshal (11/12/2007)

---

You can not move local Windows users and Local Windows groups. Local users and groups have SIDs that have part of the number come from the server. That...

R2ro (11/14/2007)

---

When you are connected to any SQL Server and execute a command, the command is executed on the server to which you are connected.

With that in mind, if you...

Brandie Tarvin (11/13/2007)

---

I don't know. I think the best way to secure the Server against everyone is to unplug the darn thing and lock it in a closet. ...

You don't have BizTalk in your environment, do you? If so, you may look at utilizing it. BizTalk was intended for this sort of thing.

On a related note, if you...

What error are you receiving?

tarish.velivela (11/12/2007)

---

--------------------------------------------------------------------------------------------

2. You must keep a copy of the SP somewhere else because when the master database gets rebuilt your system stored procedures will be gone. This could also happen...

If there is no primary key, another way is to SELECT DISTINCT into a temporary table, delete the original table and then INSERT the values back into the original table.

You could use a tool like Visio or ERwin to generate the database diagrams and then save them off or print them to .pdf.

Alternately, if you are in a rush and have to get the job done, Enterprise Manager can walk you through taking a backup using a GUI. However, if you're going...

Is there a reason you can't collapse the databases into a single database?

SQL Noob (11/14/2007)

---

one thing i can think they are good for is maybe reducing joins. we have queries where there is more joins than you can count and there is...

As someone else has pointed out, the only time I've seen foreign keys not be the best choice is in extreme cases due to performance. Otherwise, you want this additional...

Greg Snidow (11/14/2007)

---

I just want to make one thing perfectly clear. I am not to be included with the experts :). My knowledge of SQL is only the...

Check to see that the service account SQL Server is running under has permissions to modify those files (you'll have to check the files individually). You should see the...