CRUD SP generator for SQL Server 2008 (R2)

Question

Hi,

I am using SQL Server 2008 R2. Is there a free script/utility which can make CRUD SPs for all of my database tables? I use to have one but lost the script.

Thanks

Answer 1

You could always use something like MyGeneration. It's free and can do a lot more than just crud operations. If it doesn't have the templates you need you could always create them pretty easily.

Answer 2

I use SSMS Tools Pack, a CRUD generator is only one of the many features it has that I use on a regular basis. You can also customize the templates it uses to create the CRUD SPs.