0

Find missing SQL Server Indexes

Posted by Chris Straw on August 22, 2018 in Database, SQL Server |

Tweet The original post is here: Find missing indexes using SQL Servers index related DMVs  

Tags:

0

Find SQL Tables with Identities

Posted by Chris Straw on May 2, 2018 in Database, SQL Server |

Tweet

Tags:

0

Find Orphaned DTA Service Instances with SQL Query

Posted by Chris Straw on October 26, 2013 in BizTalk, SQL Server |

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 […]

Tags: ,

0

SQL Query to list BizTalk Hosts

Posted by Chris Straw on October 26, 2013 in BizTalk, SQL Server |

Tweet This query will give you a list of the BizTalk Hosts:

Tags: ,

0

Enable User without Login

Posted by Chris Straw on April 25, 2013 in Database, SQL Server |

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.

Tags:

0

Disable/Enable all triggers in SQL Server Database

Posted by Chris Straw on May 12, 2012 in SQL Server |

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”

Tags:

2

Monitor BizTalk Server (BizTalkMgmtDb) SQL Job Fails

Posted by Chris Straw on May 1, 2012 in BizTalk, SQL Server |

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, […]

Tags: ,

0

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 […]

Tags:

0

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: ,

0

Script to delete all objects from SQL Server

Posted by Chris Straw on February 2, 2012 in SQL Server |

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.

Tags:

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