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

Content with tag history Rss

   Items 1 to 5 of 5   
 

Update Trigger to Store Only Updated Column and Former Value

History table needs individual rows for each column that has been updated, i.e., a column history.  Read more...
By Larry Schmidt 2012/12/17 | Source: SQLServerCentral.com | Category: trigger
Rating: |  Discuss |   Briefcase | 972 reads

Show Job Run Snapshot

Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.  Read more...
By Monte Kottman 2012/10/19 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 1,065 reads

Stairway to T-SQL Level 2: History of Structured Query Language (SQL)

Let’s step back in time and discuss the history of Structured Query Language, or what most SQL Server professionals just shorten to SQL. Fasten your seatbelts, crank up the time machine and travel back in time to follow the history of SQL and Microsoft SQL Server from its early years to where they are today.  Read more...
By Gregory Larsen 2011/10/21 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,435 reads

Job History with Timeline

Similar to many other Job History scripts, but unique in that it has a timeline.  Read more...
By webtekkie 2010/06/01 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 2,704 reads

Job History with Timeline

Similar to many other Job History scripts, but unique in that it has a timeline.  Read more...
By webtekkie 2010/06/01 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 2,704 reads
   Items 1 to 5 of 5   
 
Tags
dml (1)    
job (1)    
jobs (1)    
sql agent (1)    
stairway series (1)    
timeline (1)    
trigger (1)    
t-sql (1)    
update (1)