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: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,285 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: SQLServerCentral.com | Category: system tables
Rating: |  Discuss |   Briefcase | 13,855 reads

Find a Table's Metadata

Stored Procedure that returns table information  Read more...
By Crosbie Christopher 2008/10/23 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,323 reads
   Items 1 to 3 of 3   
 
Tags
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)