Confirm is no primary key or unique index with "ignore_dup_key = on" or "instead of" triggers.

Also, what happens if you simply SELECT .. INTO <table> ?

dlsilsbury 63952 (5/28/2015)

---

Eric M Russell (5/27/2015)

---

Thanks, I understand this...

The default timeout can be overridden at connection or command level within VB programming code.

http://stackoverflow.com/questions/1354271/timeout-setting-for-sql-server

This is not a MS Access forum and a database is not a bowl of fruit, but here is how you exclude specific rows from a SQL query.

select Fruit

from...

GETDATE() returns local time and GETUTCDATE() returns UTC time.

One of the advantages of a medieval style IT shop, where the rules are not spelled out on paper, is that you as the DBA can simply lord it over...

Depending on the organization, I'm not opposed to allowing Developers read-only access to production, especially if they are expected to wear the Data Analyst hat on occasion. Even more advanced...

No. System views are those distributed with SQL Server. There is rarely a reason to mark...

Kyrilluk (5/27/2015)

---

Eric M Russell (5/27/2015)

---

Jeff Moden (5/27/2015)

---

Kyrilluk (5/27/2015)

---

Eric M Russell (5/26/2015)

---

Kyrilluk (5/26/2015)

---

It would be nice to have this scientific method to all the blab about security as well. Like "I...

Kyrilluk (5/27/2015)

---

Eric M Russell (5/27/2015)

---

Kyrilluk (5/27/2015)

---

Eric M Russell (5/26/2015)

---

Kyrilluk (5/26/2015)

---

It would be nice to have this scientific method to all the blab about security as well. Like "I shouldn't give...

Jeff Moden (5/27/2015)

---

Kyrilluk (5/27/2015)

---

Eric M Russell (5/26/2015)

---

Kyrilluk (5/26/2015)

---

It would be nice to have this scientific method to all the blab about security as well. Like "I shouldn't give the sysadmin...

Kyrilluk (5/27/2015)

---

Eric M Russell (5/26/2015)

---

Kyrilluk (5/26/2015)

---

It would be nice to have this scientific method to all the blab about security as well. Like "I shouldn't give the sysadmin password to...

robin.pryor (5/26/2015)

---

The company I work for insists on being really liberal with db_owner. For the most part, that's not a problem, but security is an issue. Is there a way...

Luis Cazares (5/26/2015)

---

Eric M Russell (5/26/2015)

---

A simple CAST operation from date/time to date won't necessarily prevent usage of an index on a date/time column. For example, given the following table...

I'm not understanding your usage of that WHERE clause.

The syntax for a joined update is basically the following:

UPDATE A

SET ..

FROM A

JOIN B ..

WHERE ..