hi
i have updated my database without using any where condition. from query ana;yzer .and it updated all my database .. how can i roll back...? plz help.....this is very important database.....
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20808680.html
How do you make query analyzer not chop off field. There seems to be a limitation on the number of characters that are printed on the grid that is returned by Query Analyzer for any given field...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21822811.html
I need some tips on how to use sqlserver query analyzer tool the best. I have to run a set of 16 script on a db and the way I usually do it is by opening the script file and then press the execute ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22618388.html
I am writing a program in VB.NET that will be set to run as a scheduled task to send out package tracking information at the end of the day.
I wrote a function to return the new tracking informa...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_22679951.htm...
I want to return all data from a text column that has over 30000 characters in Query Analyzer. I have tried
set textsize 64512
select MyText from MyTable
set textsize 4096 -- same as s...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20803234.html
Im getting increasingly annoyed by the small scope of the export features in Query Analyzer. Exporting it in CSV format means I lose all the column headings and copying the text out is pointless....
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20915109.html
I have a DTS and just run at Local packages in SQL server, but I don't know how can I run the DTS in Query Analyzer and how can I save the DTS in file format .dts???
Actually, I want to call ASP ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20987719.html
Is the Query Analyzer tool only available with Enterprise Manager? I'm wondering if there are other ways to obtain it (MSDE, VS.Net, etc.) Thanks!
http://www.experts-exchange.com/Databases/Q_21022308.html
Zones:
DatabasesDate Answered: 06/23/2004 Grade: A Views: 210
Hi,
I am trying to export query result from SQL query analyzer. In this query, I have a column called Company. Some of the company names are like "ABC, Inc.". When I export the result to a text ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21051194.html
I want to do a number of inserts in the query analyzer to 5 different tables.
I want them all to be part of the same transaction, and if any one of them goes wrong, I want to rollback everything.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21642048.html
