Skip to content
sqlkitty

sqlkitty

sql for everyone

Menu
  • Home
  • About
  • Auditing
  • Boulder SQL
  • Presenting/Talks
  • Publications
  • Volunteering
  • Contact

Month: April 2015

sql trace to filter on table

  • Posted onApril 20, 2015
  • sql server administration

You can’t set filter to trace specific table directly. What you can do is specify a filter for Text Data: File -> Properties -> Event Selection -> Column Filters -> TextData -> Like -> [Table Name]

Continue Reading

sql server – server side traces

  • Posted onApril 20, 2015
  • sql server administration

https://msdn.microsoft.com/en-us/library/cc293613.aspx start trace – stop trace, then script out file –> export –> script set InsertFileNameHere and run on server retrieve data from — SELECT * FROM fn_trace_gettable(‘c:inside_sql.trc’, 1) stop trace and don’t continue — EXEC sp_trace_setstatus 2, 2

Continue Reading

Error: Cannot use file for clustered server

  • Posted onApril 14, 2015
  • network administration

http://www.sysads.co.uk/2013/12/error-file-clustered-server/ Expand Services and applications, click on your clustered application (in my case is the default SQL Server (MSSQLSERVER)), right-click the SQL Server resource, and then click Properties Click the Insert button to add an additional row, then select the new shared disk that will…

Continue Reading

replace shared disk on failover cluster

  • Posted onApril 13, 2015
  • network administration

http://blogs.technet.com/b/askcore/archive/2011/08/26/replacing-a-shared-disk-on-a-2008-failover-cluster.aspx

Continue Reading

Subscribe to SQL Kitty

loader

Email Address*

Name

Recent posts

  • New Job -> Week 3 -> Creating Alerts
  • New Job -> Week 2 -> Creating a Checklist
  • New Job -> Week 1 -> What Tools Do You Need?
  • Creativity in Technology
  • Documentation vs Automation

Categories

  • Azure (2)
  • containerization (12)
  • dba (5)
  • editorial (1)
  • excel and others (3)
  • IT Certifications (1)
    • network+ (1)
  • linux (2)
  • network administration (15)
  • newjob (3)
  • other (3)
  • postgresql (5)
  • security (1)
  • SQL Server (11)
  • sql server administration (114)
    • jobs (2)
  • sql sever syntax (77)
  • web dev (6)
  • zen (1)

Archives

  • March 2023 (5)
  • January 2023 (1)
  • October 2022 (2)
  • April 2022 (1)
  • December 2021 (1)
  • May 2021 (1)
  • April 2021 (2)
  • February 2021 (7)
  • January 2021 (5)
  • December 2020 (2)
  • November 2020 (1)
  • January 2020 (2)
  • December 2019 (3)
  • August 2019 (2)
  • February 2019 (1)
  • June 2018 (1)
  • January 2018 (1)
  • September 2017 (1)
  • May 2016 (4)
  • January 2016 (2)
  • December 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (3)
  • May 2015 (9)
  • April 2015 (4)
  • November 2014 (7)
  • October 2014 (19)
  • September 2014 (3)
  • July 2014 (2)
  • July 2013 (1)
  • December 2012 (1)
  • October 2012 (1)
  • December 2011 (6)
  • October 2011 (6)
  • September 2011 (5)
  • July 2011 (1)
  • June 2011 (1)
  • May 2011 (2)
  • April 2011 (1)
  • February 2011 (15)
  • January 2011 (19)
  • December 2010 (14)
  • November 2010 (16)
  • October 2010 (3)

RSS SQL Kitty RSS

  • New Job -> Week 3 -> Creating Alerts
  • New Job -> Week 2 -> Creating a Checklist
  • New Job -> Week 1 -> What Tools Do You Need?
  • Creativity in Technology
  • Documentation vs Automation
© Copyright 2023 – sqlkitty
Chip Life Theme by TutorialChip ⋅ Powered by WordPress