The only way I know of is utilizing 3rd party tools and a LOT of coding. Install Lumigent's Entegra and set it up to send notifications to a specified mailbox when tables are created. Now create a service that will run to pull any new message arriving in that inbox, scan the content of the message that Entegra sends back for a table being created matching your string, and when found, initiate a connection to your database server and execute a script that you have coded into the service.
What you are asking for, while possible, really worries me. It tells me you have an environment where there is aboslutely no control on the creation and destruction (if you have the authority to create, you have the authority to drop) of database objects since they can apparently be done at a whim. This is a formula for some extremely serious issues eventually as you have a completely unmanageable environment where a DBA has no ability to understand what is and isn't in a database from one minute to the next.
For More Information
- Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Microsoft SQL Server Installation
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.