No can do.  The obvious enhancement would be to alter the column to DECIMAL (10,4) or greater.  BUT this has ripple effects downstream to additional receiving columns also defined as...

It's the 1st Task.  I mirror'd a solution I found on this forum:

http://www.sqlservercentral.com/columnists/tdavid/moreportabledtspackages.asp

My pkg runs DynPropTask #1 1st -- issuing a SELECT SERVERPROPERTY('SERVERNAME')

It runs fine on my QA Server.  When I...

answer is yes

thx --exactly what I was looking for!

I wound up adding entries into my local HOSTS file (IP Addresses and matching Server Names).  I can now Launch Replication Monitor and "Add Publishers" !!

Turns out, the DBA before me incorrectly setup the @filter statements..  They should only contain 4 parameters.  Problem Resolved.

I found this XREF List: http://www.transactsql.com/html/sp_trace_setfilter.html

Problem resolved.  Exact sequence of events:

-- Installed 2000 SP4 only & bounced my desktop (problem persisted)

-- re-Installed SQL 2000 STD edition w/ explicit INSTANCE name & bounced my desktop (problem persisted)

-- Installed 2004...

thx Yelena -- much appreciated!

Here is the SQL (renders table sizes):

--Declare/Open/Fetch/Close/Deallocate CURSOR sample

declare @UserTableName nvarchar(40)

declare UserTableSize cursor for

 select rtrim(name) from dbo.sysobjects

  where OBJECTPROPERTY(id, N'IsUserTable') = 1 order by name

open UserTableSize

fetch next from UserTableSize...

Larry - I need to reinitialize 1 article (of 9) in a single Transactional/PUSH subscription.  You mentioned that you've accomplished this.  Would you be willing to share this knowledge?   (this...

My alter ego found this:

DBCC TRACESTATUS 

You can use DBCC TRACESTATUS command to get the status information for a particular trace flag(s) currently turned on. This is the syntax from...

CREATE TRIGGER [trgu_TABLE_A] ON [dbo].[TABLE_A] AFTER UPDATE, INSERT

AS

BEGIN

 UPDATE TABLE_A SET ChangeDate = GETDATE()

  FROM inserted i INNER JOIN TABLE_A c ON i.ID = c.ID

END

I believe this is an authorization problem.  I am able to "Add Publishers" where I'm Local Admin.

Please disregard.

I've resolved this by adding an additional step to our "Log Reader Agent" jobs.  After creating the usp_send_cdosysmail stored proc in Master (<--- search the net for this one), I...