473,327 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Stupid Question of the day......

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?
May 26 '06 #1
4 1036
ljh
PLEASE IGNORE THE ABOVE POST.......NOT ENOUGH SLEEP AND I POSTED TO THE
WRONG GROUP.
"ljh" <So**@where.else> wrote in message
news:IA******************@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?

May 26 '06 #2
Go to the MS site and download the latest version of SQL Server
Express. It has the Management Studio that you need.

May 26 '06 #3
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....

"raibeart" <ra******@gmail.com> wrote in message
news:11**********************@38g2000cwa.googlegro ups.com...
Go to the MS site and download the latest version of SQL Server
Express. It has the Management Studio that you need.

May 29 '06 #4
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?

"ljh" <So**@where.else> wrote in message
news:IC*******************@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" <ra******@gmail.com> wrote in message
news:11**********************@38g2000cwa.googlegro ups.com...
Go to the MS site and download the latest version of SQL Server
Express. It has the Management Studio that you need.


May 29 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: sebb | last post by:
I'm kind of newbie to programming, but I thought of something and I want some opinions on that. It's about a new instruction block to do some cycles. I thought about that because it's not very...
119
by: rhat | last post by:
I heard that beta 2 now makes ASP.NET xhtml compliant. Can anyone shed some light on what this will change and it will break stuff as converting HTML to XHTML pages DO break things. see,...
2
by: Lampa Dario | last post by:
Hi, where is this stupid error in this program? When I execute it, i receive a segmentation fault error. #include <stdio.h> int main(int argc, char *argv, char *env) { int i=0; int l=0; int...
10
by: Fei Li | last post by:
Hi, If I'm not stupid for this, then the design of FolderBrowserDialog is very stupid. It only allow to strat browing from several predefined folder(Environment.SpecialFolder). What can I do if...
5
by: Guoqi Zheng | last post by:
I think I have this kind of problem very often, now it is really making me crazy. VS.NET always want to change my html code. Ok, that is fine as long as Vs.Net can ask my confirmaton first. For...
6
by: Adam Smith | last post by:
I have posted this and similar questions repeatedly and can't even raise a single response. I am being led to believe that this then 'Must be a stupid question' although people say that there is no...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.