I have a need to refresh a sql server database table and prior need to delete all rows. I have tried several versions of this and for whatever reason no rows are being deleted but I am getting no errors. I do not see anything in the logs that gives me a clue either. I have tried:
DELETE * FROM admits
DELETE * FROM dbo.admits
DELETE FROM admits
DELETE FROM dbo.admits
Thoughts as to what I'm doing wrong here?