OK I've managed to get it to work now..I still dont fully understand the changes in sql2005 but here goes for the sake of others who might find themselves in...

No I havent' I have never done that before. I thought that adding the instance name at the end would direct the request through to the right database but apparently...

I did try doing that with the Master database but as the OS is different (2003 as opossed to 2000) and it also has 2005 installed I didnt hold out...

Thanks for all the help.

I'm migrating from one windows2000 server running mssql2000 to a different server which is running mssql2000 on win2003.

I think some of my problems are that the...

Hi there,

Collation compatible is on and I have run the sp_serveroption to set it to lazy schema.

When I run a simple query still takes a long time and in the...

Dear Noel,

It is indeed an msSQL linked server. I have tried the 4 part name syntax but it is much slower (much!). I could never work out why.

Rolf

Dear David,

Hi thanks for the response, this looks like a different approach again. I couldnt make complete sense of the post though.

I'm not familiar with the syntax used to call...

Hi Ashish,

OK let me try and explain more fully what my problem is.

Firstly I used the 4 point;

Select linkedserver.schema.database.table

syntax to select data from a linked server. This works fine and...

Hehe, this is getting very retrictive!

I have just tried to use the datatype TABLE to extract the rows but of course I am now in the same position as before...

Thanks for all the replies,

I understand how to get the dynamic filter variable into the openquery command just by adding it to the execution string.

MY problem now is that it...

Hi all,

Thanks for the responses, thought I had sorted it but no!

This doesnt work;

DECLARE

@AccRef bigint, @SQLString nvarchar(2500)

set @sqlstring  =

'

SELECT @Accref = CustomerAccountID

FROM OPENQUERY(ITBUY,

''

SELECT  O.CustomerAccountID

FROM   dbo.SS_ORDER O

WHERE O.OrderID...

Sorry for the vagueness of the question posted, it was the wrong time to post the question as lots of things were still 'floating'.

I have managed to get certain changes...

Thanks for the reply.

Currently the DB is still in the 'design' phase so lots of freedom as to what is stored where.

At the minute I have used two views, one...

that is simpler but unfortunately I have no control over the lable printing app. It decides how to export the data etc.

Rolf

Thanks for all the responses. Its a fairly simple procedure..most of the details being taken care of by the dos batch file.

I am assumming that the stored procedure will not...