Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag System Tables Rss

   Items 1 to 4 of 4   

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.  Read more...
By David Poole 2016/01/26 | Source: | Category: foreign key
Rating: |  Discuss |   Briefcase | 2,728 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,311 reads

What is sysprocesses and what can it do for you?

This article presents a description of sysprocesses aimed at the newer DBAs. From new author Edward Elliot, he dives into what you can learn from this system view.  Read more...
By Edward Elliott 2009/05/01 | Source: | Category: system tables
Rating: |  Discuss |   Briefcase | 13,998 reads

Find a Table's Metadata

Stored Procedure that returns table information 
By Crosbie Christopher 2008/10/23 | Source: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,359 reads
   Items 1 to 4 of 4   
administration (2)    
::fn_listextendedproperty (1)    
best practices (1)    
columns (1)    
dba (1)    
find foreign key using sql (1)    
foreign key (1)    
nightly jobs (1)    
primary key (1)    
sql server agent (1)    
stored procedures (1)    
table field information (1)    
table metadata (1)    
t-sql (1)