Andy, Your suggestion is right on the mark from what I have seen. I'm not sure who started the rumor that AD could be a viable store for data other...

Brian,

Great article. One which I will use to now define my job better with management. Just hope that the "Hybrid" title does not stick in the industry. Maybe their should...

One more in agreement with Nigel. Have an identical setup to what he described for the very reason that you don't know what type of read only querying is going...

I inherited this pain on two servers and I could never begin to understand why it would come into being in the first place. Andy - I appreciate your real...

Microsoft Technet states the following;

"Use sp_attach_db rather than sp_attach_single_file_db to attach a database with

multiple log files. You cannot attach a database that has been created with

multiple log files without also...

Hey Alan - Long time no see! Actually I have two in excess of 18 Gig and one that is rapidly growing to the size of 35 Gig where it...

Somebody else may have a better / different way of doing this but, I usually use a transform task or a bulk insert task to put the file contents into...

I will usually slap a print in there so that I can see what I am about to run and troubleshoot any formatting issues here. An example using Andy's submission...

bobl - You stated that the "trigger fires the job, and the package works; but the job won't run the package" Have you tried running the job directly from EM...

quote:

---

And while you're at it, unless you absolutely have to, do not turn on Case Sensitivity. With both, you will end...

David,

Very cool!! I love learning neat little tricks like that. Thanks!!!

David

Ooops! Sorry I meant Steven!!!!

David

select @@version will get you the information you are looking for.

Versions are as follows

SQL Server NoSP ...

Both are 7.0! Thoughts? TIA

David

I ordered a set from MS some time ago and have yet to receive. So, go with Andy's option as you will get it quicker!!!

David