SQL Query Analyzer Questions

1

How to write text into word doc using SQL 2000 query analyzer
how to write text into word doc using sql 2000 query analyzer. Thanks in advance.

Answer Question   |  November 19, 2010  7:02 AM
SQL 2000, SQL Query, SQL Query Analyzer, SQL Server 2000, SQL Server 2000 queries
asked by:
65 pts.

SQL Server 2008 SSIS Update Command Performance Issue
Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB [...]

Answer Question   |  August 13, 2010  9:37 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS
asked by:
60 pts.

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 something like this. Can [...]

Answer Question   |  April 14, 2009  7:46 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server 2000, SQL Server 2005
2,585 pts.

Install SQL server client tools
With 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. [...]

Answer Question   |  April 19, 2013  9:29 PM
MySQL Query Browser, SQL Query Analyzer, SQL Server Agent
asked by:
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 SQL 2005. [...]

Answer Question   |  March 18, 2009  12:07 AM
SQL 2005, SQL Multiple Views, SQL Query Analyzer, SQL Server 2005, SQL tables
asked by:
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

Answer Question   |  September 8, 2008  6:31 PM
SQL Query Analyzer, SQL Query Analyzer 8.x, Stored Procedures
asked by:
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 this be?

Answer Question   |  August 20, 2008  8:08 PM
SQL Query Analyzer, SQL Server 2005, SQL Server errors
2,585 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 [...]

Answer Question   |  September 9, 2008  2:52 PM
SQL Query Analyzer, SQL Server 2000, Stored Procedures
2,585 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

Answer Question   |  May 21, 2008  6:24 AM
SQL, SQL Query Analyzer, SQL Server stored procedures, Stored Procedures, Visual Studio
asked by:
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’,

Answer Question   |  May 6, 2008  3:31 PM
DateTime, SQL Query Analyzer
asked by:
5 pts.

1