Hello all - I know this is a strage question however.....is it possible to get the data, SP's ect from SQL 2008 into an SQL 2000 instance????

Should I keep persisting or can it not be done?

TYIA

__________________
Wind is your friend
Matt

You should be able to do it. Create a linked table in the 2008 DB to the 2000 DB's table and then just use INSERT INTO.

Look at SQL Server BOL to see how to create the linked table.