Correct, in SQL Server 2005 it is possible to create DDL Triggers, i.e. triggers that are triggered by DDL statements.

Same advice again: Can you produce a repro? If so, then open a case with MS Support and record it as a bug.

No problem, happy to help. Note that starting up a database is an expensive operation, so if the database is not very seldomly used it should probably not be set...

Is the database configured for autoclose?

SELECT DATABASEPROPERTY( 'db_name' , 'IsAutoClose' )

Unix Date/Time is represented as the number of seconds that have passed since 1970-01-01. So you could of course simply store it as an int, but then you would need...

Also, I still need to adminster a couple of sql 7.0 servers. Will the upgrade to sp4 affect the Enterprise Manager client tools?

There should not be any problems with...

Like I said, I would not use the table design that you have. I would move the numbers to a separate table. The only problem with doing that is that...

Now, I do not want to go into any religous discussion here, but why use those M$$QL and "reuses ideas" 'tokens' to try and enforce your message? The only reaction...

I might be wrong, but I am pretty certain that there is no way to check which login created an object. In fact, the login might not even exist anymore.

Wasn't this answered in your other thread? As noeld explained there, SQL Server stores datetime data using two 4-byte integers, regardless of how it is entered. SQL Server supports...

Please do not cross-post across the boards. See noeld's reply in the other thread.

I will be there. And also at the PDC in Los Angeles two weeks earlier, if anyone is going there as well (or instead). Two trips back and forth between...

Yep, that standard would not be so great when you need to rearrange the column order of a 200+ million row.

I must recommend you to change your schema. I would definitely move the betnumbers to a separate table, since that would make the querying much easier. For instance:

CREATE TABLE BETNUMBERS...

Unless you specifically need some feature of CDONTS (I am not quite sure exactly what you can and cannot do with it) I would recommend you to use Gert Draapers'...