SQL Query Analyzer Questions and Answers

Recent IT Questions

1 - 8 of 8
<<PREVIOUS 1 NEXT>>

Looking for a query tool for SQL Server 2000 and SQL Server 2005

Many of our developers would like to have a client utility like Query Browser or Query Analyzer installed on their machine, so that they can personally query our SQL Server 2000 and 2005 servers and view the results from their workstations. I am unable to find the appropriate way to install...

View Answer   |  Apr 14 2009  7:46 PM GMT
SQL Server 2000, SQL Server 2005, SQL Query Analyzer
asked by SQL Server Ask the Experts

  2445 pts.

Install sql server client tools

Client utilities like query browser, or query analyzer, how do I install on client workstations? I am not interested in installing a SQL server. I should just be able to query a SQL server and display some results from my laptop. Can anybody guide me? well, if we have to buy any licenses we will,...

asked by Krblr2007

  20 pts.

SQL Server 2005 Select Multiple views or Tables

in SQL 2000 it was easy to cntl-right-click and select multiple views, stored procedures or tables and generate one script which could be changed (using SQL Analyzer) to create new objects (search and replace text) with different names. This was a big time saver but I don't know how to do that in...

View Answer   |  Mar 18 2009  0:07 AM GMT
SQL 2005, SQL Query Analyzer, SQL Server 2005
asked by SapwizSAP

  5 pts.

Create Stored Procedure based upon existing Stored Procedure

How do I create a Stored Procedure based upon an existing stored Procedure in SQL Query Analyzer V 8.00.760

asked by Trainingit

  20 pts.

Error message in Query Analyzer on SQL Server 2005

I am trying to run the following command in Query Analyzer on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Why might...

View Answer   |  Aug 19 2008  8:08 PM GMT
SQL Server 2005, SQL Server errors, SQL Query Analyzer
asked by SQL Server Ask the Experts

  2445 pts.

Running a stored procedure in SQL Query Analyzer or as part of a SQL job

I have been trying to run a stored procedure in SQL Query Analyzer and as a step in a SQL job. If I run it in Query Analyzer, it takes less than a minute, but it takes considerably longer if it is run as a step. I use SQL Server 2000. Why would there be so big a difference?

View Answer   |  Jul 11 2008  2:52 PM GMT
SQL Server 2000, Stored Procedures, SQL Query Analyzer
asked by SQL Server Ask the Experts

  2445 pts.

Execution time is varying with query analyzer and visual studio 2005

when a stored procedure is executed in query analyzer its working fine and getting the result quickly.but when same procedure is executed through visual studio timeout expired error is generated.can any one olve this issue

View Answer   |  May 21 2008  6:24 AM GMT
SQL, Visual Studio, Stored Procedures
asked by Abcp

  5 pts.

datetime conversion

SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem? convert(varchar(10),ft.postdate,101) 'PostDate',

View Answer   |  May 5 2008  3:31 PM GMT
DateTime, SQL Query Analyzer
asked by Mictip

  5 pts.

1 - 8 of 8
<<PREVIOUS 1 NEXT>>