<div>
i would check the permissions on the table(s) and make sure the user account being used in the app has access to it. <br />
<br />
if that doesn't resolve the issue, seeing some offending code may help.
</div>


i would check the permissions on the table(s) and make sure the user account being used in the app has access to it.

if that doesn't resolve the issue, seeing some offending code may help.

<div>
Well, here's the most bassackwards solution, but it worked. &nbsp;We had some legacy ASP code that was looking for datatype TEXT. Varchar(MAX) blew it &nbsp;up.<br />
<br />
We changed the column datatype back to TEXT and it worked. &nbsp;Welcome to 2002.<br />
<br />
Now, TEXT is supposed to be deprecated but apparently Azure SQL Database is supporting it now.<br />
<br />
Go figure.
</div>


Well, here's the most bassackwards solution, but it worked.  We had some legacy ASP code that was looking for datatype TEXT. Varchar(MAX) blew it  up.

We changed the column datatype back to TEXT and it worked.  Welcome to 2002.

Now, TEXT is supposed to be deprecated but apparently Azure SQL Database is supporting it now.

Go figure.

<div>
yeah, probably a better solution assuming that would work with ASCII vs. UNICODE. For now, this worked, so we wont touch it again until it blows up.
</div>


yeah, probably a better solution assuming that would work with ASCII vs. UNICODE. For now, this worked, so we wont touch it again until it blows up.

<div>
<div class="content wysiwyg-content">
We've got a few old customers that, believe it or not, still have old classic ASP sites. &nbsp; We recently began to migrate them from SQL 2012 to Azure SQL Database. &nbsp;After the database migration, we get the following errors on the sites:<br />
<br />
Server Native Client 11.0][SQL Server]The request for procedure '[tablename]' failed because '[tablename]' is a table object.<br />
<br />
I figure at this point there has to be a fix for this however I cannot seem to locate it.<br />
<br />
Anyone have the magic bullet?
</div>
</div>


We've got a few old customers that, believe it or not, still have old classic ASP sites.   We recently began to migrate them from SQL 2012 to Azure SQL Database.  After the database migration, we get the following errors on the sites:

Server Native Client 11.0][SQL Server]The request for procedure '[tablename]' failed because '[tablename]' is a table object.

I figure at this point there has to be a fix for this however I cannot seem to locate it.

Anyone have the magic bullet?

Request for Procedure failed, X is a table object

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.