SQL Query Analyzer (2005?) 1

[beanNut]

Hi, I'm working at a site that has SQL 2005 Express and VS 2005. I am experienced using SQL Query Analyzer and in the Oracle world using TOAD. My question is this. I can't find how to save my SQL scripts to my hard drive or load them from my SQL library and run them. I've tried to issue more than one command in SQL EXPRESS and used GO in between. Nothing seems to work. EXPRESS seems very restrictive in this mode. Also, I can't find the tool that is similiar to Enterprise manager window. What's wrong? Do I have the wrong EDITION?? My work environment seems very restrictive. Should I be expecting a different environment installed if I'm going to do database application development??

If you have any documentation and written resources concerning this I can use it to support my request to upgrade my work environment?? Thanks

 

[bboffin]

If you have a copy of VS 2005 Professional or higher it includes a copy of SQL Server 2005 Developers Edition. This has a tool called SQL Server Management Studio which is a replacement for SQL Server Enterprise Manager and SQL Query Analyser.

Otherwise you can download a copy of the equivalent tool for SQL Server Express called 'SQL Server Express Management Studio' from Microsoft at

http://www.microsoft.com/sql/editions/express/default.mspx

which should do all you want.

Also don't forget that you can write and execute (and even debug) SQL scripts from within VS 2005 via the Server Explorer window.


Bob Boffin

 

[beanNut]

bbofin, Thanks
Your last comment concerning the use of SQL Scripts from VS2005 Server Express Explorer Window.

I cannot enter more than 1 command line in the SQL Query Window. Can you tell me how to enter a group of commands to run sequentially?

I've tried putiting GO in between and that doesn't seem to work.

I'm beginning to think that it isn't possible.

 

[chiph]

Did you try a semicolon as a separator?

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[bboffin]

I usually prepare my SQL scripts as SPs and then you can have as many commands as you like. But of course I also use the Management tool!





Bob Boffin