November, 2013

  • ggaurav

    FlushCache : New in SQL Server 2012

    • 0 Comments
    Starting SQL 2012 we have got something new added to the SQL error logs which was logged earlier when a TF was enabled. Below is the message which is new in the SQL error logs : 2013-09-20 03:01:48.10 spid14s FlushCache: cleaned up 12773 bufs with...
  • ggaurav

    Audit : How to track logins getting dropped in SQL Server?

    • 0 Comments
    Tricky!! This is what I can say when I started troubleshooting the issue when suddenly the logins were getting dropped and no one had a clue what's going on since no one from the DBA team would go ahead and drop the logins. However, SQL 2008 and above...
  • ggaurav

    The subscription(s) have been marked as inactive

    • 0 Comments
    While you are troubleshooting the following error : "The subscription(s) have ben marked as inactive" Please make sure you have checked the following : 1. MSSubscriptions table and the value is showing as zero for the status column http:/...
Page 1 of 1 (3 items)