M
Martyn Reid
Guest
Hi all, I'm trying to run a statistics update via an ODBC linked server in SQL Server Management Studio like so: SELECT * FROM OPENQUERY (openedge, ' UPDATE TABLE STATISTICS AND ALL COLUMN STATISTICS FOR pub."customer" ' ) But I'm getting the following exception back from the ODBC drivers: Cannot process the object " UPDATE TABLE STATISTICS AND ALL COLUMN STATISTICS FOR pub."customer" ". The OLE DB provider "MSDASQL" for linked server "openedge" indicates that either the object has no columns or the current user does not have permissions on that object. I'm not aware of any permissions I need to set and the table name is definitely correct. (I can run a select * from the same table and I get results). I've searched google and can't find anyone else reporting the same problem. Does anyone have any ideas what is going on?
Continue reading...
Continue reading...