how to save query in Query Designer

Just learning SQL Server, using MS Step by Step book. I think I should be able to right click in query designer pane and save-as query. I see this option in context menu. When I try to save file, I don't get file dialog to specify file name. I also don't get error. Any ideas?

Thanks.Are you using Query Analyzer?|||Originally posted by blindman
Are you using Query Analyzer?

Sorry, I should have been more precise. Using SQL Server2000 (on Windows2000 Server) Enterprise Manager to create query in its Query Designer.

How to run a script file

Hello,

How would I go about populating a table using a script which I downloaded for the book I purchased for SQL/EXPRESS 2005. I believe this could only be down using

Microsoft SQL Server Management. Any help would be much appreciated.

Thanks

Karl

Try the link below and download the Express Advanced for the management studio and other features. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

|||

You can also use the sqlcmd command line tool. It will take a few minutes to figure out the syntax you need, but it's reasonably easy.

Don

sql