I'd use linked servers, ensure that the linked server name remains the same and change where it points when necessary.

Bear in mind though, that if you use linked servers...

Vladan (9/30/2008)

---

What you are trying is not proper SQL syntax - you have to use SET, and @ with the variables... like this:

DECLARE @newvar varchar(8)

IF @APRIORITY = 1 THEN

SET...

There's a very detailed look at this in one of the chapters of the book "Practical troubleshooting: The database engine", edited by Ken Henderson. The book's well worth buying.

Take the THEN keyword out (as SQL does not use THEN in its if statements) and replace ELSEIF with ELSE IF and your query should work as you intend.

Also you...

It's actually not hard to hit on larger tables, seeing as automatically...

What do you mean by this?

Not one of that size. I believe the usual recommendation for user databases is a number of files = no more than 1/4-1/2 number of cpus. You definitely don't want...

george sibbald (9/29/2008)

---

we have a 'performance expert' in working for one of our more independent development areas and one of his recommendations is to have the no of files per...

To add to that, make sure that you have check constraints and unique constraints where applicable and that you are using appropriate data types.

Ouch. Your IO performance looks terrible. Average of 44 sec for an async IO completion with a max of 22 minutes is way, way too high.

I can't download the perfmon...

PaulB (9/30/2008)

---

I see.

Not sure how critical is the issue for you but better to get the Oracle Service Request upgraded to either sev=1 or sev=2 - in my...

That alone won't cause the log to be full, which it appears to be.

The solution is to sort out the replication and find out why you have so many undistributed...

I can't help you with the primary key. The column must be unique and not null. From what you've posted, there's not enough info to ID the primary key.

Post the...

Suspended indicates they're waiting for a resource. What are they waiting for? If they're blocked, by what process and what is that doing?

Your log reader is...