Steve,

I meant to say that, although I've not been participating in the QOD for a while, I'd be glad to help out with this too, if you'd like.

Cheers,

Chris

PS. Nice...

I am also interested in getting instructions about how to sign up for the electronic version of SQL Server Standard.

Thanks,

Chris

By saying "something like CopperEye technology" you make it sound like this is something everybody knows about. Unfortunately, CopperEye's technology is patent pending and under wraps. Do you...

Aargh, Steve is right. Just to clarify the confusion (?) the reason some people (myself included, sorry) fall into calling it "Beta 3" is that this is what it...

Beta 3 CTP is available at http://beta.microsoft.com. You have to apply for membership in the SQL Server 2005 beta program before you can get the goods, though....

Yelena,

Without enabling C2 auditing, you could not use a Profiler event to *reliably* answer the question "when did login X last change its password?" The problem is that the...

Hi Yelena,

Ah, the good old days. :o)

You raise some good points, but we certainly have applications where, for other reasons, we store text and binary lobs in the database....

Talltop,

I see that you edited that post. So ... good catch!

Cheers,

Chris

Talltop,

Why do you think you cannot update NTEXT with an UPDATE statement? If that were true, all the newbies would wonder why they could not, for example, change Nancy...

You can add me to the bandwagon of people scratching their heads and wondering how 4200 Unicode characters suddently got to be greater than 120 KB in size. I'm...

As somebody else has posted, rebooting the SQL Server would cause the SQL Agent to restart. Since the Agent is required to run the maintenance plans, it's pretty safe...

Steve, I just want to say that I think the way you've been responding to these QOD forum posts lately is great. Keep up the good work!

-Chris

Good catch, Briscoe - I didn't think of that at all!  But that's not why I'm here...

I usually like to answer questions when I am here, but I want to...

Can you set up a linked server on the new server that points to the old server?  If so, you could use a bunch of INSERT .. SELECT statements to...

Dear Ohio,

What edition of SQL Server are you testing on?

-Chris