May 29, 2012 at 5:37 am
Hi,
I've been trying to assist with an installation of the above software on SQL Server 2008. We have all of the granted all of the permissions as sysadmin but I can still various errors such as:
--group chat error number range: 50000 and 70000-1
declare @x int
--common(501..)
select @x=count(*) from sys.messages where message_id=50100;
if(@x=1) exec sp_dropmessage 50100
exec sp_addmessage @msgnum=50200, @severity=16, @msgtext=N'parameter cannot be null:<%s>'
see attachment for rest of errors
Thanks
May 29, 2012 at 5:48 am
I'm sorry, but I don't see any errors. What I see is a code that checks if an error exists. If it does exist it drops the error and then recreates it. Did you actually see any error, or do you think that the code itself is an error?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 29, 2012 at 5:55 am
Hi,
I believe that the code that I have attached is an error? I'm not too familiar with this installation and only been trying to assist. We get the attached document once it has gone through the setup?
May 29, 2012 at 6:41 am
SQL Server has build in error messages, that are stored in sys.messages table. A DBA can add more messages to this table using the procedure sp_addmessage. If the DBA wants to remove a user defined message that was added he can do it with sp_dropmessage procedure. In the code that you posted, you check if an error with a specific error number exists. If it does, you remove it using sp_dropmessage procedure. Then you add a new message with the same error number.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 29, 2012 at 6:59 am
Ok thanks
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply