|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
 Posted - 04 April 2005 : 18:12:19
|
SQL Server Enterprise Manager can return all rows of a table and you can delete them that way, but would it not be just as easy to just run a script that you could run against the DB to delete certian types of e-mails or e-mail addresses?
To bring up the rows in the DB via SQL Server Enterprise Manager, simply:
1. Open SQL Server Enterprise Manager
2. Open your server
3. Go to the Databases
4. Select your database that has the data to remove
5. Go to tables that store the data to remove
6. Then find the field that contians the information you want to delete
7. Right click on the table
8. Select "OPen Tables"
9. Then select "Return all rows"
10. When finished, close SQL Server Enterprise Manager and you are done
Sorry if I put it in real simple forum, but if there are others who need to know as well, then might as well make it as easy as possible.
Side note is that I will not be responsible for the loss of data thet you want to keep as you need to be fully careful when deleting data, that it is the data that you want to delete.
I hope this helps.
All the rows will show up and then you can delete each row on their own, or you could select a group of rows and simply press your delete key. You need to be careful not to delete stuff you want to keep as it will not come back. |
Cheers,
David Greening |
 |
|
Topic Locked
