Tag: T-SQL
-
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…
-
Quickly See a Table’s Columns in SSMS
When looking at long queries you’ll typically need to remember what data is in one of the tables. SSMS allows the creation of shortcut keys that can be used to quickly look at the first row in a table. You’ll then be able to see the column names and some example data. In SQL Server…