Nice article. Certainly something that is forgotten all too often.

Two things to bare in mind :

1. PwdEncrypt is not a very strong encryption method. So to store very sensitive passwords,...

Obviously, there is no record inserted. But hey, then again, you could get an error because the dboHistoryTable does not exist... Or maybe the dbHistory user is not present, or...

Don't think this is included. You could the (undocumented) SP_msForEachTable stored procedure to automatically loop through all the tables, getting the count and storing it in a temp table.

After that,...

There is no real difference. The DRIDefault object (in DMO) allows you to control the Default constraint you add to a column.

The difference with the Default property of the column...

Definitely go for the Audit table.

I cannot think of a solution to not build a list of fields.

I can imagine this is cumbersome, but have a look in the Scripts...

Ooooh, and to answer your question

Don't think it is possible to call a class directly (not from SQL2000 anyway). Yukon promises this, if...

It is not entirely clear to me what you are trying to achieve...

I would store the encrypted password in the database (unless you need it for something else, of course)....

This is possible, I think...

Try using the CHARINDEX function to get the position of a space. With that value and the SUBSTRING function, you can get a part of a...

You have two possibilities :

1. Use the CASE construct in the SUM statements. Using it, you can say to only add the quantity or sales if the date is in...

Don't think it is possible.

The only way I see is to use a table somewhere to store the values before calling the script.

In the script you can fetch the values...

To get the number of sales reports for each of the countries, by week, is not too difficult...

SELECT Country, DatePart(w, SalesReportDate) As Week, Count(SalesReport) As NumReports

FROM TableSalesReports

GROUP BY Country, Datepart(w,...

If you're looking for a unique identifier, you could go for a GUID column. That is Globally Unique, so across tables, databases and servers.

Obviously, it is not a 'sequence' number,...

It shouldn't be too difficult to use Pivot Tables inside a browser. You'll need the ActiveX installed on the client, and it probably only works properly using IE.

Obviously, you'll need some...

Have you checked the use of CHECKSUM_AGG?

With it, you can calculate a checksum over a complete table or a column. Don't know if it is possible to calculate one over...