Greg - thx for this info.   Couple of questions:

1) How do I go about configuring the master DB for allowing updates?  (didn't know you could update system tables in SQL...

nope.. all set.. But thx anyway.. (my alter ego kicked in)

Actually, my existing 2000 script still works IF I create it in a non-system DB and exec it from there (and qualify the sysprocesses & sysdatabases tables w/ master..

CREATE procedure...

Resolved !!!   I needed to add the CASE statement check for NULLS.  This resolved the issue -- here is the new SQL:

SELECT

 T3.AssetClassId,

 CASE WHEN Round(100 * SUM(ISNULL(T1.AssetAmount, 0)) /...

Close but no cigar..  We've had 3 DBA's and a couple developers attack this one and still no resolution.  Need to start by understanding why this SQL is returning error:  ...

Actually - the error stems from the following subset of the above SQL:

SELECT T3.AssetClassId, Round(100 * SUM(ISNULL(T1.AssetAmount, 0)) / T2.InitialInvestment, 1)

   AS AllocatedPercentage

   FROM TAB_1 T1, TAB_2 T2,...

Based on a few tests, I narrowed the SSIS logging events to limit the extraneous info being captured.  Here are the Logging Events I selected to reduce the extraneous info:

OnError

OnExecStatusChanged

OnPostExecute

OnPreExecute

OnTaskFailed

I apologize for NOT includnig DB5.. in the above predicate.. ANYWAY, I found a solution for this situation --

Using SQL Server 2000 - in Enterprise Mgr expand a DB and it's...

After further review I found that 2 of the DB's are Reporting DB's (activity except READs against these DB's) therefore we never setup transaction...

I use DBCC SHRINKFILE too.  Identical to DBCC SQLPERF(LOGSPACE), I log on to the server and use Windows Explorer to view the actual file size allocation.  I realize you cannot shrink...

Thanks for the info.  I've actually done this successfully as well.  Considering the fact that I'd like to tune dozens of procs - this is cumbersome and time consuming.  Just...

Do you know how to add in the VB.Net toolbox items? 

My current VS 2005 (for BIDS) does not contain any VB.Net tools in the toolbox.

Wish it were that simple.  I inherited this design and it's fixed across a large, 1 TB SQL DB environment.  To alter the design would require altering dozens (potentially hundreds)...

All I had to do was hilight the field, click F4, Select Format, and type P2

dragged & dropped a "TABLE" from the toolbox then manually began to type Header column names & individually right mouse click on each DETAIL cell supplying =Fields!xxxxxx from the "Value" drop down.

ALTER...