2005/2000 question!

Hi I have both sql 2005 and 2000 installed on a machine. When I start
management studio it can connect to legacy 2000 databases. What I want to do
is create a new database with all of the 2005 attributes. Is there a way to
put management studio in a mode where it will create a new 2005 database and
have all of the 2005 features with 2000 still on the machine?
thanks.
--
Paul G
Software engineer.SQL Server 2000 and SQL Server 2005 can coexist on the same machine
without problem, but only one can be the default instance. The
default instance is the one that will be referenced when only the
computer name is supplied. There can be one or more named instances
for each version of SQL Server, but referencing those requires
computer_name\instance_name.
Having said that, Management Studio can work with any instance of 2000
or 2005. Open the Registered Servers window and make sure there is an
entry for every instance on the machine. When you want to create a
new database "with all of the 2005 attributes", choose a SQL Server
2005 instance from this list, right click and choose Connect / Object
Explorer. In the Object Explorer window, right-click on Databases in
a 2005 instance and choose New.
Roy Harvey
Beacon Falls, CT
On Mon, 24 Sep 2007 09:02:08 -0700, Paul
<Paul@.discussions.microsoft.com> wrote:
>Hi I have both sql 2005 and 2000 installed on a machine. When I start
>management studio it can connect to legacy 2000 databases. What I want to do
>is create a new database with all of the 2005 attributes. Is there a way to
>put management studio in a mode where it will create a new 2005 database and
>have all of the 2005 features with 2000 still on the machine?
>thanks.|||On Mon, 24 Sep 2007 09:02:08 -0700, Paul wrote:
>Hi I have both sql 2005 and 2000 installed on a machine. When I start
>management studio it can connect to legacy 2000 databases. What I want to do
>is create a new database with all of the 2005 attributes. Is there a way to
>put management studio in a mode where it will create a new 2005 database and
>have all of the 2005 features with 2000 still on the machine?
>thanks.
Hi Paul,
I have both SQL Server 2000 and SQL Server 2005 running on my machine,
and I use SSMS to connect to both. When connected to SQL Server 2005, I
can use all the new features. When connected to SQL Server 2000, I am
obviously limited to the old feature set.
So if you connect SSMS to your SQL Server 2005 instance, you should be
able to create new SQL Server 2005 databases without problems.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis|||Hi I did not see an entry for the 2005 instance. I also opened the SQL
Server Configuartion manager and it lists the following, 1. SQL Server 2005
services, 2. SQL Server 2005 Network config, 3. SQL Native client config.
Wondering if there is something I missed in the installation?
thanks.
--
Paul G
Software engineer.
"Roy Harvey (SQL Server MVP)" wrote:
> SQL Server 2000 and SQL Server 2005 can coexist on the same machine
> without problem, but only one can be the default instance. The
> default instance is the one that will be referenced when only the
> computer name is supplied. There can be one or more named instances
> for each version of SQL Server, but referencing those requires
> computer_name\instance_name.
> Having said that, Management Studio can work with any instance of 2000
> or 2005. Open the Registered Servers window and make sure there is an
> entry for every instance on the machine. When you want to create a
> new database "with all of the 2005 attributes", choose a SQL Server
> 2005 instance from this list, right click and choose Connect / Object
> Explorer. In the Object Explorer window, right-click on Databases in
> a 2005 instance and choose New.
> Roy Harvey
> Beacon Falls, CT
> On Mon, 24 Sep 2007 09:02:08 -0700, Paul
> <Paul@.discussions.microsoft.com> wrote:
> >Hi I have both sql 2005 and 2000 installed on a machine. When I start
> >management studio it can connect to legacy 2000 databases. What I want to do
> >is create a new database with all of the 2005 attributes. Is there a way to
> >put management studio in a mode where it will create a new 2005 database and
> >have all of the 2005 features with 2000 still on the machine?
> >thanks.
>