Home All Groups Group Topic Archive Search About

Stupid Question of the day......

Author
26 May 2006 5:44 AM
ljh
OK.....I'm new to this whole Visual Studio .Net 2005 thing (and .Net in
general).

I have installed Visual Studio Pro 2005 and thought that a version of SQL
Server 2005 came with it (developer edition?).  But, when I try and attach
to the local master SQL Server (using the VS 2005 IDE tools), I don't find
SQL Server or any databases at all.

I can't find any SQL Server interface that would allow me to create
databases either - but there is a C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Template Data" directory.

If SQL Server IS installed, how do I access it via an interface like I used
to access SQL Server 2000?

I think that would be the SQL Server 2005 Express edition - but will it
cause problems with what appears to be a SQL Server installation (although I
can't figure out how to access it) that may have been installed with VS Pro
2005.

I don't want to screw up my development/training PC, so how do I get a
version of SQL on my PC that I can distribute with my beginning apps?

Author
26 May 2006 5:46 AM
ljh
PLEASE IGNORE THE ABOVE POST.......NOT ENOUGH  SLEEP AND I POSTED TO THE
WRONG GROUP.


Show quoteHide quote
"ljh" <S***@where.else> wrote in message
news:IAwdg.26903$qd2.5098@bignews6.bellsouth.net...
> OK.....I'm new to this whole Visual Studio .Net 2005 thing (and .Net in
> general).
>
> I have installed Visual Studio Pro 2005 and thought that a version of SQL
> Server 2005 came with it (developer edition?).  But, when I try and attach
> to the local master SQL Server (using the VS 2005 IDE tools), I don't find
> SQL Server or any databases at all.
>
> I can't find any SQL Server interface that would allow me to create
> databases either - but there is a C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Template Data" directory.
>
> If SQL Server IS installed, how do I access it via an interface like I
> used to access SQL Server 2000?
>
> I think that would be the SQL Server 2005 Express edition - but will it
> cause problems with what appears to be a SQL Server installation (although
> I can't figure out how to access it) that may have been installed with VS
> Pro 2005.
>
> I don't want to screw up my development/training PC, so how do I get a
> version of SQL on my PC that I can distribute with my beginning apps?
>
Author
26 May 2006 4:11 PM
raibeart
Go to the MS site and download the latest version of SQL Server
Express.  It has the Management Studio that you need.
Author
29 May 2006 3:14 AM
ljh
I can use the Visual Studio tools to create and manage the db.  Just had a
little trouble because you have to specify SERVERNAME\SQLEXPRESS.....just
SERVERNAME won't get you anything with this version.

Thanks tho....

Show quoteHide quote
"raibeart" <raibe***@gmail.com> wrote in message
news:1148659863.019639.214110@38g2000cwa.googlegroups.com...
> Go to the MS site and download the latest version of SQL Server
> Express.  It has the Management Studio that you need.
>
Author
29 May 2006 3:15 AM
ljh
Besides....if I wanted to install SQL Express, it says I have to uninstall
Visual Studio first!

What kind of hokey crap is that?

Show quoteHide quote
"ljh" <S***@where.else> wrote in message
news:ICteg.64454$iB2.27217@bignews4.bellsouth.net...
>I can use the Visual Studio tools to create and manage the db.  Just had a
>little trouble because you have to specify SERVERNAME\SQLEXPRESS.....just
>SERVERNAME won't get you anything with this version.
>
> Thanks tho....
>
> "raibeart" <raibe***@gmail.com> wrote in message
> news:1148659863.019639.214110@38g2000cwa.googlegroups.com...
>> Go to the MS site and download the latest version of SQL Server
>> Express.  It has the Management Studio that you need.
>>
>
>