May 24, 2005 at 2:36 pm
I have detached some databases from the Enterprise version of SQL Server 2000 SP3
and have attached them to Standard version of SQL Server 2000 SP3
Should I expect any problems?
TIA
May 24, 2005 at 4:19 pm
You should expect smooth sailing.
mom
May 25, 2005 at 1:18 am
Only the features that are supported by Standard Edition will be functioning though.
For example, if you created an Indexed View in the database while it was on Enterprise Edt, the view will still operated under Standard Edition, but the index will not be used.
Overall your database should work identically as before, but with enterprise only features effectively "off".
Julian Kuiters
juliankuiters.id.au
May 25, 2005 at 1:37 am
Actually, indexed views can still be used in Std Ed with the NOEXPAND hint. But they will not be automagically used by the optimizer otherwise, as they would on Ent Ed.
May 25, 2005 at 9:55 am
I would check @@version just to be sure that no post SP3 patches have been applied. That could cause some issues.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply