Hmm, I just posted something like this yesterday...:

---

It is important to realize that there are several types of Subquery:

...

2. IN subqueries: These return any number of rows, each with a...

K. Brian Kelley (3/31/2008)

---

Think about the...

Buxton69 (3/31/2008)

---

Could you point me toward a good resource for examples of code without using cursors, I have some examples where you load a select statement into a temp table...

Matt Miller (3/31/2008)

---

Jeff Moden (3/29/2008)

---

Well said. I especially like the two rules because, if you substitute the word "RBAR" for "Cursor", I use them all the time in a...

Can you post the Job/proc?

Well, if replication is "out of synch" because it was stopped or it gets behind, it should catch up when it has a chance.

If it's "out of synch" because of...

And, if...

It's still a mystery to me why Microsoft doesn't use the same COLLATION-based character normalization before hashing that it does before normal table lookups.

You need change the Linked Server definition properties to give access on the remote server whatever context your SQL Agent Jobs run under. I usually do this by creating...

Like this:

declare @file Nvarchar(max)

set @file = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyTests.bak'

RESTORE DATABASE [MyTests] FROM DISK = @file

WITH FILE = 1, NOUNLOAD, STATS = 10

FYI, you can...

It is important to realize that there are several types of Subquery:

1. Value Subqueries: These just return a single value per row and they look like this: (Select col1...

You want to look at dynamic SQL for this.

Here is a link that explains republishing: http://technet.microsoft.com/en-us/library/ms152553.aspx

Have you looked at republishing?

Jeff, man...