Help!

Using Visual Basic Express Edition and SQL Server 2005 Express Edition.
Windows XP Home Edition SP2

I'm really sorry, this is probably the most idiotic post that you will ever read on these forums - but they're real problems.
There have been two things that I have been completely unable to figure out about SQL Server Express Edition 2005:

-When I am creating a new SQL database, or connecting to a SQL database from Visual Basic Express Edition I end up with two sqlservr.exe processes - one of these processes is activated when the computer powers up and the other is activated when I try creating or connecting to a SQL database. Having two of this process running simultaneously is really slowing down my programming! Can anyone help me stop this?

- And now for the really embarassing question : How do I save a query? I've followed the MSDN guide but I just cannot save any querys I create. I'm using VBE and SQLE (mentioned above) and when I have designed my query I just cannot find a button anywhere to save it! I've looked everywhere, the normal save button is greyed out and no shortcuts work - is this because I'm running express edition and you're not allowed to save querys?

Any help you can give me would be greatly appreciated!

hi,

KitFox wrote:

Using Visual Basic Express Edition and SQL Server 2005 Express Edition.
Windows XP Home Edition SP2

I'm really sorry, this is probably the most idiotic post that you will ever read on these forums - but they're real problems.
There have been two things that I have been completely unable to figure out about SQL Server Express Edition 2005:

-When I am creating a new SQL database, or connecting to a SQL database from Visual Basic Express Edition I end up with two sqlservr.exe processes - one of these processes is activated when the computer powers up and the other is activated when I try creating or connecting to a SQL database. Having two of this process running simultaneously is really slowing down my programming! Can anyone help me stop this?

this is because a User Instance is started when connecting to a database.. VBExpress designers can only connect to this "SQL" features and not to "traditional" SQL Server instances... but in your code you can change that behaviour..

- And now for the really embarassing question : How do I save a query? I've followed the MSDN guide but I just cannot save any querys I create. I'm using VBE and SQLE (mentioned above) and when I have designed my query I just cannot find a button anywhere to save it! I've looked everywhere, the normal save button is greyed out and no shortcuts work - is this because I'm running express edition and you're not allowed to save querys?

the VS ide can be overhelming for that task.. you can perhaps have a look at the "traditional" editor and management GUI used for SQL Server (the Express edition as well), SQL Server Management Studio Express..

regards