SQL Server 2000 Report Pack for Microsoft Exchange

The SQL Server 2000 Report Pack for Microsoft Exchange is a set of 13 Microsoft SQL Server 2000 Reporting Services reports that work with a Microsoft Exchange sample reporting database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

Set all objects to dbo (sql2k)

Based on a script from this site, which sets ownership of all objects to dbo, this modification of the original author's code simply adds user defined functions (UDF's).  Script now includes tables, views, procs and functions.

Automating "Save DTS package"

MAK examines how to save all of the DTS packages from SQL Server to a structured storage file automatically.

Delete All

Delete all rows from all user tables. Create stored procedure and execute the procedure to get rid of all rows from all tables. This will not drop your tables. Be very careful what you wish for!

Tables With Identity Column

This script displays all tables in a database that has identity columns.

Optimized ADO.NET

This article contains guidelines compiled by examining the .NET implementations of shipping .NET applications and analyzing the common performance mistakes that we found. The guidelines discuss selecting .NET objects and methods, designing .NET applications, retrieving data, and updating data.

Lock Monitoring Script to summarize active locks

A simple script created to summarize locking by spid, by database, by type with more user friendly descriptions.  You can also run for a specific spid.  Hope it's useful. 

SQL Server 2000 Report Pack for Microsoft CRM

The SQL Server 2000 Report Pack for Microsoft CRM is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with the Microsoft CRM 1.2 sample database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

Get Table Count without using COUNT

Returns the number of records within a table without having to perform COUNT.

Extending Microsoft SQL Server 2000 Reporting Services with Custom Cod

In this article, I will show you how to leverage the Reporting Services unique extensible architecture to supercharge your report capabilities. First, I will explain how embedded and custom code options work. Next, I will show you how you can leverage custom code to author an advanced report with sales forecasting features.