Gosta Munktell (11/11/2008)

---

HI

Hopefully you are aware of the problems with format when you import data from Excel

with DTS or SSIS. I would do the pattern matching in VBA and save...

how are you determining which rows to delete?

I would create a delete process using a 'while loop' or something similar, so that you end up deleting batches of...

create view COMMITTEE

as

select COMM_ID,

COMM_NAME,

...

You only need to wrap the value in single quotes:

declare @ab varchar (100)

set @ab='483503'

select * from tm_temp_empmastall where employeeid=@ab

yes, statistics were updated, I went ahead and did it again. It didn't make a difference.

I created a copy of the remote data locally on the 2005...

Lynn Pettis (11/4/2008)

---

Try this:

with ParentCommittee (

CommID,

CommName

) as (

select

comm_id,

comm_name

from

Committee

)

SELECT

...

Neither of the last two suggestions helped. Any other suggestions?

Also, I appreciate the help, this issue is driving me nuts.

Garadin (11/3/2008)

---

So if you remove the Order By, it functions the same...

Lowell (11/3/2008)

---

in my experience, when the same query doesn't run right on two different servers, i check two items first thing: statistics and parameter sniffing.

statistics on one server might be...

No indexes to compare, the source tables are the same set...

ALZDBA (11/3/2008)

---

- Was the sql2000 query also remote and using linked servers ?

- are the linked server settings equal ?

- do the databases use the same ansi settings ?

- ...

Trust me, I would very much like to avoid them also. The decision was made at a higher level, where it was determined that a single enterprise backup solution...

One additional piece of information - our backups are handled via CommVault, and the redgate log reader doesn't seem to be able to read these backup files, which is what...

tried your suggestions, I'm still getting the same error : function 'reg' was not found in the script.