I'm pretty much a newbie with SQL. I have a database that is growing out of control and I'm unable to delete any records (data) from it. I've tried numerous open source applications but nothing has worked. The database is with a hosting and they provide ASP.NET Enterprise Manager. I also have Table Editor 0.81 Beta loaded on the host. I can get any program/app to connect to the database, and I can see all the tables and data, but I'm unable to delete old records. There are 2 years of old data that I need to delete. And my hosting company is screaming at me to make the database smaller. It is currently around 650MB.
Can anyone PLEASE offer some assistance to a SQL newbie, pretty please??