Visual Studio 2005

Re: SQL Server Management Studio Express does not open my database

Benson Yu - MSFT — Wed, 26 Dec 2007 03:06:55 GMT

Hi biobot,

SQL Server Management Studio Express is tool that can connect to the SQL Server instance, so that we can use it to manage the objects in the SQL Server instance. However, it can not directly the open the database file via “File | Open | File…” (except mobile database).

If you need to use SQL Server Management Studio to view othe objects in a database, the database must already been registered in the SQL Server instance. To register an existing database in a SQL Server instance, you can use “Attach” like mkamoski said.

By the way, the table you posted does show any information to us. You probably need to clarify what the object type. Is it a table or view? What’s the table name of view name? Additionally, post the column name will be helpful.

Re: SQL Server Management Studio Express does not open my database

biobot — Mon, 24 Dec 2007 03:09:01 GMT

Mark,

Great minds think alike, well anyway I did try that. This is what I'm seeing in the DB in my project's bin folder. The first row is seeded, but I don't know what the other row means? I may be wrong about my program writing to the DB?

0	11/21/07	NULL	17:30	21:00	2:30
Int32	String	String	String	String	String
NULL	NULL	NULL	NULL	NULL	NULL

Re: SQL Server Management Studio Express does not open my database

mkamoski — Mon, 24 Dec 2007 00:37:18 GMT

Have you tried "attach" in SMS?

Right-click the "Databases" node, choose "Attach", etc.

HTH.

Thank you.

-- Mark Kamoski

SQL Server Management Studio Express does not open my database

biobot — Mon, 24 Dec 2007 00:01:37 GMT

Hi,

I created a database in Visual Studio 2005 Express and the program I created seems to be writing to it OK (no errors at debug). But when I try to open the database with SQL SMS Express, I get the following error message:

"There is no editor available for 'C:\pathname\filename.mdf'. Make sure the application for the file type (.mdf) is installed."

In VS2005 Express, my database and table are visible, and the connection checks out, but the data doesn't appear. I am aware that there are two copies maintained, one in the solution folder and one in the bin, but shouldn't I be able to verify that data is being recorded to one of them?

BTW, I posted similar on SQL Forum, and was referred back to this one???

biobot