Look up attach in Books Online. you can re-attach the data files.

However that won't get you logins.

What was the problem originally, and what did you do?

What about DBA's Delight?

That's the modern holiday, fireworks. Even reading the Declaration of Independence last year with my son didn't register with him.

I think it's a great day in the US, and there...

I don't know, but I'll ping a few people tomorrow.

The site was founded in the US, and we're still > 70% US members, so we do some fun questions for holidays here. Outside of the US, feel free to...

No, don't do that. The system expects two log files. Attach both, then try to use SSMS to remove the 2nd one. IF it doesn't work, try a shrinkfile to...

Shared logins might be hard to get to work, and I'm not sure how we could get permission from people to use them.

We try not to link to places that...

Perhaps not a great attitude, but that's not how I read it. Seems more like a cultural "terseness" that I see from many newbies in non-English speaking cultures.

The DAC times out?

On a local connection, that is surprising. I think you might want to reboot the server, and if this happens again, perhaps hold a DAC connection permanently...

Is the issue just maintainability? Are you worried that customers will alter the script and then call for support? A surcharge for support might solve that.

The other thing you could...

I'd tend to agree with Gus. I think lots of DBAs don't know .NET very well.

Blandry, I think you're in a place where you are looking for more well rounded...

Dave, I would tend to agree with you that it should be zero. Sorry, out and about with no instance to test on right now.

It shouldn't need to reconnect to get performance up. We'd need more information, but I'd suspect a leak in your utility somewhere, not SQL Server.

Is it possible your client tools are at a different rev from the server? Meaning are they both SP2, SP3, etc.?

We tend to only for service packs, which means we reboot about once or twice a year for this site. Rarely unless there are isses, and it seems in IT,...