mike.renwick-894639 (5/6/2010)

---

I also had similar issues with sp_helptext and eventually found a way of scripting objects using

Microsoft.SqlServer.Management.Smo.Scripter in Powershell.. this has the advantage that it handles all types of objects...

jcaradocdavies (5/6/2010)

---

Just a small concern...

As far as experience and memory serves, sp_helptext is not a reliable source for recreating SQL server objects. SQL management objects are the preferred source.

Changes to...

irozenberg (5/6/2010)

---

Just a small suggestion - please consider EXTENDED properties for DB objects (including Stored Procedures), by using them in a key-value fashion you could avoid a lot of text...

I've included code to include the FillFactor:

--USE myDB

GO

IF NOT EXISTS(SELECT 1

...

CirquedeSQLeil (3/17/2010)

---

Please provide specifics if you are going to...

This is probably one of the most unreadable stories and unreusable pieces of code I have ever seen in an article.

Whoever said that many-to-many relationships don't exist in the real word is wrong. The truth is that the place where many-to-many relationships don't exist is in database designs. If they...

Tim,

Your article is essentially completely correct. I like your honest style, admitting how you used to design database tables before you found out about adding this extra type of table....

Karen Lopez - InfoAdvisors (3/2/2010)

---

You don't have to use a primary key to enforce uniqueness. You can use an alternate key as well. So you could have a...

Gary Varga (3/2/2010)

---

Surely, depending on ones perspective the many-to-many relationship is defined in a link table that decouples entities at either...

It's not decoupling but designing for resolving many-to-many releationships.

Are you running the script that creates the stored procedure which when run will create the script?

If...

I've updated the code so that it will include both FileGroups and any INCLUDE columns.

Also made it a stored procedure with the option to include existance test and DROP before...

sknox (10/27/2009)

---

jacroberts (10/27/2009)

---

I can see that you can do this using SQL server but I fail to see any benefit to using SQL Server rather than wirting some code using...

I can see that you can do this using SQL server but I fail to see any benefit to using SQL Server rather than writing some code using a normal...