Are you able to identify which SQL Statement is failing?
Does you new Login/User have the db_owner access or some columns that he
cannot access?
-----Original Message-----
From: Chappell
[mailto:mssqldba-ezmlmshield-x51420747.[Email address protected]
Sent: Tuesday, February 28, 2006 12:25 PM
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
The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.
MS Sql Server LazyDBA home page