Hi, here a further alternative:

select

object_name(object_id) as Name

from

sys.sql_modules

where

definition like '%your_string_comes_here%'

order by

Name

In combination with sp_foreachdb this one can also do...

Not really more comprehensive 🙂

You can try to use WMI for this - here some possible hints:

http://msdn.microsoft.com/en-us/library/ms180606(SQL.90).aspx

http://www.simple-talk.com/sql/database-administration/why-this-sql-server-dba-is-learning-powershell/

http://msmvps.com/blogs/athif/archive/2005/11/20/76035.aspx

Hope this helps or gives you some ideas...

Regards, Richard.

Hi Steve, a bit off topic, but may I add an update to the Patchday last week - the situation (at least here in Europe) looks unfortunately a bit different...

Hi, thanx for the contribution, this sounds good...

There are still some problems though, try following:

create table dbo.Something(

ID int identity(1,1) not null,

NVarCharValue nvarchar(50) null,

DateTimeValue datetime null

)

go

insert into dbo.Something (NVarCharValue, DateTimeValue) values...

Thanx for your hint, Nigel,

the Tally Table method was new to me, but I like this - sleek and fast!

Performance differences are varying - I get slightly different values with...

This is what fascinates me whenever working with SQL - there are always dozens of alternatives 😉

I analyzed recently some ways to parse a string to a table for performance...

A possible alternative is convert/cast with datetime styles (e.g. 112 for ISO in the form of yyyymmdd). This comes in often very handy for date calculations:

declare @MyDate datetime

set @MyDate =...