I have already tried the delete and recreations. This did not work. :: sigh ::

I hear ya. I have gotten them to do a lot of things since my tenure here as the DBA. Getting the time to fix other things is...

Old version vs New Version. Not all of my clients have been updated and my developers have not given me a way to check the version so I must...

I was afraid of that. I was trying to get away with not using any dynamic sql. :: sigh :: I guess i am stuck. ...

The column CLIENT_ID does not exist. That is why I am doint the check for it before hand. In the older version of this database, is is simply...

Remember the replication is already running. I use the sp in the following manner:

EXEC sp_reinitsubscription

@publication = N'MCSTST7',

@subscriber =...

I literally took thje suggestion of the page. I took the passed in parameter and assigned them to variables inside the proc.

Yup, Gus was right on! I did some tweaking of the proc and viola! Problem solved. Thank you all for the help.:-D

The make up of the SP is(I didnt write it so no yelling LOL):

CREATE PROCEDURE [dbo].[rpt_listEmployeeMissingReceiptDetailReport]

@ManagerName VARCHAR(50),

...

I will look at it.

I only need the data.

BTW - both DB's are at 90 Compatibility.

What about SQL 2005? Is it possible here?

I need to do this based on the login/user. Did you get any responses that helped?

I am looking at the Can:started/Stopped. I have the TSQL option and the SP options in my trace. I have nothing in my trace results but lock acsuired...