Export (0) Print
Expand All


SQL Server 2000

The Microsoft® SQL Server™ ODBC driver uses the sp_table_privileges catalog stored procedure to satisfy table privilege data requests using SQLTablePrivileges.

SQLTablePrivileges can be executed on a static cursor. An attempt to execute SQLTablePrivileges on an updatable (keyset-driven or dynamic) returns SQL_SUCCESS_WITH_INFO indicating the cursor type has been changed.

The SQL Server ODBC driver supports reporting information for tables on linked servers by accepting a two-part name for the CatalogName parameter: Linked_Server_Name.Catalog_Name.

See Also


© 2015 Microsoft