June 11, 2007 at 1:15 pm
The users use a utility to login to the database and remove some table entries and then the utility does some re-insertion into the same tables. The only stipulation is that the user be 'dbo'.
They are using windows 2003, SQL 2000 SP3 and get the following message when logging in with SA or any other user:
The following errors have occurred:
1. [frmDistribute.cmdLogin_Click Line 0][ERROR NO. -2147217900 - Could not find stored procedure 'sp_helpUser'.]
When running profiler get error message similar to: Msg 2812, Level 16,
Found something online that there may be a problem with Service Pack 4, but being they were on 3, didn't seem to apply. Upgraded the sql to SP 4 and now the 'SA' user can login but no other user.
The stored procedure is there and public has execute permission.
Any ideas greatly appreciated!
Thank you
June 12, 2007 at 5:30 am
> The stored procedure is there and public has execute permission.
The stored procedure is where?
There is a sp "sp_helpUser" in master database. And SQL Server will always try to execute that SP.
You users probably don't have proper rights in master database, so they cannot execute sp_helpUser.
Don't use "sp_" prefix in SP names.
_____________
Code for TallyGenerator
June 12, 2007 at 7:12 am
Hi there,
sp_helpUser?
Is your collation case sensitive?
David
If it ain't broke, don't fix it...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply