Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error when DBCC UNPINTABLE

Status
Not open for further replies.

vadimg

IS-IT--Management
Oct 25, 2001
152
US
SQL2K SP3
Windows2K Advanced Server

It seems like my server is allergic to the DBCC UNPINTABLE command. Anybody every ran into anything like this??? Happens to all tables, i used pubs..sysobjects as an example.


DECLARE @db_id int, @tbl_id int
USE pubs
SET @db_id = DB_ID('pubs')
SET @tbl_id = OBJECT_ID('pubs..sysobjects')
DBCC UNPINTABLE (@db_id, @tbl_id)
-----------------------------------------------
-----------------------------------------------
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 74 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top