• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

SQL 2000 query analyzer

I am trying to delete all rows in all table's in one data base that have a certain value say (MX)$ how can I do this using SQL query analyzer 2000
0
Jeff1976
Asked:
Jeff1976
  • 3
  • 2
3 Solutions
 
arnoldCommented:
You have to use sql query browser not analyzer.
You have to make sure that you are deleting from tables in the correct order dealing with constraints if any.
0
 
Jeff1976Author Commented:
Ok I can not find SQL query browser for SQL 2000 installed is it a seperate install or download and how do I figure out what order to use or the constraints. I am really new to this.
0
 
arnoldCommented:
Constraints are part of the database setup that deal with preventing deletion of records that other tables rely on.
Do you have enterprise manager installed?
Is this Sql 2000 or MSDE?

The enterprise manager and the sql browser have to be installed using the CD.

Have not used it in a while, http://toadforsqlserver.com/index.jspa
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeff1976Author Commented:
this is SQL 2000 standard
0
 
arnoldCommented:
If you have the disk rerun the install and make sure to install the enterprise manager tools.
0
 
Anthony PerkinsCommented:
You should be able to do that with SQL Query Analyzer.  

Is this what you mean:
DELETE YourTableName WHERE YourColumnName = '(MX)$'
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now