|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2005 / Query AnalyzerDev Ed on my PC. I used query analyzer exclusively in 2000 so I am sorry if these are stupid questions. 1. If I am writing a general query in the new query window (Data | New Query) I dont get any syntax highlighting. How can I change this? 2. In query analyzer I can just select a few lines of a query and execute them, this way I can have many querys in a window and play around with them all. 3. In Enterprise Manager there are lots of additional options for Backup/DTS/Replication etc. These aren't visible now in the new IDE. Where are they now? Sorry for these basic questions, but after years of doing everything in Query Analyzer, I dont think i can live without it! Craig. Built-in tutorial on SQL Server Management Studio.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/31f9e6dc-e946-4576-80bb-729f2bee7478.htm -- Show quoteGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Craig van Nieuwkerk" <crai***@gmail.com> wrote in message news:1138694672.494932.156520@f14g2000cwb.googlegroups.com... > Hi All. I have just updated the SQL 2000 Developer Edition to SQL 2005 > Dev Ed on my PC. I used query analyzer exclusively in 2000 so I am > sorry if these are stupid questions. > > 1. If I am writing a general query in the new query window (Data | New > Query) I dont get any syntax highlighting. How can I change this? > > 2. In query analyzer I can just select a few lines of a query and > execute them, this way I can have many querys in a window and play > around with them all. > > 3. In Enterprise Manager there are lots of additional options for > Backup/DTS/Replication etc. These aren't visible now in the new IDE. > Where are they now? > > Sorry for these basic questions, but after years of doing everything in > Query Analyzer, I dont think i can live without it! > > Craig. > 1. I don't know what you mean by syntax highlghting. If you mean color
coding, it's there. Just like in QA, you can change the color schemes if you want. 2. It works exactly the same way. 3. Those options are all there. DTS has been replaced by Integration Services and is worked with inside of the BI Studio tool. 4. You can use Query Analyzer against SQL Server 2005 and it's something that I definitely recommend for DBAs. You don't get things like XML showplans and other stuff, but with QA, you can launch it, write your query, execute it, view the results, and make whatever decision you want, generally in less time than it even takes Management Studio to finish opening. I still use it about 80% of the time over Management Studio, because it allows me to get much more done in a shorter amount of time than I can with SSMS due to its massive overhead. -- Show quoteMike http://www.solidqualitylearning.com Disclaimer: This communication is an original work and represents my sole views on the subject. It does not represent the views of any other person or entity either by inference or direct reference. "Craig van Nieuwkerk" <crai***@gmail.com> wrote in message news:1138694672.494932.156520@f14g2000cwb.googlegroups.com... > Hi All. I have just updated the SQL 2000 Developer Edition to SQL 2005 > Dev Ed on my PC. I used query analyzer exclusively in 2000 so I am > sorry if these are stupid questions. > > 1. If I am writing a general query in the new query window (Data | New > Query) I dont get any syntax highlighting. How can I change this? > > 2. In query analyzer I can just select a few lines of a query and > execute them, this way I can have many querys in a window and play > around with them all. > > 3. In Enterprise Manager there are lots of additional options for > Backup/DTS/Replication etc. These aren't visible now in the new IDE. > Where are they now? > > Sorry for these basic questions, but after years of doing everything in > Query Analyzer, I dont think i can live without it! > > Craig. > Craig van Nieuwkerk (crai***@gmail.com) writes:
> Hi All. I have just updated the SQL 2000 Developer Edition to SQL 2005 Data | Bew Query? Sounds as if you have gotten hold of Visual Studio.> Dev Ed on my PC. I used query analyzer exclusively in 2000 so I am > sorry if these are stupid questions. > > 1. If I am writing a general query in the new query window (Data | New > Query) I dont get any syntax highlighting. How can I change this? Or at least Business Intelligent Development Studio. (Which is in fact packed in Visual Studio.) The tool for running engine queries is SQL Server Management Studio. (Which is built on the code case from Visual Studio.) > Sorry for these basic questions, but after years of doing everything in As Mike said, don't be ashamed for using QA with SQL 2005. It's certainly> Query Analyzer, I dont think i can live without it! more effective in many senses. I usually use Mgmt Studio with SQL 2005, but that is because I have not really come out of the beta-testing stage yet. :-) However, Enterprise Manager does not work with SQL 2005. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics