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
Jeff1976Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.