Grant Execute Permissions to All Procedures

This procedures grants execute permissions to all the stored procedures in a database to the role/user supplied as the parameter. the default is Execute_StoredProcedure. Execute this procedure local to the database you need to grant permissions.

Freeware: Tablesizer

How many times do you need to estimate space for a new application? Or estimate growth for an existing one? We've had a new contribution to the freeware section of the site. Tablesizer will allow you to guesstimate how much disk space you'll need. Take a peek if you need it, rate the product and give the author any feedback you have.

Books on line update

Books on line has been updated since the release of SQL2000.
If you check the documentation for the sp_addlogin stored procedure and example E says
SELECT CONVERT(VARBINARY(32), password) then you should update your installation.

Dark Horse Ventures releases CRM built on Microsoft SQL Server

Dark Horse CRM is an enterprise-class Customer Relationship Management application that allows companies to better develop and maintain customers. Visit www.darkhorsecrm.com for more information and to download the free version of Dark Horse CRM that runs on Java, Apache Tomcat, and MSSQL or PostgreSQL.

Reporting Services SP1 Released

A key service pack has now been released for Microsoft SQL Server Reporting Services. This one adds key enhancements and fixes many bugs.

South Park Unveils Linux Lounge For Guests

This is rich. A hotel sets up Internet access using Linux for guests. But they run SQL Server internally. So much for all the FUD coming from MS.

NTL Block SQLServer from their network - UK

A personal article refering to the latest change from NTL broadband stopping port 1433 globally on their network. Users are no longer able to develop Microsoft SQLSever systems using ODBC or Enterprise manager.

Webcast: Learn about SQL Server Yukon CLR for the DBA

Learn about SQL Server and the CLR. Join PASS and speaker Michael Otey, Senior Technical Editor for SQL Server Magazine and Windows & .NET Magazine and President of TECA, Inc., for the upcoming WebCast where you'll learn about the new .NET Common Language Runtime integration with SQL Server 2005. Registration Required.

New Product Discount: 15% on SQL Server Find

SQL Server Find, a product from Genius@Work, allows you to search your databases for objects based on a variety of criteria.

Advanced Data Generator

Upscene Productions is happy to announce a new version of
the database developer tool: "Advanced Data Generator" (version 1.1.0)

A fast test-data generator tool that comes with a library
of real-life data, presets and much more.

This new release consists of four versions:

- Pro: ADO and ODBC connectivity
- InterBase Edition
- Firebird Edition
- MySQL Edition

More info, pricing and a 30-day trial version on www.upscene.com