<div>
okay .. just narrowed it down .. the two stored procedures I am attempting to execute truncate the table before inserting records ..<br />
<br />
So evidently, the account must have the ability to truncate the tables.
</div>


okay .. just narrowed it down .. the two stored procedures I am attempting to execute truncate the table before inserting records ..

So evidently, the account must have the ability to truncate the tables.

<div>
apologize for the delay .. it was a few weeks before I was able to get back to the client. &nbsp; Appreciate the input .. this takes care of the problem.
</div>


apologize for the delay .. it was a few weeks before I was able to get back to the client.   Appreciate the input .. this takes care of the problem.

<div>
<div class="content wysiwyg-content">
Good evening experts:<br />
<br />
I'm having some issues with what appears to be permission issues while attempting to insert records from a .NET application. &nbsp;The strange this with this issue is that it is limited to two specific tables, and only occurs when inserting records.<br />
<br />
Using the same user credentials, I have no issue with inserting data into many of the other tables utilized in the .net application.<br />
<br />
When attempting to execute the INSERT stored procedure, I receive the following exception:<br />
<br />
Cannot find the object 'tblVendor' because it does not exist or you do not have permissions.<br />
<br />
If I execute a SELECT query against tblVendor with the same credentials, I am able to retrieve all the records from this table.<br />
<br />
This situation applies to two tables in the database, and any help would be much appreciated.<br />
<br />
Using SQL SERVER 2008 R2
</div>
</div>


Good evening experts:

I'm having some issues with what appears to be permission issues while attempting to insert records from a .NET application.  The strange this with this issue is that it is limited to two specific tables, and only occurs when inserting records.

Using the same user credentials, I have no issue with inserting data into many of the other tables utilized in the .net application.

When attempting to execute the INSERT stored procedure, I receive the following exception:

Cannot find the object 'tblVendor' because it does not exist or you do not have permissions.

If I execute a SELECT query against tblVendor with the same credentials, I am able to retrieve all the records from this table.

This situation applies to two tables in the database, and any help would be much appreciated.

Using SQL SERVER 2008 R2

SQL Server 2008 - Permission Issue

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.