Latest DTS Package Log

This script returns the latest package log for the DTS package specified in the @package_name variable.  The interface for viewing DTS package logs through Enterprise Manager is limited in the fact that it doesn't provide textual descriptions of the values for the Step Execute Status and Step Execute Results.  This makes it difficult to trace […]

2002-10-22

609 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

Upgrading SQL Service Packs on multiple versions

By Lord Slaagh

Hello SSC, My company has SQL versions that range between 2008 R2 to SQL...

Dynamic images within my report

By Shabbaranks

Hi, Im trying to get dynamic images in my report based on a Tablix...

Setting fill factor on an auto-increment INT clustered index

By Mr. Holio

Hi all, Please consider the following table structure. CREATE TABLE [dbo].[Transactions]( [Id] [int] IDENTITY(1,1)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers