The author of the question never answered (as far as I could see) whether or not they wanted february of a specific year or every year's february instead.

The former's been...

I guess that's precisely why SSC and other SQL Server sites link to each other's articles 🙂 I've been learning most of my MDX (amazing how similar and then...

It's not legal syntax in sql 2000.... no solution apart from using set rowcount

If it's not your server then chances are you're not an administrator and won't have the rights to install the necessary bits to make it work 🙁 Sorry...

Are you...

I would suggest that you take a final log backup for the week, then do your maintenance work then start your backup cycle again with a full backup. I...

And obviously you'd use a check constraint on the table rather than something ugly like a trigger with a rollback inside it 🙂

What client side tools are you using? Usually you can just select the column like any other.

The transaction log backup consists of each transaction that you've performed against your database. If you have had many transactions between your full backup and your first log backup...

Essentially if you're lazy then you can use cascaded deletes 🙂

You may wish to consider adding a "deleted" flag to a record rather than actually deleting it anyway.

Cascading deletes let...

I'd wager that most apps do run except for when they make strange modifications to system tables or have some odd naming conventions. Case in point - our software...

Nice code sergiy - this would generate a better exec plan. Perhaps the case statements should say else 0 rather then else NULL only because you'll get annoying warnings...

It's always fun to watch what 3rd party software does in SQL Profiler 🙂 I particularly like some software that clearly uses string concatenation to build SQL statements in...

The article should really be removed or altered - it makes the site look bad 🙁

I agree with Jeff - set-based is certainly best. The idea of using service broker in the background is pretty good. Often the rbar stuff, if absolutely necessary,...

The BIG problem I have with 90 compatibility level is

1. I still code and design using SQL 2000.

2. The EM database diagram designer in SQL 2000 generates lovely code,...