• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

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.?

0
NigelRocks
Asked:
NigelRocks
1 Solution
 
DBAduck - Ben MillerPrincipal 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
 
jpaulinoCommented:
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now