I think there is a CASE statement missing in the dynamic sql as I have a WHEN but no corresponding CASE.

And you don't have to wait until you are a "Jeff" or "Gail" to write an article. I don't pretend to be at their level and I have written...

As asked before, what is the recovery model for the MOM onepoint database?

Oh, right, the World Cup is the only TRUE World Champsionship Game.

:w00t:

Not an error I have experienced. I'm with DavidB, what do the SQL Server and Windows logs show at the time the server stopped responding?

Just remember that the help you get here is free, so don't get impatient if you don't get a response right away. We do this to help out our...

I think that may only be true on Express. I have DAC enabled on our servers and have tested connection to it without having to restart the servers with...

Try adding the database name to the query: pubs.dbo.authors (or whatever your db name is).

I would not trust restores using an open-file backup. You don't know if the database will be in a consistent state upon a restore.

We have ARCServer on several servers....

When you configured SQL Server 2005 did you enable DAC? If so, can you connect using it?

bvaljalo (1/29/2009)

---

Wow.

1,000,000 users on the site, and not one person can take a few minutes to help me out with this.

I'll be sure to keep the *amazing* resource...

Can't help if we don't know what the problem is. Your post doesn't provide any details.

Let me know if this fits your bill:

declare @secs tinyint,

@mins tinyint,

...

Ivanna Noh (2/1/2009)

---

just been to see "Revolutionary Road" - quite good, but pretty angsty

best movie i've seen for a while was "The Illusionist" (2006) - captivating movie with a great...

Are you inserting or updating data? You say inserting in your original post, but I'm just checking to be sure.