DBCC UNPINTABLE (Transact-SQL)
SQL Server 2005
Marks a table as unpinned. After a table is marked as unpinned, the table pages in the buffer cache can be flushed.
|This functionality was introduced for performance in Microsoft SQL Server version 6.5. DBCC UNPINTABLE has highly unwanted side-effects. These include the potential to damage the buffer pool. DBCC UNPINTABLE is not required and has been removed to prevent additional problems. The syntax for this command still works but does not affect the server.|
DBCC UNPINTABLE returns this result set (message):
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC PINTABLE (Transact-SQL)
Other ResourcesDiscontinued Database Engine Functionality in SQL Server 2005
Help and InformationGetting SQL Server 2005 Assistance