1> use northwind
2> go
Msg 911, Level 16, State 1, Server XP-PRE3A\SQLEXPRESS, Line 1
Could not locate entry in sysdatabases for database 'northwind'. No entry found
with that name. Make sure that the name is entered correctly.
1> use pubs
2> go
Msg 945, Level 14, State 2, Server XP-PRE3A\SQLEXPRESS, Line 1
Database 'pubs' cannot be opened due to inaccessible files or insufficient
memory or disk space. See the SQL Server errorlog for details.
Done by OSQL. The ERRORLOG is not updated. (located in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG)
And why (to hell) is this file without an extension? To enshure nobody can make notepad default editor? NONSENSE! ( yes i know was the same in earlier versions like sql server 2000)
Surprising fact: with visual Studio 2005 database project i can open the PUBS.MDF and NORTHWIND.MDF. Also view and edit the data.
My next station was the SQL Express Manager which is available as newer build for SQL Express April CTP which is shipped with Visual Studio 2005 Beta 2.
http://lab.msdn.microsoft.com/express/sql/
I see in the list (under databases) the pubs database with status shutdown and not the northwind. I tryed to start a sql command like select * from authors. Got an error
Database 'pubs' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (.Net SqlClient Data Provider)
Also nonsense, the error is not logged.
Everything done with integrated security.
Subject=Summary
[UPDATE]
I have uninstalled a deactivated ISA Client and now i have new error message and partial success
1> use pubs
2> go
The Service Broker in database "pubs" will be disabled because the Service
Broker GUID in the database (27968DAA-A052-4A1C-98A3-229A3EC0B3CC) does not
match the one in sys.databases (74E4B7CB-BEFA-4A0E-A2B5-654B0DA96553).
1> select * from authors
2> go
au_id au_lname au_fname
phone address
city state zip contract
----------- ---------------------------------------- --------------------
------------ ----------------------------------------
When i open pubs with visual studio i can not access at the same time pubs with osql
1> use pubs
2> go
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\
MSSQL\DATA\pubs.mdf". Operating system error 32: "32(Der Prozess kann nicht auf
die Datei zugreifen, da sie von einem anderen Prozess verwendet wird.)".Unable t
o open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DA
TA\pubs_log.LDF". Operating system error 32: "32(Der Prozess kann nicht auf die
Datei zugreifen, da sie von einem anderen Prozess verwendet wird.)".Msg 945, Lev
el 14, State 2, Server XP-PRE3A\SQLEXPRESS, Line 1
Database 'pubs' cannot be opened due to inaccessible files or insufficient
memory or disk space. See the SQL Server errorlog for details.
File activation failure. The physical file name "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\pubs_log.LDF" may be incorrect.
The reason is once again the diffrent security credentials which are used to start SQLExpress. I have two instances running. One with Network service and one with admin accout.