James, there is a code tag you can use when posting code to make it more readable...

natedogg_0923 (2/10/2011)

---

Hey hey hey

when i execute the function

Msg 537, Level 16, State 5, Procedure createInsertSP, Line 78

Invalid length parameter passed to the LEFT or SUBSTRING function.

Msg 537, Level 16,...

It'll only create stored procedures for tables that looks like this:

CREATE TABLE [tablename] (

identitycolumn INT IDENTITY(1,1)

...

)

It's only handling identity PKS and that's quite limiting for my taste. Maybe you should evolve it some more and it could be useful for more people.

Geoff A (11/15/2010)

---

Kristian Ask (11/15/2010)

---

hugo-939487 (11/15/2010)

---

Another variaton, using the MONTH function:

SELECT [Month] = DATENAME(mm,SomeDateTime),

Amount = SUM(SomeAmount)

FROM #MyHead

...

hugo-939487 (11/15/2010)

---

Another variaton, using the MONTH function:

SELECT [Month] = DATENAME(mm,SomeDateTime),

Amount = SUM(SomeAmount)

FROM #MyHead

WHERE SomeDateTime >=...

scoia (10/6/2010)

---

<<Since 2006 Honda has made all the engines in all 33 cars of every Indy race, so no matter who wins, Honda wins.>>

Just curious, but for the sake of...

I kind of agree... it won't fly.

chrisn-585491 (5/17/2010)

---

Encryption is worth it for the reasons folks have stated. The largest percentage of folks that would take advantage of your work or mess with system integrity are detered...

Only one thing wrong here... decrypting SPs or views is not very complicated and would be a scriptable task to perform on any database (I wouldn't recommend decrypting a live...

If it was really encrypted it would be fine to keep it but as it isn't I can live without it.

Installing it at a customer site won't prevent them from...

Here is a revised script...

CREATE PROCEDURE [dbo].[sp_who3]

@SPID INT = NULL,

@DBName ...

Roman Vinnik (4/27/2010)

---

The indentation uses some weird characters. In my case I pasted it into an advanced text editor and they came up with question marks. I just replaced the...