Tag: SQL Server
-
Check for Objects in SQL Server
Examples of how to check your SQL Server database for existing tables, stored procedures, indexes, etc. Use them before you drop/create/modify to avoid errors.
-
Notifying DBAs of New SharePoint Databases
In our production environment, the Database Administrators like to know when a new database is created or dropped. As well they should. They normally use a DDL trigger to send out an email when one of these events occurs. The problem we ran into was that in Windows SharePoint Services 3 (WSS3/SharePoint 2007), the trigger…