I just tried it and it seems to work ... at least the tables and triggers appear in Enterprise Mgr. I need to take two steps before I'm home free:
(1) Do some basic Q/A attaching my app to SQL Server 2K (may have some "Personalization" DB issues).
(2) Upload it to my hoster (GoDaddy) and make sure it runs properly.
Thank you so much for pointing out this feature in SQL Server Express. I have spent many hours today trying to manually edit a script file, generated in SQL Server Express, in a futile attempt to get it to run in SQL Server 2K Query Analyzer. Thanks again;
I really appreciate your help!
melvinsb1
Member
80 Points
16 Posts
Re: Convert Sql Server 2005 to Sql Server 2000
Jul 18, 2006 08:39 PM|LINK
I just tried it and it seems to work ... at least the tables and triggers appear in Enterprise Mgr. I need to take two steps before I'm home free:
(1) Do some basic Q/A attaching my app to SQL Server 2K (may have some "Personalization" DB issues).
(2) Upload it to my hoster (GoDaddy) and make sure it runs properly.
Thank you so much for pointing out this feature in SQL Server Express. I have spent many hours today trying to manually edit a script file, generated in SQL Server Express, in a futile attempt to get it to run in SQL Server 2K Query Analyzer. Thanks again; I really appreciate your help!