Well, first of all you do not need to, CLR is disabled by default. But enabling it does not really do a lot unless anyone starts to use it. Being...

Rolling back a transaction does not mean a query should not complete. A rollback does not implicitly mean a failure occured, it just says that for some reason someone decided...

Yes, that might be what was meant. Not very clear though..

No problem.

Mike, ok with that I agree. And in this case partitioning might actually be of help to the performance. It will take some work, like I said, but as you...

What do you mean by "Avoid code that assumes all metadata is publicly visible"? As of SQL Server 2005 Microsoft is now recommending usage of the (documented) catalog views and...

dcpeterson's excellent responses (as always) have pretty much said everything I would like to say about this, specifically that the easiest and in my view best solution would be to...

Note that you will need to contact PSS to obtain them as they are not generelly available. You may need to pay for access to them as well, but I...

Version 908 is Service Pack 3 with patch in KB 834290 and/or KB 834688.

You are probably using some kind of connection pooling, like the one in ADO or COM+, which is keeping the connections open (but sleeping). Make sure that the connection pool...

The collation that you are using probably does not support the Euro sign. However, are you sure that it is not just the client you are using that does not...

Enabling snapshot isolation and partitioning tables is something that does not require upgrading (e.g. altering, as I understand the context to mean) databases or app code?? Those both require extensive...

Steve, you just continue to surprise us all.

Personally, there are nothing more than some lights inside, and that goes for more or...

There is a great new feature called DDL triggers. You can easily create a DDL trigger that disallows any changes to schema, for instance procs.

Like I said, the only thing that is under source control are files. You cannot pull a stored procedure from source control. If you have a script that creates that...