Thanks - this is a great summary.

I just had the same problem and found this - haven't tried it myself yet, but the comments are encouraging:

http://sqlblog.com/blogs/roman_rehak/archive/2009/05/10/issue-with-64-bit-sql-server-using-sql-2000-linked-server.aspx

One of the comments also says:

GRANT EXECUTE ON [dbo].[sp_tables_info_rowset_64]...

GSquared (9/20/2011)

tim.hulse (9/19/2011)

GSquared (9/19/2011)

tim.hulse (9/19/2011)

kokila.kondasamy (3/23/2011)

Kindly find the sample code...hope this will help u...is there any better way of performing the delete operation, kindly let us know

Declare @count int

set...

GSquared (9/19/2011)

tim.hulse (9/19/2011)

kokila.kondasamy (3/23/2011)

Kindly find the sample code...hope this will help u...is there any better way of performing the delete operation, kindly let us know

Declare @count int

set @count =0

while...

kokila.kondasamy (3/23/2011)

Kindly find the sample code...hope this will help u...is there any better way of performing the delete operation, kindly let us know

Declare @count int

set @count =0

while @count<=2000

begin

delete from...

I really needed something that did this - thanks!

Almost exactly the same reaction here too. I don't understand who this is aimed at - not the beginner, certainly. It serves little purpose for anyone else.

Thanks! Worked like a charm.

Neat! Will definitely use it.