GAC changes from 4.0

GAC in 4.0:

C:\WINDOWS\Microsoft.NET\assembly

Gac in <=2.o

C:\WINDOWS\\assembly

Why ?

http://www.umbraworks.net/bl0g/rebuildall/2010/02/10/Global_Assembly_Cache_in_NET_4_0

 

How to retrieve the stored procedure code text?? (notes to self).

// Lists all the stored procedures in the DB

exec sp_stored_procedures

// Retrieves the Stored Procedure text to the output window.

EXEC sp_helptext N’spnamen’;