Viewing 15 posts - 16 through 30 (of 76 total)
I have already tried the delete and recreations. This did not work. :: sigh ::
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
December 1, 2010 at 12:04 pm
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...
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
November 30, 2010 at 12:27 pm
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...
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
November 30, 2010 at 12:11 pm
I was afraid of that. I was trying to get away with not using any dynamic sql. :: sigh :: I guess i am stuck. ...
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
November 30, 2010 at 12:05 pm
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...
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
November 30, 2010 at 9:45 am
Remember the replication is already running. I use the sp in the following manner:
EXEC sp_reinitsubscription
@publication = N'MCSTST7',
@subscriber = N'ODDBMSREPT02\ODDBMSREPT02', --$(SubServer),
...
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
November 24, 2010 at 9:32 am
I literally took thje suggestion of the page. I took the passed in parameter and assigned them to variables inside the proc.
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
November 9, 2010 at 8:33 am
Yup, Gus was right on! I did some tweaking of the proc and viola! Problem solved. Thank you all for the help.:-D
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
November 8, 2010 at 5:05 am
The make up of the SP is(I didnt write it so no yelling LOL):
CREATE PROCEDURE [dbo].[rpt_listEmployeeMissingReceiptDetailReport]
@ManagerName VARCHAR(50),
...
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
November 5, 2010 at 1:14 pm
I will look at it.
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
July 7, 2010 at 11:03 am
I only need the data.
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
July 7, 2010 at 10:52 am
BTW - both DB's are at 90 Compatibility.
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
July 7, 2010 at 9:56 am
What about SQL 2005? Is it possible here?
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
March 8, 2010 at 7:09 am
I need to do this based on the login/user. Did you get any responses that helped?
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
March 8, 2010 at 7:03 am
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...
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
June 3, 2009 at 7:40 am
Viewing 15 posts - 16 through 30 (of 76 total)