I'd bet (given the limited info) that the login sproc for a user is
attempting to access the login info table correctly, using a 2 part
identifier and so with another owner of the table it will fail
completely, with the divide by zero error appearing as a behavior of
that sproc call when it, perhaps, tries to calculate how many logins the
user has this month.

The problem is, you'll have to update every single sproc to use the new
identifier prefix, or change it back to the way it was. Easily done
with a script out, global search and replace and script in, but holy
cow, that's one retarded vendor. They should not have changed the dbo,
IMO.

Mike Sofen

-----Original Message-----
From: Chappell
[mailto:mssqldba-ezmlmshield-x51420747.[Email address protected]
Sent: Tuesday, February 28, 2006 9:25 AM
To: LazyDBA Discussion
Subject: Divide by Zero error






My users are receiving a "divide by zero error" when they try to access
my
SQL database from the web. There is no other errors to accompany this
one
and no other descriptions. This just started happening when my
application
support person allowed the vendor to change the dbo on all of the
databases
to a user account/name (which solved on problem but started 12 others).
Any suggestions?

Have a great day!

Chappell Grant-Willis,
SQL DBA - Information Services
Sun Health Corporation
Phone: 623.876.3242
Email: chappell.grant-[Email address protected]


************************************************************************
*******
The information contained in this transmission may be legally privileged
and/or confidential information. Any dissemination, distribution or
copying
of this transmission by anyone other than the intended recipient is
strictly prohibited. If you receive this in error, please inform the
sender
immediately and remove any record of this message.
************************************************************************
*******
For more information about Sun Health, visit us at: www.sunhealth.org


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page