tmummert (6/27/2013)

---

I'm trying to insert rows into a table that has multiple constraints. My statement is failing because SQL is looking at the first constraint field and sees that...

aiki4ever-796329 (6/27/2013)

---

/* I'm trying to change "not in" to "not exists" and I don't have the syntax quite right. The first statement updates multiple rows

while the second statement updates...

Without seeing what you can query, my guess is that the SID of the user didn't match the SID of the login. If you run the following queries, the...

I like the idea of having interviewers conduct interviews of some existing employees. We have to be able to separate a strong candidate who interviews poorly from a weak...

What is the default database of the user being used to connect? If it is a database that doesn't exist, the connection will fail. I've seen this with...

If the database being updated is on the same instance now, was it also on the same instance before the migration? If not, see if you're using a linked...

Is the somedate_column indexed? What indexes do you have?

Most modern health care systems I know of use normal database formats like Oracle or SQL Server. In ages past, some used flat files or a proprietary storage mechanism,...

If I'm interpreting your question correctly, you're looking to set up a database of customers and include phone numbers. That part is pretty simple. All you'd have to do...

Test posting a url Bing to see if it'll open once posted.

Steve Jones - SSC Editor (6/14/2013)

---

Lynn Pettis (6/14/2013)

---

***************************************************

I am officially going to Afghanistan!

I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well...

If you have the system tables on the original server and kept the same filenames and directory structure on the new server, you might be able to use a SELECT...

I think he's saying that it runs fine when run locally but slowly when running against a linked server. This makes complete sense due to the fact that linked...

This is a duplicate post of http://www.sqlservercentral.com/Forums/Topic1462710-391-1.aspx.

I see you used the word "patient" in your original post. Don't post any patient data!

Posting patient data in a public forum is very serious and would likely cost...