"Overloading" is a programming term for using a function for more than one thing.

The most common example that most encounter is that the "=" symbol has two functions, one to...

You're welcome.

The error is that the device is not available. Are the files where you're expecting them to be? Check the folder referenced in your restore commands and see...

See if this helps: http://msdn.microsoft.com/en-us/library/ms177400.aspx

Do your log backups get purged periodically? Or archived offsite or something like that?

GilaMonster (3/16/2011)

---

CirquedeSQLeil (3/16/2011)

---

GilaMonster (3/15/2011)

---

WayneS (3/15/2011)

---

Now I really want to see it! Good job on insulting any and all... sounds like Jeff and his pork chop launcher might be rubbing off...

I may be missing something, but what new thread? I only see two posts for your account, and they're both here.

Per your original post, you have a syntax error...

Brandie Tarvin (3/16/2011)

---

I'm not sure what you mean by "and the end". Could you clarify?

Notifications on jobs are not related to job steps and not configured by step. They are...

Microsoft has tutorials on it. Bing/Google/whatever "SSAS tutorial" and the ones on TechNet are right there, along with some videos on YouTube on the subject, and other options as...

tfifield (3/16/2011)

---

Bob,

You may want to check out using a synonym in your data retrieval queries and have 2 tables for order strategy. I've used it successfully on a couple...

You'll be able to get all of that through a CLR function/proc. Is that an option for you?

Is the OrderStrategy table session-specific?

Kind of like a temp table, but multiple processes access it from multiple connections?

If so, there are easy solutions for that, which don't involve truncate or...

Vertigo44 (3/16/2011)

---

Got it! Thanks!

I was scripting out to a new windows each of the options to see where the difference was. That's when i noticed the lack of norecovery at...

Vertigo44 (3/16/2011)

---

GSquared (3/16/2011)

---

You will definitely need to do the tail log backup before you start restoring, unless you're restoring to a different server/instance, or to a different database name. ...

Service Broker would definitely be better than in a trigger.