Search for specific text in all stored procedures

mrtrombone (Mark Easton) — Thu, 26 Apr 2007 03:08:05 GMT



declare @search varchar(50)

SET @search = 'searchterm'



SELECT    

     ROUTINE_NAME,

     ROUTINE_DEFINITION

FROM    

    INFORMATION_SCHEMA.ROUTINES

WHERE    

    ROUTINE_DEFINITION LIKE @search

ORDER BY

    ROUTINE_NAME

Connection To Active Directory From SQL Server

mrtrombone (Mark Easton) — Wed, 11 Apr 2007 22:16:00 GMT

SQL Code to link to active directory from within SQl Server.
ound by searching through a forum so can't claim I thought of it



//Follow this syntax:

EXEC master.dbo.sp_addlinkedserver @server = N'ADSI',

@srvproduct=N'Active Directory Services', @provider=N'ADsDSOObject',

@datasrc=N'Servername.domain.com'  --AKA the full computer name of the AD server



//Then execute the openquery like this:



select * from openquery

(

ADSI,'SELECT name

FROM ''LDAP://Servername.domain.com''

WHERE objectCategory = ''Person'' AND objectClass = ''user''

')

DZone Snippets: Mrtrombone's Code Snippets

Search for specific text in all stored procedures

Connection To Active Directory From SQL Server