O sure it does, its located under File --> New --> Project --> Visual C# --> Database --> SQL Server Project.
If its not located in there you have to reinstall the Visual Studio template from the setup file.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
I'm new to databases with C#
There are lots of good examples that use an already existing SQLev db and vs2005, but I'm trying to use VS2005 standard to create the SQLev DB (table, etc), when I try to add a new item, is see only the .mdf selection. (I don't have Full SQL Server or SQL Express on my machine, if that means anything)
Can you please tell me how or point me to an tutorial
Thanks
Mike Greenway
I overlooked it!
I didn't see the Books Online Download with most of the answers.
Sorry for wasting your time.
For others like me
Microsoft Download Center.
|||one catch
To make a new ssev db in vs2005 you need to use the "mobile 2003 or ce5.0" project type
else when you use "add new item" the ssev DB type will not be available
so, I have to make the DB in on project and then use it in my windows or winfx project, right?
I'm new to databases with C#
There are lots of good examples that use an already existing SQLev db and vs2005, but I'm trying to use VS2005 standard to create the SQLev DB (table, etc), when I try to add a new item, is see only the .mdf selection. (I don't have Full SQL Server or SQL Express on my machine, if that means anything)
Can you please tell me how or point me to an tutorial
Thanks
Mike Greenway
I overlooked it!
I didn't see the Books Online Download with most of the answers.
Sorry for wasting your time.
For others like me
Microsoft Download Center.
|||one catch
To make a new ssev db in vs2005 you need to use the "mobile 2003 or ce5.0" project type
else when you use "add new item" the ssev DB type will not be available
so, I have to make the DB in on project and then use it in my windows or winfx project, right?
Hello all,
I've Installed VS2005 and MSSQL express with it. I used to work with mssql 2003 enterprise edition where it had "Enterprise Manager" from which I could create and modify my Databases.
How do I creat a new database with MSSQL express?
I've tried to do this via visual studio 2005 "server explorer". I"m entering the "Create new SQL Server Database" dialog, I select my server's name and my new database name and I recive an error message which says "An error has occurred while estabilishing a connection to the server" and it also says that
"When connecting to SQL server 2005, this failure may be caused by the fact that under the defult settings SQL sever does not allow remote connections".
How do configure my MSSQL express to allow the remote connection?
Thanks in advance!
With the new SQL 2005 systems you need to use the new Management Studio to perform the same tasks as the Older Enterprise Manager and Query tools. With the full versions this is included, for the basic express product you can get a smaller version from the Microsoft Downloads site, Called SQL Management Studio Express.
In the case of remote connections have a look at this support article... http://support.microsoft.com/default.aspx/kb/914277
|||How to configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
|||Thanks a lot guys :)|||
Hi,
also have a look at the screencast section on my site, which will show you a walkthrough for your problem.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
