Deleting records from SQL 2005 database

Discussion in 'Databases' started by tsherv, Jul 29, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. We have a simple web application that saves data to a SQL 2005 database (hosted on discountasp.net). We hired a developer to design the site. In our business we run SQL 2000 (not 2005). I'm getting to the point where I want to delete some records (probably a couple thousand). I'm wondering what my options are for deleting records? I've used the discountasp.net administration tools. When I view the table, it looks like it will only allow me to delete 1 record at a time. I know I have the option to write a query and run it using the online admin tool, but I'm a little nervous about that.

    I'm wondering if there is a tool out there that I can use to hilight a range of records (sorted by date) and delete them? I'm assuming I can't use SQL Server 2000 Enterprise Manager on a SQL 2005 DB?

    Any advice would be appreciated!

    Thanks.
     
  2. mjp

    mjp

    Don't be. That's the most efficient way to delete the records. Just be sure to back up your database before you do anything potentially destructive.

    If you're nervous about a delete query, do a SELECT first. That way you see the records that your query is affecting. If those results look right you can safely do the DELETE with the same query.

    Even if everything does blow up in your face, you have that backup, right? ;) Always have that backup.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page