Deek, The above worked for me, but if your "TableName" is actually a VIEW or not a "Table", the so.type = 'u' is limiting your results. Try and so.type =...

Frank,

I was looking forward to your response . I knew I could get you to write a "short story" length post

Thanks Tony,

Thank god, just little (<MB - > ~ 10MB etc) files here and there, nothing scheduled or anything, just when we do some work on the LAN, and...

Frank, I understand where you are coming from, and generally Erland's ideas are Ok I guess. but...

99.9% of my SQL work has no client interface at all, it's all just...

Understood. So I had my SP named ExecSQLAsyncSP named right to start with.

Asynchronous = Parrallel

Synchronous =Serial

Are you using the same login credentials in EM as when querying sysjobs?

I agree with the Backup / Restore statemnts above. Not sure, I believe you can actually use the backup file and attach it as the DB, In other words, the...

My "slant" was having a generic "hey SQL, go do [this], and come back right away, don't wait for [this] to finish".

I'll usually write an SP that handles all the...

Andy Warren ,

I've posting into another thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=97068 with SinLam on a closely related subject.

I think...

Ok, I'm writing this in Q/A 1st, then reply & paste.

Maybe I timed-out earlier ???? This post will be shorter

mainly because the network guys might have things for me

to do...

I could swear the old Active Threads listed them in reverse cronological order. Then again it might be me just not paying attention, or just plain short term memory thing...

Just do

EXEC SyExecSQLSyncSP 'EXEC BackupAndRestoreMyDB_SP'

The WAIT FOR, was just to demonstrate the processing would return to the current "scope" nearly instantly, while knowing the command issued Syncronously would take...

Darn-it, just typed 30 mins worth of stuff, hit "post" - all gone

Will re-write condesed version again in a few....

I guess your SQL Server has "no more work to do", go home, retire... 

I know you've tried to cold restart the PC, right?

Did you install...

I agree. I think I metioned this sometime before ???? Forgetting things now a days ... I would like to display the Active Topics...