You can use the DAC if you are a local administrator to connect and reset things

http://blogs.msdn.com/sqlexpress/archive/2005/09/08/462609.aspx

So, in addition to doing a restore, you need to check your hardware. This could happen again.

Did you upgrade SQL 2000, or add a 2008 instance or do something else? If you have two instances, you might be eating up memory as well.

Have you run this from just SSMS or SQLCMD?

I doubt this is corrupting tempdb, but it would be good to run this without a VB client to see more details.

As a hint, a cross tab or PIVOT might be what you need.

What do you mean, concatenate rows? Specific counts, or a however many meet some criteria?

Showing some sample data and DDL would help.

I could live with the 24 clock, but I like DST, and I like my pounds, inches, and miles!

These forums, I think, do require pointing out of mistakes for the reasons Jay mentioned. However if it's something like a typo, I have pinged people to privately edit their...

To see history, I think you need a Google account that you are signed into when you search. I typically remain signed in with Google on my machines

There is a lot of money to be made selling information about people. Years ago I worked in a startup and we would regularly get lists of people to email/call...

This is something to keep in mind as you work on old code as well. If you have a 2005/008 system with these types, refactor the code to use the...

Very nice editorial, Tim, and I'll respond before I head out for a much needed break today.

Whether it's business communication, or posting here on the forum, I think small errors...

majorbloodnock (2/25/2010)

---

Agree totally with the editorial. Constructive criticism is almost always the right thing to do, and if it's not appreciated then at least you know you did the right...

I agree with Jason. Be careful what you ask for here.

The site is here http://www.sqlsaturday.com/

It's a brand/franchise started by myself, Andy Warren, and Brian Knight, founders of this site. We built it to get one day events going to help...