Script to list all triggers in Database

This is a script to list the code for ALL triggers in database

declare @trgName varchar(500)

DECLARE @trg_cursor CURSOR

set @trg_cursor=CURSOR FOR

SELECT name FROM sysobjects WHERE xtype='TR'

OPEN @trg_cursor

FETCH NEXT

FROM @trg_cursor INTO @trgName

WHILE @@FETCH_STATUS = 0

BEGIN



exec sp_helptext @trgName

FETCH NEXT

FROM @trg_cursor INTO @trgName



END

CLOSE @trg_cursor

DEALLOCATE @trg_cursor

GO


Enjoy :)

let's Bonus

Acabei de me registar no let's bonus.. tem descontos muito bons:)
Faz o teu registo atraves deste link e recebes 6€ para descontar em comprar superiores a 12€ (será descontado na primeira compra que fizerem)
Registo let's Bonus

Generate Constructor from properties Vs2010

Hi i found a very cool and small add-in for Visual Studio 2010 that helps to generate constructors from field/properties and constructors of the superclass.

link: http://cometaddin.codeplex.com/

Experts.net Toolbar

Criamos uma toolbar para nossos visitantes :)
Assim podem estar mais directamente em contacto com o site:)
Toolbar é livre de spywares