It is...

bphipps-931675 (5/6/2010)

---

That's certainly one way you can get a script started if you didn't save it from the start. We have a stored procedure template (that we access via...

bphipps-931675 (5/6/2010)

---

But SSMS inherently gives you a save option. All you have to do is save them like any other file to your hard drive. I really don't...

bphipps-931675 (5/6/2010)

---

This just seems silly overall. Why wouldn't you just create a project in SSMS and then save your scripts into the solution/project. The solution can then be...

Phil Factor (5/6/2010)

---

Right on the nail. If you can...

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

---

I personally haven't found a great deal of info on how to script objects using SMO which is why I think people end up doing slightly scary things like...

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...