Henry Doorly (sp) Zoo. Beautiful place.

Fontinelle Forest (for hiking)... Lots of huge parks in the area....

Been there. Beautiful place.

Marv-1058651 (10/19/2010)

---

I would love to add some results and ddl, but unforutantely, I am dealing with patient data. I can dump some dummy data to display instead. Here is the...

That right there might be the problem. I don't know if SQL Agent is actually needed for the install, though.

I would just like to let everyone know that I live very green.

My sheets are green, my clothes are green, my food is green, my cats are green... Oh, wait....

davidandrews13 (10/19/2010)

---

Brandie Tarvin (10/15/2010)

---

Not a horror story, but definitely a cringe moment.

A job where the Dev instance was on the same server as the Production Instance. SQL Security was not...

Roy,

What is it deadlocking?

What exactly is the question? @=)

Is there a difference between the service accounts used for the other instances and this one?

If so, are you sure the accounts have the necessary permissions for installation?

And he seems to have responded well to all our responses. He's...

Added in a second penny. Hopefully that'll equal two cents worth.

In addition to the maintenance plans listed above, you should also code a job that checks file sizes verses available disk space to make sure you aren't running out of...

A few notes. Use Truncate instead of Delete. Truncate logs only the extents being deleted, not the entire record like Delete does. Hence, it's quicker. Also, be aware that using...

Quick note that has nothing to do with resolving your problem, but could save you a lot of typing. You don't have to Declare each variable on a separate statement....

The only thing I can think of at this point is either that the GUIDs already exist in the table that you're trying to load the Excel sheet into or...

Please start a new thread for your question. Most people consider this one resolved and won't answer.