Sorry for placing this post here. I have place it in the proper area however that area of the forum only has one post ever, I am afraid it may not get looked at....

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

Should I keep persisting or can it not be done?

TYIA

__________________
Wind is your friend
Matt

Besides using linked tables, you could surely do this via ASP code, by opening two different connections in the same page. But linked tables would be *MUCH* better. Or use OPENDATASOURCE in your FROM with one of the DBs.

http://msdn.microsoft.com/en-us/libr...5(SQL.80).aspx

Here's the ref to linked servers:
http://msdn.microsoft.com/en-us/libr...9(SQL.80).aspx

Hi..
I think you should check your ASP code and sure you can get much more better result.... Thanks for sharing the post....

I disagree with Darren.

You should *NOT* do this in ASP code, if at all possible. You lose all the security and performance that you could get if you did it 100% in SQL Server.

ASP should be a last resort answer, ONLY.

Thankyou for your input. I did view ASP as a last resort, after all getting SP's lognis etc makes for a complicated approach. Scripting seems to be the best way i have found....

__________________
Wind is your friend
Matt