SQL Permission - Can not import objects

Sapphire123

Hi All,

I have a user thats trying to import two modified objects - Vendor Table and Vendor Card Form - to their SQL 4.0 DB. This user has SUPER role & using windows login - but, gets the following permission issue/error when trying to import fob file:

"The following error message occured while accessing the Vendor Table.
1088."42000"[Micorsoft][ODBC SQL Server Driver][SQL Server] Cannot find the object "Personnel Connection, Inc_$Vendor" because it does not exist or you do not have permission.

SQL: Alter table "database.dbo" Personnel Connection Inc_$Vendor DROP CONTRAINT "Personnel Connection, Inc_$Vendor0"

Unfortunately, I dont know much about SQL... please let me know how do I fix this issue?

Thanks in advance!

garak

he must have special permission on the server.

for example db_owner (if he is the user which often imports objects) or sysadmin

jwilder

I am pretty sure this is becasue statisitcs exist on the vendor table for a field you are dropping. In SQL Management Studio go to the table, statistics and see what is listed there. You only need statisitcs on your index's. One of those statistics in there is causing you the problem.

I just upgrade to 5.0 and I had to drop statistics on the entire database to do the upgrade. When I was done I re-created statistics for all of the index's.

Anyway, I had a similar error that you referenced in your post.

kriki

[Topic moved from Navision forum to SQL General forum]