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.

Matt Miller (2/2/2009)

---

Lynn Pettis (2/2/2009)

---

Typical geek, can't stay away. I should know, I do the same thing here, even when away...

latingntlman (2/2/2009)

---

Thanks, that worked.

Another question:

I'm trying to add a Data Flow step to my package thru BI Studio, but can't seem to find the equivalent of sql 2000 Server Enterprise...

GilaMonster (2/2/2009)

---

idrees.butt (2/2/2009)

Sure....

Please take the time to read the first article linked in my signature block below regarding asking for assistance. Follow the guidelines in that article and post your table...