Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ram.marella
Starting Member
15 Posts |
 Posted - 2008-02-28 : 21:10:45
|
| Hello,We are migrating the SP from 2000 -> 2005, in my previous verriosn they are using WITH LOG option to store the error messges in to the Applicatin log and System log.When migrated to 2005 and I tried to run that i got error messgae like "Only System Administrator can specify WITH LOG option for RAISERROR command.".Is there any possbility that without granting admin access to the developers that we can run this stored proceedure.My DBAs dont want to provide the admin access to all developers to execute this SPs is there any work around for this problem.please help me out.suggest me if there any other ways to handle this situation.I hope i will be answered by some one.ThanksThanks-----------------Ram MCP |
|
|
|
|
|
Raise Error WITH LOG option problem.