Thanks for all the suggestions and help 🙂

I do need to know when the job is finished before continuing execution of the SP but I've never set up an unscheduled...

That's just what I was looking for - perfect !

Thanks.

Thanks.

Anyone have a brief example of the syntax?

Take a look at this solution it might be helpful.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=306601&SiteID=1

Have you tried using an ODBC type prompt like a question mark(?) ?

Can you move your SQL into a Stored Procedure and do your totaling there instead of in RS?

You’re only in your early 40’s ? Jeez… to be 40-something again.

After 28 years in IT at many capacities for many companies, educational institutions and government agencies I...

LSN: I think the solution you provided in #1 will work. I too am waiting for the RS gurus to weigh in on this issue but maybe it's...

Thx LSN. That helps to some degree. Unfortunately I can’t write a correlated sub-query since my data source is an old Informix database that doesn’t support that functionality. ...

Ha that's a great malaprop you mean 'shed some light' not 'shade some light'.

I just typed about three paragraphs of potential solutions and hit 'Preview' and poof!! all my text...

Try posting this in the Replication forum.

maybe one of the mods will move this to the Replication forum thread...

http://www.sqlservercentral.com/forums/messages.aspx?forumid=7

Lots of details missing - sorry.

The recovery mode is simple. There is no other DB activity. The SLA agreed to is 'restore to last night's backup @ midnight.'...

I don't understand that at all. There are times when I have to shrink or even delete the entire log file because of a ridiculously small hard drive.

I'll...

Yeah I got it Jon - thanks.

Outsourcing is a lot like any other business decision. There are times when it makes perfect sense to do it and other times...

Jeeeez... Jon I thought customers always rated IT departments on their ability to deliver quality products on time and provide courteous and qualified support. Is this a new concept...