A problem occurred attempting to delete row sql
Posted on 2014-04-07
I have this error when we tried to attempt to delete rows from a SQL databse table. The problem is bad people entered to register and that rows are messages the problem is there are around 200,000 trash messages we need to delete but we can´t with SQL Management Studio GUI. HEre is the map of the SQL database:
Man database called: "foro" a table called "dbo.messages". The problem is we have mixed the trash rows with good rows and we only know the GUI of SQL to select the rows to delete and that´s all but the error message appear. Now like you see in 200,000 trash rows each one by one is a nightmare.
Anyone know how from the GUI selecting the rows to delete use that information maybe to delete in other way maybe in command of SQL? And what would be exact the command to delete that rows?
We have Windows 2008, SQL Server 2008.