This VB script allows you to search DTS packages for keywords, etc. It is also useful for quickly locating what server a given package is on. This is very useful for debugging. Example - you want to know the name of every DTS package the touches a certain table. The text files generated contain the […]
2006-01-18 (first published: 2005-12-07)
5,890 reads
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
I have two tables namely Vendors & Visits. Create Table Vendor (VendorId BIGINT IDENTITY(1,1)...
I have this report, see below, that works great. Enter the employee number and...
How can i get the counts of how many records updated and how many...
Ask SSC