skip to main | skip to sidebar

The Baking DBA - select * from flour

Put butter in your mixer, add sugar, set on low. Write a stored procedure to keep track of jobs that won't run. Add flour. Use a DMV to find unused indexes. Add eggs. Bake in an MDF with 20% free space.

Monday, April 30, 2012

[traces] Killing orphaned trace

Swore I had this already.



SELECT * FROM sys.traces

sp_trace_setstatus 2, 0 --stop trace
sp_trace_setstatus 2, 2 --close/remove trace
at 3:38 PM 0 comments
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2013 (18)
    • ►  May (4)
    • ►  April (6)
    • ►  March (6)
    • ►  February (2)
  • ▼  2012 (32)
    • ►  December (3)
    • ►  November (2)
    • ►  October (2)
    • ►  September (7)
    • ►  August (2)
    • ►  July (2)
    • ►  June (3)
    • ►  May (1)
    • ▼  April (1)
      • [traces] Killing orphaned trace
    • ►  March (1)
    • ►  February (3)
    • ►  January (5)
  • ►  2011 (32)
    • ►  November (1)
    • ►  September (3)
    • ►  August (3)
    • ►  July (3)
    • ►  June (1)
    • ►  May (2)
    • ►  April (5)
    • ►  March (3)
    • ►  February (4)
    • ►  January (7)
  • ►  2010 (31)
    • ►  December (1)
    • ►  November (2)
    • ►  October (3)
    • ►  August (2)
    • ►  June (2)
    • ►  May (5)
    • ►  April (8)
    • ►  March (4)
    • ►  February (1)
    • ►  January (3)
  • ►  2009 (30)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  August (1)
    • ►  July (2)
    • ►  June (3)
    • ►  April (6)
    • ►  March (3)
    • ►  February (5)
    • ►  January (6)
  • ►  2008 (47)
    • ►  December (3)
    • ►  November (1)
    • ►  October (5)
    • ►  September (4)
    • ►  August (3)
    • ►  July (2)
    • ►  June (5)
    • ►  May (2)
    • ►  April (4)
    • ►  March (4)
    • ►  February (4)
    • ►  January (10)