Just out if curiosity.

Is BINARY_CHECKSUM() available in SQL 7?

No, with C2 auditing you get all or nothing. But maybe there are third-party products around.

Me bad! No offense meant!

Yes, relational database theory as Dr. Codd has defined it is not very good implemented in SQL. But that's the tools we are given and have to live with.

And how do you retrieve the data?

James,

yes, I know.

"Against stupidity the gods themselves struggle in vain."

Nobody will benefit from a clash. That will not generate a win-win situation.

...anyone...

Hm, Jonathan, that reminds me of those quizes on TV where you have to tell your name, and if you're right, win $1,000.

...

There is no such thing as a free lunch.

If you want such feature, I guess you have to implemtent it yourself.

If you wait (a little bit longer, as we can read today) for Yukon, you won't run into these problems anymore.

Now that you've mentioned it.

Hey, that guy Gary Larson is even known here in Germany.

I am being told that there is no benefit to having a primary key defined, especially a surrogate key of identity if it is not used in joins.

I...

I would say that this is expected behaviour.

When you don't supply a time portion, SQL Server assumes 00:00:00.000 that is midnight.

When you change your query to

select * from t1...

I might be mistaken, but in a relational database (no matter which product) ordering is meaningless and irrelevant.

While having an index works in most cases the ONLY reliable way...

Thanks for posting that info!

The only way I know of to mark an object as system object is the undocumented s_proc sp_MS_marksystemobject. It sets some bits in sysobjects.

What happens when you create a...