Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag System Tables Rss

   Items 1 to 3 of 3   

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,305 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,966 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,351 reads
   Items 1 to 3 of 3   
administration (2)    
::fn_listextendedproperty (1)    
best practices (1)    
columns (1)    
dba (1)    
find foreign key using sql (1)    
nightly jobs (1)    
sql server agent (1)    
stored procedures (1)    
table field information (1)    
table metadata (1)    
t-sql (1)