Search for a string in a procedure, trigger or fun

This is an extension of two previous scripts, this one will produce a list of ojects that contain the first parameter and not the second. The function works as a table so if the user wants to list only functions, query as: select * from fn_sys_searchobject('text1','text2') where object_type = 'function'

Unearth the New Data Mining Features of Analysis Services 2005

An article from Microsoft Journal looking at the new Mining features of SQL Server 2005. If you're interested in Analysis Services, this ias a good look (from a high level) at the next version.

Find Objects

Find Database Schema and Objects Changes

This procedure will execute, taking two parameters, (the 2 db names, and will then list out the major object and schema changes for you. It is pretty sraight forward and suggestions are appreciated. It's a good utility for a DBA to track changes after upgrades, etc.. Each portion is easily convertable to a stand alone […]

FormatDate - Mimics the VB Format routine for date

I don't remember where I found this little gem, but as a VB Developer it has simplified retrieving  dates on many projects. Simply pass the function a datetime value and the format that you want in VB style syntax and the date is properly returned. I have modified it slightly from the original author (who […]

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.