Tweet The original post is here: Find missing indexes using SQL Servers index related DMVs
Tweet I was trying to find what messages were being orphaned, so I started doing a little digging to figure out how I could get more detail. With that being said, I still use the Terminator to fix the issue. I do NOT recommend updating or changing any messages in the messagebox without consent from […]
Tweet This query will give you a list of the BizTalk Hosts:
Tweet This is a little tricky in the syntax. If you have a SQL User without Login that is showing disabled, you have to grant it connect access, since there isn’t a SQL login.
Tweet This script will create a script to disable and enable all the trigger within a SQL Server Database. You will want to change your results to TEXT instead of GRID to get the line breaks for the “go”
Tweet A client was experiencing failures with the BizTalk job Monitor BizTalk Server (BizTalkMgmtDb), which calls stored procedure [dbo].[btsmon_Inconsistent]. This proc calls several other stored procedures to cleanup the messagebox and other meta-tables within BizTalk. These procs generate dynamic SQL scripts and to run against the tables within the BizTalk databases. Depending on your configuration, […]
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 […]
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.
Tweet Today I accidentally ran a script on master instead of the DB desired. So, I created a script that would create the drop statements for those objects. If some of the objects depend on others, you may have to run the statements a few times to get everything to drop.