Deploy a DDL trigger to prevent dropping tables for mulitpledatab
in [Server Configuration]
|
Prev: SQL server 2005 multicore problem with 'where column like' sqlcommand
Next: Performance Benchmark for SQL 2000 & 2005
From: Simon H on 5 May 2010 15:32 I never really use triggers but I'm almost certain your trigger will need to be added to each database individually. Alternatively - find the blighter who's deleting your $hit - and give them a whooping. Problem solved. :-) |