I am moving a database from an old box to a new box, I used a "Copy SQL Server Task" to move the data only. We have done extensive work...

thanks, I have already done that but what I was missing was that we have 25 gigs of data in that database.... not sure how we got that much in...

This is a the discription of the error message I get, the odd thing is that I am not trying to connect to an Access database I am trying to...

Steve this is the code that I have tried most recent but I have tried every ideration in the help file.

USE master

GO

EXEC sp_addlinkedserver

'SQLPROD_PRDCPY',

...

Thanks Andy that worked perfectly.... I am also trying to setup linked servers now... looks like something that could help us with other issues that we are having....:o)

Steve Johnson

No error, and no data is posting to the destination field

Steve Johnson

Good Idea.... though I have already tried this...:)

Steve Johnson

That is correct

Steve Johnson

Yes it does work to a text file and I have started to lean that way..... reluctantly because I feel that if the data will show up in a msgbox...

In Progress you can create a field ("meatcost") then assign an extent of (1-12) to the field, you might know this as an array. In this case we have a...

Thanks

Steve Johnson

[This data has been summurized for a data warehouse, I didn't design or create it I am just tasked with moving it from one envroment to another]

Im curious too -...