|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Management Studio Question....When using the 2005 Management Studio and connecting to a SQL 2000 Server
what happens to the databases? Meaning, if I open the 2000 Database with the 2005 Management Studio does it automatically upgrade it to 2005? Are there any rules or reference guides that will help out with this so I don't automatically update a database when supporting a customer of mine? Thanks! It doesn't upgrade the database
AFAIK there are no problems connecting to a SQL 2000 Server from Management Studio http://sqlservercode.blogspot.com/ You have to launch the SQL 2005 installer on the server and choose to
upgrade before a database gets upgraded. That is very difficult to do by accident. Connecting to a SQL 2000 system using SSMS does not upgrade the existing server or database in any way. -- Show quoteHide quoteGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Chris Marsh" <cma***@synergy-intl.com> wrote in message news:O73%23b$QSGHA.2536@tk2msftngp13.phx.gbl... > When using the 2005 Management Studio and connecting to a SQL 2000 Server > what happens to the databases? Meaning, if I open the 2000 Database with > the 2005 Management Studio does it automatically upgrade it to 2005? Are > there any rules or reference guides that will help out with this so I > don't automatically update a database when supporting a customer of mine? > > Thanks! > Excellent - then I can just use the one set of client tools and remove the
SQL 2000 client tools from my machine. Thank you! Show quoteHide quote "Geoff N. Hiten" <SQLCrafts***@gmail.com> wrote in message news:e5lw4HRSGHA.4976@TK2MSFTNGP11.phx.gbl... > You have to launch the SQL 2005 installer on the server and choose to > upgrade before a database gets upgraded. That is very difficult to do by > accident. Connecting to a SQL 2000 system using SSMS does not upgrade > the existing server or database in any way. > > -- > Geoff N. Hiten > Senior Database Administrator > Microsoft SQL Server MVP > > > > "Chris Marsh" <cma***@synergy-intl.com> wrote in message > news:O73%23b$QSGHA.2536@tk2msftngp13.phx.gbl... >> When using the 2005 Management Studio and connecting to a SQL 2000 Server >> what happens to the databases? Meaning, if I open the 2000 Database with >> the 2005 Management Studio does it automatically upgrade it to 2005? Are >> there any rules or reference guides that will help out with this so I >> don't automatically update a database when supporting a customer of mine? >> >> Thanks! >> > > I would leave the SQL 2000 tools in place. There are some things that SSMS
doesn't do that Enterprise Manager does. The tools exist comfortably side-by-side, just like the servers. -- Show quoteHide quoteGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Chris Marsh" <cma***@synergy-intl.com> wrote in message news:%23CaOE8RSGHA.4740@TK2MSFTNGP14.phx.gbl... > Excellent - then I can just use the one set of client tools and remove the > SQL 2000 client tools from my machine. Thank you! > > "Geoff N. Hiten" <SQLCrafts***@gmail.com> wrote in message > news:e5lw4HRSGHA.4976@TK2MSFTNGP11.phx.gbl... >> You have to launch the SQL 2005 installer on the server and choose to >> upgrade before a database gets upgraded. That is very difficult to do by >> accident. Connecting to a SQL 2000 system using SSMS does not upgrade >> the existing server or database in any way. >> >> -- >> Geoff N. Hiten >> Senior Database Administrator >> Microsoft SQL Server MVP >> >> >> >> "Chris Marsh" <cma***@synergy-intl.com> wrote in message >> news:O73%23b$QSGHA.2536@tk2msftngp13.phx.gbl... >>> When using the 2005 Management Studio and connecting to a SQL 2000 >>> Server what happens to the databases? Meaning, if I open the 2000 >>> Database with the 2005 Management Studio does it automatically upgrade >>> it to 2005? Are there any rules or reference guides that will help out >>> with this so I don't automatically update a database when supporting a >>> customer of mine? >>> >>> Thanks! >>> >> >> > >  
Other interesting topics
Deadlocks "again"
Move DB by backup/restore or SP_Detach? How to "Grant" a Trigger ??? IN clause with comma seperated values in select query Table comparison what kind of index to use in this situation. Add User to Log-Shipped Database sqlserver 2005 express license Licensing by the month? MSDE 2000 problems with linked server |
|||||||||||||||||||||||
