You'll have to explain more. What do you mean by updateable with filters?

I assume filters mean that you are producing a publication that joins data from two or more tables...

This help? http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/89eb8038-68a6-4201-a784-aa0063f4d8c0

Looks like you are missing a paren in your subquery before the NOT IN

novak 32871 (5/3/2012)

---

I know but there is already SQL 2012 out. It is good exercise but 2000/2003 has it's age and most of clients already moved. But I understand your...

The distributor is usually the issue. It must be equal to the publisher, so from 2008 -> 2005, you need a 2008 distributor.

Thank you.

So could APL, but it was PITA to read.[/quote]

Arrgggghhhh, I think I disliked APL more than any other language. Neat idea, raised...

Did you get any of the scripts from Chad's article working? Those show you how to connect to SQL Server and run something.

From there, you might look over this...

I would think that you aren't under memory pressure, but you'd have to look at more than this. Check target server memory, check the disk activity for how pressured it...

zintp (5/2/2012)

---

I agree with your post, but have trouble reconciling it with the Modern Resume, which suggests blogging, tweeting, and speaking about your professional life, in addition to the work...

gert.j.kruger (5/2/2012)

---

For SSD Raid 1+0 configuration I have been advised by our hosting company that the total storage space is different than for traditional drives. My understanding is that...

If you converted it over to a varbinary, you need to convert it back.

DECLARE @c VARCHAR(20), @b-2 VARBINARY(max), @d VARCHAR(20)

SET @c = 'Test'

SELECT @b-2 = CONVERT(VARBINARY(MAX), @c)

SELECT @d = CONVERT(VARCHAR(20),...

Is the old server still running?

Is this x86 (32bit) or x64?

If you have specific questions, we can help, but spend a little time on those articles and you should be able to put something together.