Yes , it is.

Lowell (8/14/2012)

---

linked servers are slow for updates; it's usually because the far table (which might be huge) gets copied over into a local temp table, then the data is merged...

Lowell (8/14/2012)

---

lets double check some settings...by abstracting out your code to be anonymous (SERVERA and SERVERB, something got lost, i think.

first, i don't think its necessary to use EXECUTE AT.

you...

I have finally been able to resolve this. It seems like the query is running very slow from machine A compared to machine B & C. I increased the...

yes.

the set up is the third one "Be made uisng the login's current_security' context

Gazareth (5/3/2012)

---

On the security page of the linked server properties, are any impersonated logins setup, and which option is selected in the 'For logins not defined in the list above,...

GilaMonster (4/30/2012)

---

Deadlocks don't cause timeouts.

Timeouts are a client-side setting and happen when the client decides that SQL Server is taking too long to run a query, and the client aborts...

Checked. It is not.

I tried that..got the following error

The server principal "xyzINC\SVC_SQL" is not able to access the database "mydatabase"...

I thought so and did grant Execute permission but still got the same error.

Lynn Pettis (3/12/2012)

---

Guras (3/12/2012)

---

The database size of one of our databases is 75GB ( though it still has 30G more free space) and it is growing fast. I am looking...

baabhu (3/11/2012)

---

Hi Guras,

Did you manage to figure out what is the issue.

if not, can you please share the scritps that you use to log the db size and...

No, the Autoshrink is not ON. Thank you for checking though.

I have a reindexing maintenance jOb that runs early in the morning at 4 but here the time when the database shrunk is between 8 and 11 morning. The maintenance...