April, 2014

  • ggaurav

    Explicit DBO permissions on TempDB for a domain group

    • 0 Comments
    To do this we created a stored procedure and added it as a startup procedure so that whenever the SQL server service is restarted then the stored procedure will automatically grant the access to the group on the tempdb. Add the domain group to the SQL...
  • ggaurav

    Server Manager consuming memory

    • 0 Comments
    You may have seen issues on Windows 2012 server, where even after the users have disconnected from the server, their session is still consuming the memory. When you open task manager, you would see the session manager of the disconnected session taking...
  • ggaurav

    Adding a Remote Distributor for a Transactional Replication

    • 0 Comments
    You may encounter the following messages when creating a remote Distributor : TITLE: Configure Distribution Wizard ------------------------------ SQL Server could not connect to the Distributor using the specified password. For help, click...
  • ggaurav

    Master DB restore & Service Master key

    • 0 Comments
    If we don’t have a recent master backup and have to make use of the files from the DR server, then as long as our target instance matches the path and build requirements we can restore master and bring it up. If the build is different , we will...
Page 1 of 1 (4 items)