It should not and I'm 99% sure it does not.

I don't have a reference to that, but you could easily find out comparing two installations.

You should use non-breaking spaces instead of soft spaces.

Try replacing char(20) with "& nbsp;"

Hope this helps

Gianluca

Edited: remove the space between the "&" and "nbsp;". I had to post it like...

I posted a corrected version of this code on my blog:

http://spaghettidba.com/2011/11/28/email-alert-dbcc-checkdb/

I hope you find it useful.

Koen Verbeeck (12/12/2011)

Brrrr... Oracle.

I spent 4 hours yesterday setting up an Oracle client...

As Dave pointed out, EAV database design sucks in many ways. Fix it before you go crazy.

A possible way to mitigate the EAV pain is pivoting the attributes as deep...

Google is your friend:

http://www.google.com/search?q=create+trace+sql+server

Cameron Diaz?

That's good advice.

Another option could be a CLR function, which seems to...

If you want to record all the statements run by users, you have only one option, which is setting up a trace.

Be aware that it will likely slow down the...

Your issue doesn't seem to be related to the INSERT, but to the procedure call itslef.

Try using named parameters:

EXEC procedure @param1 = value1, @param2 = value2...

I would use a splitter function like this one:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

You could split on " " and the split again on "=".

Sorry for the late reply. Glad you sorted it out.

I suspect that you didn't change @sql to datatype nvarchar.

You can use sp_executesql:

ALTER Proc [dbo].[spGetStatisticByCategoryBLTimeLineConsultant](@Type varchar(50),@BL varchar(255), @TimeLine int, @Consultant int)

AS

DECLARE @param datetime

SET @param =

CASE

WHEN @timeline = 0 THEN DATEADD(yy,-100,getdate())

...

Dev (12/5/2011)

By disabling the constraint, you are allowing to enter bad...