>(Reviving the topic from yesterday)
>How can I check a table if it has any deleted records?
If you have index on DELETED() (as many tables must have)
SET DELETED OFF
SELECT YourTable
SET ORDER TO TheOrderbyDeletedName
GO TOP
? DELETED()
Other way:
SET DELETED OFF
COUNT TO TestMe FOR DELETED()
? TestMe
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.