Determine if BACKUP COMPRESSION is available

This script will determine the SQL Server version and edition in order to find out if BACKUP COMPRESSION is available.

SQL Server 2008 Backup

How to configure and Use Database Backup Compression in SQL Server 2008

SQL Server 2008 introduces the Database Backup Compression feature. This article describes how to take advantage of this new feature

RE: Question of the Day for 23 Jul 2004

I guess the reason for not using select @@version (which I agree is far easier to type ) is that @@version requires further interpretation to establish the SP level (namely you have to look up the help topic that lists SP levels and their associated versions!)

RE: How Do You Pass input parameters to a Stored Procedure Using an ASP Input Screen?

I don't have time right now to look up the actual syntax but what you need to do is use the "Parameters" collection and add it to the command object.

RE: Repl - Column Filtering confusion

If you are only filtering the columns in the publication, then you shouldn't have any problems. You must be doing something wrong if the fileds gtes shifted. Everytime you made changes to the publication, you better drop and re create the publication, to avoid problems. "DROP the existing table & recreate it" will apply each […]

RE: query analyzer - "show execution plan"

Hi Cneuhold Thanks

RE: SQL Server 2000 Service Pack 3a

I think it is because the changes are so minor ie 1 install problem 1 MDAC memory leak 1 new feature on the Network Library (ie disable listening) Most people use the network library, hence other than the memory leak there is no advantage.