It's not a bad idea. What I think we would like to move to is more of a tag based system, like at ask.sqlservercentral.com.

I did some work for a dentist, he was OK other than not wanting to pay. Worked for a builder as well. Not fun.

Wow, that's something.

Let us know if you find anything. This has been very interesting.

If you are around average people, or those that aren't smarter than you in the area in which you work, it's tedious. It's moving along, and it's easy to get...

OpenID has providers from a number of sources. I use my Google account, and as long as I'm signed in on a browser, that works. Not sure if any of...

Your post was fine. I added this reply to a couple threads since a few comments were approaching the personal line. I just wanted to remind people to keep things...

Check the default trace. That should tell you who sent it in

I received a complaint from the user about some of the postings. While I told him/her that I disagreed with the tact they were taking and that I understood the...

I received a complaint from the user about some of the postings. While I told him/her that I disagreed with the tact they were taking and that I understood the...

Good luck, Wayne. Remember, it's just a job.

The uninstall, AFAIK, doesn't remove data files or things in the registry that might be used if you reinstalled. If it's not in the Control Panel or Cluster Adminsitrator, delete...

I would think this is the DDL to create a procedure. If it's suspended, maybe the network link got shattered and SQL didn't close it out properly? Can you kill...

I'm sure you'll enjoy it. Feel free to stop any of us and say hi.

You'd have to cast it out, separate the parts, get the totals.

So for seconds

cast( substring( cast(run_duration) as char(6), 5, 2) as int)

You can get minutes * 60 (for seconds)

cast( substring(...

restorehistory - http://msdn.microsoft.com/en-us/library/ms186782.aspx