Since when are the words shirt and shits not interchangeable :P.

Ok I type too fast and...

For the instances, just go tothe services panel in Administrative tools.

See if you have multiple verions of the same sql service... that's a tell of multiple instances.

Also see if the...

No need to pounce, I already got me free shirt from ssc ;).

Derek Dongray (2/24/2009)

---

Steve Jones - Editor (2/24/2009)

---

My connection seems to flake as well. I know there's a router that's flapping to new IPs at times because my IM will disconnect...

May I object for a while... wouldn't the true million be at 1 megabyte... hence 1 048 576 bytes?

Seems like you're still a couple weeks early.

Holly cr*p, 200 messages in a day!!!!!

For the first time I had to declare e-mail bankruptcy... just delete everything and move on.

can anybody resume the last day's comments in a...

Diff of master?? That db is usually under 12 mb. I'd stick to full backups and avoid the pain of a "more" complicated restore when need be.

That's what Jeff said when mentionning that there was 2 spid columns in the result set...

I'm guessing that the workaround is to manually mention all the columns in the select...

Then why the heck did I find this in active threads... thats,weird.

Anyways, moving on.

Why not bump the limit to a 1000?...

Can't be done... easily anyways.

Change to string if you must. Make sure you are aware that dates are not displayed the same way from one computer to another. ...

Before setting the control value you can check to see if the date is 1900/01/01. If it is, then show nothing, else chow the date.

Then when comes time to...

I know, all I'm asking is a link in there to go back to...

I don't know aspx code very well. That's going to be where you do a response.write or when you assign the value from the select to a label or...

This is something that has to be dealt with at the application level. You either return the data in your select or you don't.

At the application level, it's easy...