The bits of status require a knowledge of "bit mapping".

As you know, the "value" of each bit in a byte or word doubles the previous one. To count the...

Gosh... you can use Hungarian notation if you want, but I think it's a real PITA. Let's say you have a table called something like tbl_MyTable. Someone redesigns...

Oh.... be careful... you didn't include anything to limit the update to a single row in the table. Your current query will update the entire table all the time!

It...

Why? What is it that you're trying to accomplish?

Now back the migration pony up just a minute, please! How did you do the migration? It's important to know because some methods absolutely guarantee that the databases,...

Dugi,

I'll make you a deal... if you provide the test table and the test data IAW the link in my signature, I'll show you a method that will blow the...

Also, if your access is restricted, why are you the one doing the data transfer? Have...

IMHO... it's ALWAYS worth doing.

BWAHAA! Move to a bigger house so it can have it's own bedroom! 😀

I agree with the others... stick it out for at least 90 days. If I had quit my previous job due to "disuse" in the first 90 days, I'd...

Although NVarChar(Max) is preferable in my book over NText, NText is still available in SQL Server 2005 (according to BOL) and you shouldn't have to make the change you speak...

They probably mean "UniqueIdentifier".

I'm sorry I missed it... Congrats on the 6k milestone, Gail. 🙂

Heh... the "other" way is to simply disable the users... when a proc fails or a user sqawks, then you know you've got a live one... 😛 You laugh!...

Do they still have "C2 Auditing" in 2k5? If so, that would probably do it.