Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Error writing to DB

I am running the same codebase on two different sites.  When writing a record to the DB on one I am getting the following error:

Microsoft OLE DB Provider for SQL Server error '80040e14'
The request for procedure 'user_audit' failed because 'user_audit' is a table object.


I am attempting to write a record to a table called user_audit - there are no stored procedures or anything with the same name.

Same exact code works on another site - hosted on same server.  Is there anything IIS related that may cause this to error?  I am not seeing anything different between the two instances, but may be missing something.
0
ccleebelt
Asked:
ccleebelt
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
What is the relevant SQL/ASP code?
0
 
sarabandeCommented:
I found the following regarding your error in the ms article http://support.microsoft.com/kb/173335 which is about a different problem:

The following scenario illustrates the problem:

 If User A (USERA) owns Table A (TABLEA) and runs EXEC USERA.TABLEA, the error message returned is:

The request for procedure 'USERA.TABLEA' failed because 'USERA.TABLEA' is a table object.

if that also applies to your issue, it would mean that the table was accessed by a user that is not the owner of the table.

Sara
0
 
Scott PletcherSenior DBACommented:
It means your code attempted to "EXEC" a table name, which is not logical and of course not allowed.

You can produce a very similar error message in any db:

EXEC sys.tables
0
 
ccleebeltAuthor Commented:
Ha..Turns out the problem was that D: was full,,,doh.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now