Purging SQL Server 2005 Users table

My SQL 2005 Users table has filled up with anonymous users to the point where my space allocation is full. Is there a tool that I can use to purge unregistered anonymous users?

A side note: I have 53,000 unregistered users which does not in any way correlate to normal traffic. Does anyone know of a malicious program that fills up the User files like this?

Thanks,

Steve

 

You can run a SQL script directly on your users table if you know which users you need to delete e.g. DELETE FROM table_name WHERE some_column=some_value

It's impossible to know what's causing this from an outside perspective (from here) without detailed knowledge of your application. It could be that the application allows anonymous sign up without attempting to verify the account is being created by a human.