I first learned database design in the late 70's, and it was pretty much "IsActive" everywhere.

you would rarely see a IsInactive. I think it was the oddball guy who...

Hey Gail, my memory is failing me.

What are the reasons again to put varchar(max)'s at the end of the table.

I remember Kimberly and/or Kalen talking about this years ago and...

sorry to say, but your question is bogus. I just ran it on my SQL 2008 instance and received no row(s) effected message at all.

default settings. Doesn't even...

Nice find. I really think it's a bug though. And MS will probably fix it in Denali or a later version.

Have you tested this with Denali?

I'm suspecting a Windows update recently broke something as this has never happened before a month ago.

I've gotten the same error on two different servers within a minute of each other. Same situation with transaction backup logs. It happens once every couple of weeks...

stewartc-708166 (5/26/2011)

---

nigel. (5/26/2011)

---

Steve,

Thanks for that question, I'd was not aware of 'loginproperty' until now.

One question though. I tried to recreate your scenario but always get '1900-01-01 01:00:00.000' as the...

While, I knew what it was suppose to do, I tested this out on my own box and somehow it wasn't recording the datetime of the bad password attempt??? Not...

yes, sorry I screwed up.

ok, then I guess it tricked me. :~)

I don't remember the question stating to change the default date setting.

under default settings, they work fine.

All 4 work on my SQL 2008.

bogus question...

But if you suggest the database is not to format data nicely, why even have the convert, cast, substring, etc... functions??

I would argue that a significant amount of database development...

I know a lot about 2k8, but wasn't familiar with this at all.

Plus, the question reminds me of an episode of Whose line is it anyway where they do a...