Thanks Gail, that was actually the first article I read on the subject :-). Re-reading it I was able to take away a bit more. And thanks for the explanation...

iqbal1258 (10/19/2011)

---

Hey Guys Nothin to do....

Chek firs mdf and ldf is exist or not..

if exist run below coommand on master DB

ALTER DATABASE 'DATBASE NAME' SET OFFLINE WITH ROLLBACK IMMEDIATE

ALTER DATABASE...

Thanks sushila for your comments so I don't have to. I agree with what you said.

I enjoyed the article and am looking forward to seeing the set based solutions...

Thanks I will look into that. I have also considered eliminating the job and using a stored proc. We probably have no good reason this process needs to...

Did you actually try that by calling a second job from the first or did you just execute the query after executing a job? I was looking at doing...

The job is executed from a vba macro. Perhaps I should capture the login here and update the table, but was hoping to have it done in one update...

HOST_NAME() returns the name of the server the job is executing on.

I do this very thing. It uses one stored proc and a job with two steps. I got this from: http://www.databasejournal.com/features/mssql/print.php/10894_3414111_2

I'm finding myself agreeing with Steve on this. I'm also wondering why some folks are so opposed to their salary being exposed. From looking at the discussion I'm...

Yes this is an interesting debate. Here's my incoherent rambling... I worked in State government for nearly 11 years and worked on the State's Budget System amongst many other...

Thanks. That reminds me that I really need to become more familiar with all those views.

For the second half of the question. Do you have any idea if...

I hear ya. Thanks to everyone for their input. I'll move forward with some cursory testing and hopefully get a chance to speak with MS. At least...

Yep, I've seen that, had a little chuckle....and quoted that to management. ...and I'm going to experiment with it anyway :w00t: I am approaching management with the idea...

Thanks for the input Ed. I am definitely more inclined to push for some new hardware after what you and Vassie have written. I hope to be in...

Thanks. I should have probably explained that we won't be getting new hardware so the existing hardware will have to be pulled into the new domain. We will...