How to change Message column from nvarchar(500) to nvarchar(2048) and the implications of that

[GoogleCodeExporter]

What steps will reproduce the problem?

n/a

What is the expected output? What do you see instead?

n/a

What version of the product are you using? On what operating system?

Elmah.dll 
Version 1.0.10617.936

Please provide any additional information below.

How should one change the Message column to nvarchar(2048)?

I think it is as simple as...
...deleting all rows from the Elmah_Error table...
...changing the column datatype...
...change the procedure ELMAH_LogError...
...done...

...and I tried that and it seems to work-- but, are there other 
implications???

...will it truncate internally based on the pre-change compile???

(Why change that? Well, we want to store other information, more than just 
500 chars, so we need a bigger column.)

Original issue reported on code.google.com by mkamo...@gmail.com on 29 Apr 2009 at 8:39

[GoogleCodeExporter]

I think this has more a nature of a question so it would be more appropriate to 
post
it to the general discussion group (http://groups.google.com/group/elmah) where 
it
can be discussed rather than being reported as an issue here.

Original comment by azizatif on 30 Apr 2009 at 9:46

• Changed state: Invalid
• Added labels: Component-Persistence