Now when I open SQL Server Management Studio it runs the SQL version 8 that belongs to SQL Server 2000.
How can I start with SQL Server 2005 (SQL 9.0) to create new database under the new features?
thank you.
First, register the SQL 2005 instance...click 'view...registered servers'...then, in the registered servers window, register your SQL 2005 instance appropriately.
Once you've registered the server, right click on it and choose 'connect...object explorer'. If the Object Explorer pane isn't viewable, make it so by choosing 'view...object explorer' from the menus. Then, in Object Explorer simply expand the instance to view all objects, nodes, etc.
HTH
|||Thanks Chad,
I have two Instances of SQL Server. one is ServerName which is based on SQL 8.0 (2000) and another one is ServerName/SQLEXPRESS based on SQL 9.0.
If I want to work with features in SQL Server 2005 I have to choose SQLEXPRESS instance.
I don't sure about SQL Server Express edition. only I know it has fewer features rather than SQL Server 2005 Enterprise edition.
I really want an instance of SQL Server 2005 Enterprise edition.
What can I do?
Thanks Chad.
|||I see. Well, if you're going to use the instance for development use only, your best bet is to get a copy of the Developer Edition, which is exactly the same as the Enterprise Edition, however it is not licensed for commercial/production use, only developmental/test/demo use.
If you want an Enterprise Version, then you'd need to purchase it.
Alternatively, you could download a 180-day trial version for free as well.
Do you have an MSDN subscription? If so, you can download the developer edition and use it. If not, you'll have to purchase it as well.
Go here for more information on the developer edition, trial edition, and information on how to get them:
http://www.microsoft.com/sql/editions/developer/default.mspx
HTH
No comments:
Post a Comment