Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server 2000: Warning 8153 - Consistent?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts
Posted - 2005-10-28 : 08:13:35
John writes "I get the above warning returned to me via PowerBuilder SQLCA transaction object when I run a particular process. I understand it is a warning rather than an error (it doesn't update @@error), and so I can't detect it within the stored procedure code. I have taken steps to prevent it (I think) by ensuring that all amount columns in my temporary tables default to zero rather than null. However, what bothers me is the fact the warning may not be returned by SQL Server EVERY TIME I run the process for exactly the same parameters, it's not consistent. This suggests I can't be absolutely SURE I've cured it with my fixes. Is this a recognised feature of SQL Server, or must I look at my application?"

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts
Posted - 2005-10-28 : 08:25:30
It is consistent... and your params are constant.... but your data is not constant...
so sometimes you have data that generates the warning... and sometimes not

you know which query is causing it? if you post it here... we might be able to tell you wear the warning is coming from



Corey

Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site