Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Marks a table to be pinned. This means the SQL Server Database Engine does not flush the pages for the table from memory.
Important
This functionality was introduced for performance in SQL Server version 6.5. DBCC PINTABLE has highly unwanted side-effects. These include the potential to damage the buffer pool. DBCC PINTABLE is not required and has been removed to prevent additional problems. The syntax for this command still works but does not affect the server.
Result Sets
DBCC PINTABLE returns this result set (message):
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
See Also
Reference
Other Resources
Discontinued Database Engine Functionality in SQL Server 2005