03-02-2012 01:31 PM
connect to sqlsvr(dsn=xxx user=yyy pwd='zzz');
execute (truncate table base.monthlydata) by sqlsvr;
disconnect from sqlsvr;
error in log
ERROR: CLI execute error: [DataDirect][ODBC SQL Server Driver][SQL Server]Cannot find the object "monthlydata" because it does not
exist or you do not have permissions.
when I check the sqlsvr side the monthlydata table exists.
03-06-2012 11:10 AM
yeah..u will be having access to delete or drop a table from SAS side, but when u r trying to connect to external data base (sqlserver). you might not be having access to truncate a table or delete a table. only DBA's or database developers will be having access to truncate or delete the table.