Hi!
I've Sybase SQL Server 11.0 installed. At times, happens this when I run "sp_helprotect" stored procedure:
Arithmetic overflow during implicit conversion of INT value '377' to a TINYINT field .
Arithmetic overflow occurred.
Can somebody help me for this dude? Please. Thanks very much in advance.
Does anyone know what it means when i see somerecords returned that have their COLUMN valueas NULL?I investigated a little to see if they are somehowrelated to orphaned users but I don't believe theyare. What else would cause this column to be NULL?And it seems they are all MSP related. Maybe this isa Project Server bug?Here's one sample:Owner dboObject MSP_WEB_FN_SEC_GetAllProjectsResCanViewByViewIDGrantee MSProjectServerRoleGrantor dboProtectType GrantAction SelectColumn NULLThank you
View 1 Replies View RelatedWhy does sp_helprotect throw an error if there are no special security permissions for a specified @username? Why not simply return a blank resultset? This makes the procedure a hassle to use when trying to capture results into a table as part of another stored procedure (use it for auditing).
[Edited]The same problem occurs when I execute xp_logininfo to get the list of members for a group that has no members. Instead of just passing back some sort of status, the procedure blows up and keeps me from scripting the procedure.
Am I just missing something?
Brandon