SQLServerCentral.com / Discuss Content Posted by Brian Kelley / Article Discussions / Article Discussions by Author / Getting the Most out of SQL Server 2000's Query Analyzer, Part I / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 13:25:45 GMT20RE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxThe information is found in Books Online, which is Microsoft SQL Server's documentation. It usually installs with the client tools and/or a server install. You said SQL Server 2003. If you mean SQL Server 2005 (it went from 2000 to 2005), you can find it here:[url=http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx]SQL Server 2005 Books Online[/url]from that link you can find Books Online on MSDN or download a version to install on your computer.If you mean SQL Server 2000, a downloadable version is here:[url=http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en]SQL Server 2000 Books Online Download[/url]It is also available on-line on MSDN.Thu, 25 Oct 2007 06:35:49 GMTK. Brian KelleyRE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxCan u telll in more descriptive way dont give me a sort of link and i am talking about sql server 2003Wed, 24 Oct 2007 21:59:10 GMTfastvarunRE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxYes, if a linked server has been set up. Also, OPENROWSET() provides this functionality.Wed, 24 Oct 2007 17:06:44 GMTK. Brian KelleyRE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxcan we connect through query with one server to another "sql server 2000 query to connect another server" Please mail me at fastvarun@gmail.comWed, 24 Oct 2007 04:57:09 GMTfastvarunRE: Getting the Most out of SQL Server 2000''s Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxI didn't think to include that when writing the article. I'm not sure why. If you hold down the shift key while right-clicking, that does bring up the option to Run As another account. I use it all the time administering Active Directory. <img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>Fri, 31 Dec 2004 07:18:00 GMTK. Brian KelleyRE: Getting the Most out of SQL Server 2000''s Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspx<P>The discussion about security actually brings up another great use for Query Analyzer that wasn't specifically mentioned in the article but was certainly demonstrated. QA is very helpful when trying to diagnose connection and security issues. It is a pretty lightweight client so it loads quickly and the login options allow the user to log in under a sql account that an application might be using in order to test the queries under the same credentials without a lot of application overhead.</P><P>In relation to the RunAs command, you can also access this Windows 2000/XP feature by right-clicking on an icon in the Start Menu, on the desktop, or in a toolbar on the task bar and selecting the "Run as..." option from the context menu. When you do it this way, you get a login dialog like the one shown below.</P><P><IMG alt="RunAs Dialog Box" hspace=0 src="X:\My Documents\My Pictures\RunAs.GIF" align=baseline border=0></P>Wed, 29 Dec 2004 10:44:00 GMTTatsuRE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxThanks for the kind words! BTW, the latest issue of SQL Server Magazine has an article about using account delegation in Windows 2000 Active Directory to get around this problem.K. Brian Kelleybkelley@sqlservercentral.comhttp://www.sqlservercentral.com/columnists/bkelley/Mon, 04 Mar 2002 07:38:00 GMTK. Brian KelleyRE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxGreat article. I've been struggling with exactly the issues with linked servers that you describe, and your article is the clearest explanation of the problem I have come across. Looking forward to the rest of the series....Andy Mon, 04 Mar 2002 07:36:00 GMTacotgreaveRE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxHey Steve,Thanks for the feedback, though it wouldn't hur to give Brian the benefit of the doubt! I agree with your comment that the lead for the article didn't really do a good job setting expectations. This is something we do (meaning the owners) and we didn't do a very good job of it this time. We'll try to do better! I hope you'll continue to visit and contribute.AndyThu, 21 Feb 2002 17:17:00 GMTAndy WarrenRE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxThe series will cover the new features. However, as we discuss each part, I'll be mentioning common problems and issues that I've seen. The two issues mentioned in Part I are from real life conversations with developers who were stuck.K. Brian Kelleybkelley@sqlservercentral.comhttp://www.sqlservercentral.com/columnists/bkelley/Thu, 21 Feb 2002 11:31:00 GMTK. Brian KelleyRE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxBasic and simple, waiting for a bit more meat. Ready for pt2. Thu, 21 Feb 2002 10:31:00 GMTAntares686RE: Getting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxThe preamble intrigued me because it mentioned new Query Analyzer features would be covered. Instead, we are covering SQL security modes (regardless of Query Analyzer) and how to resolve linked server issues using Active directory (regardless of Query Analyzer). Not to worry, we'll be covering "new Query Analyzer features" next time. Thu, 21 Feb 2002 10:06:00 GMTshendricksGetting the Most out of SQL Server 2000's Query Analyzer, Part Ihttp://www.sqlservercentral.com/Forums/Topic2637-59-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/bkelley/qa2k_1.asp>http://www.sqlservercentral.com/columnists/bkelley/qa2k_1.asp</A>Fri, 15 Feb 2002 00:00:00 GMTK. Brian Kelley