Thanks for the suggestions ratbak!  I'm doing the free trial of Telerik now.  It seems a bit more limited than Crystal in terms of functionality, and some aspects of it...

Still struggling to get this working, still hoping for any other suggestions.

I've tried giving the AD account that runs the job db_owner permissions on all DBs just to see if...

Hi Michael, all of the SQL agent jobs associated with replication are running as sa.

Thanks Alejandro, but I already tried their suggested solution (see #4 above).  Also, I never actually changed the SQL Server Agent service startup account, so I'm not sure it would...

If it was a single procedure, or only a few procedures, I would determine if the plan in the cache is a less than optimal plan. If that's the case,...

I appreciate the feedback.

One reason I've used index rebuilds in the past is because some of the third-party apps we rely on can sometimes end up with a query that...

• This reply was modified 2 years, 8 months ago by  tarr94.

It looks like the login did have the permissions it needed, and that the issue was related to the T-SQL I was trying to use to rebuild the indexes.

Michael, does...

Thanks for the reply, Michael, some very helpful information there.

At this point, we are exploring our Data Masker tool to get a feel for how much effort is involved for...

• This reply was modified 2 years, 9 months ago by  tarr94.

Hey Frederico,

The slow query is a call to the sp_cursoropen, a system sproc I shouldn't be modifying.

I'm thinking the SQL statement that gets passed into it is causing the issues. ...

• This reply was modified 3 years, 2 months ago by  tarr94.

Thanks for the replies Jeff and Frederico!

Unfortunately, we're in sort of a weird spot as far as going back to the vendor.  Since the data that populates on the equipment...

Mr. Brian Gale,

Your feedback is much appreciated, this is some awesome info on SSIS, a tool I've had limited exposure to, but I've seen it come up on some ETL-related...

Thanks Thom, that looks much nicer and works well!

Thanks to both of you for confirming.  I'll take a closer look at CDC as a solution.

Thank you everyone for your suggestions!

With a fairly short timetable with which to implement a solution, I may not be familiar enough with some of the implementation details of the...

Still never found the reason this suddenly became a problem for us, but we were able to solve it by adding the IP address of the box to the intranet...