Is this an .msi install package or a DVD install?

EDIT: Nevermind. Thought this was the OP.

No. No, it's not. It's just sleeping.

Ninja's_RGR'us (7/28/2011)

---

Brandie Tarvin (7/28/2011)

---

Ninja's_RGR'us (7/28/2011)

---

Wow that's so nice. I had heard about it but never played with it. It's like the Loch Ness Monster, so glad I finally...

I don't know how it works in other RDBMS, but in SQL Server, the identity function prevents you from inserting new numbers unless you specifically tell SQL that you're inserting...

Did you review the summary log to see what it said? Or the bootstrap log?

It's...

Kiara (7/28/2011)

---

Ah! *comprehension dawns* You mean the time where the work location shifts from the desk to the car and then to the sofa!...

Don't use the registry. The setting is in the SQL Agent Properties.

See this link: http://blogs.msdn.com/b/sqlagent/archive/2010/10/15/turning-on-verbose-logging-in-sql-agent.aspx

I understand your problem, but your clients really should do the following:

1) Back up SQL Server locally

2) Back up the SQL Backup location to another drive (network drive, tape drive,...

Just an FYI, trying to concat anything numerical tends to add it, not to concat it. So you will always need to convert numbers to strings before concateonating to make...

I agree with Sean that you are playing with fire. However....

IF (SELECT data_type FROM Information_Schema.Columns WHERE Table_Name = 'MyTable'

AND Column_Name = 'MyColumn' AND data_type...

What you posted, and the title of your post, are two different things. I don't think you need to loop at all.

What you need is to write up your OUTER...

Kiara (7/28/2011)

---

I can offer two day old peanut butter and...

As Gail said, SQL Server makes the choice in the deadlock situation. You don't get to pick. The only way you could pick is to do it manually, but usually...