1)

SELECT TOP 1 WITH TIES DrinkID FROM PubDrink GROUP BY DrinkID ORDER BY COUNT(*) DESC

2)

SELECT DrinkName FROM Drinks WHERE NOT EXISTS (SELECT * FROM PubDrink WHERE Drinks.DrinkID = PubDrink.DrinkID)

3)...

Won't this cause a recurring action on the trigger??

System procedure in the master database.  It looks through all tables in the current database and executes the statement passed in paramter.  The question mark is used as a placeholder...

Have you searched the articles sections on this site.  I'm sure you'll find something on this subject!

I'm assuming that there is at least 1 foreign key in the whole DB.  So truncate was out of the question .

RUN only in developpmenet area :

EXEC sp_MSForEachTable 'DELETE FROM ?'

Can't wait to be able to do this here .

SELECT   *

FROM   ::fn_listextendedproperty(NULL, NULL, NULL, NULL, NULL, NULL, NULL)

Thanx for letting me know.  Do you know any other alternative than my trace idea?

Or if you have audit on the tables and those audit tables are never deleted... but you see another gotcha situation where you may run with invalid data for a...

well you can ask all those missing payments to be remade... but it might not be a good thing on the long run for the company

Check out sp_addextendedproperty in books online.

How about this one... the dude makes a mistake in a delete statement and deletes 1000 rows when he meant to delete 500 on a 1M rows table.  He doesn't...

Exactly the point of a NULL.  We don't know the information.

Now we could get started on the fact that we could know that this information does not exists but that's...

1975 now ?

Good week-end guys.