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...

thx for the reply.  Unfortunately, the solution is not returning the "table name"  -- ONLY the rowcounts.  Is there a way to modify this statement to return the "table name"...

My alter ego pulled this together:

This Statement returns the last DAY of the prior QTR with TIME = 00:00:00.000

SELECT

CONVERT(DATETIME,