SQL Server Trace (aka SQL Profiler) Priveliges without giving sysadmin

Posted by Chris Straw on April 7, 2012 in SQL Server |

Tweet I’m a big proponet of using SQL Server Profiler for monitoring DB activity from applications. When a client has a SQL Server DBA on staff, they continuously tell me they can’t grant me Trace privileges without giving me sysadmin privileges. Oh yes they can! Below is the simple script to grant a particular user […]



How to Clear or Purge the Biztalk Tracking Database

Posted by Chris Straw on April 7, 2012 in BizTalk, SQL Server |

Tweet Stop all running Biztalk services, load up SQL Management Studio, on the BiztalkDTADb database run the following script. Note that this script does not archive data. The last part shrinks the database and log files.

Tags: ,

Copyright © 2011-2020 Chris Straw All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.5, from BuyNowShop.com.