Just installed SQL SRV 2012 Express. Opened Server Management Studio and created a server registration to my old SQL SRV 2000 databases for testing.
Everytime I create a new database it is created in 2000. I have tried deleting the registration and adding a new registration. Closed management studio and retried steps above. No matter what I do, when I add a new registration, it connects to the old 2000 databases.
Have searched helps docs but find nothing pertinent.
Can somebody suggest the steps to delete the 2000 registration and create a new 2012 registration?
The server name for SQL 2012 Express would be something like (local)\SqlExpress. However, I am only guessing here - to find out for sure, Start -> Run -> Services.msc and look for the SQL Server process. It would say something like SQL Server (SQLEXPRESS). That thing in the brackets - SQLEXPRESS in this example - is what you should use as the server name - (local)\SQLEXPRESS in this example.