Looking for SQL Server Instance

Experts,

I'm trying to use the developer version of SQL Server 2005 that came with Visual Studio 2005 and/or 2008.  Where can I find what it's called, how to access it, etc.?

LVL 1
NigelRocksAsked:
Who is Participating?
 
DBAduck - Ben MillerConnect With a Mentor Principal ConsultantCommented:
The developer version that comes with Visual Studio 2005/2008 is SQL Express.  It does not come with tools nor does it really act like SQL Server by default, but it can be made to act like it.

To see it you would need to download SQL Server Management Studio Express from microsoft.com and the instance of sql is by default:

machinename\SQLEXPRESS
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
You can work with the attached databases ...
In your project create a new item and choose *.mdf.
Then in the server explorer (view - server explorer) you can create tables, views, stored procedures, etc.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.