RAISERROR dilema

Hello,

I am tring to use the RAISERROR command to log an error when it happens and pass a parameter into it. This is what I am looking for in a nutshell. I know this syntax is incorrect.

RAISEERROR('The following process has encountered an error' +space(1) + @.var, 16,1, @.with_log='TRUE')

Any help would be appreciated...

Thanks,

Dave

To make this work, you need to create your message before calling RAISERROR.

DECLARE @.ErrMessage varchar(250)

SET @.ErrMessage = ( 'The following process has encountered an error' + ' ' + @.var )

And then call RAISERROR using the @.ErrMessage, e.g.,

RAISEERROR( @.ErrMessage, 16, 1, @.with_log='TRUE' )

Of course, if @.Var is numeric,it will have to be cast as varchar to concatenate.

sql

quick question

I have a couple of really quick questions...
How many parameter are allowed for a stored procedure?
and I'm trying to figure out what security level witll set an @.@.error variable to 0.
and lastly, How many log files can be in a filegreoup?
ThanksHow many parameter are allowed for a stored procedure?
1024

and I'm trying to figure out what security level witll set an @.@.error variable to 0.
?? @.@.error return value is cleared before every statement and is a system function not a variable.

How many log files can be in a filegreoup?
0

QueueSizeMultiplier - Merge Agent Profile Parameter SQL 2005

I see a parameter in the "high volume server-to-server" merge agent profile
named QueueSizeMultiplier.
Can anyone tell me...
The purpose of this paramter
The possible values and their meaning.
Its seems to be undocumented. Default is null, maximum listed seems to be 5.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pat Clough" <Pat Clough@.discussions.microsoft.com> wrote in message
news:B4E5DBAB-9734-4AC2-BCA3-E85F512F22F0@.microsoft.com...
>I see a parameter in the "high volume server-to-server" merge agent profile
> named QueueSizeMultiplier.
> Can anyone tell me...
> The purpose of this paramter
> The possible values and their meaning.