Kill the vendor and restore from backup.


Christopher Bellizzi
SQL DBA/Programmer
240 Falls Street
Seneca Falls, NY 13148
Phone: (315) 568-7886
Email: Christopher.[Email address protected]

-----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


************************************
This e-mail and any files transmitted with it are proprietary and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Industries, Inc. The recipient should check this e-mail and any attachments for the presence of viruses. ITT Industries accepts no liability for any damage caused by any virus transmitted by this e-mail.
************************************


MS Sql Server LazyDBA home page