|
Home > Archive > MS SQL Server > November 2006 > Access violation with DBCC UNPINTABLE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Access violation with DBCC UNPINTABLE
|
|
| Kevin3NF 2006-11-27, 7:12 pm |
| Customer's server, so I can't explain or change the jobs...
At 3:00 am every day, a job runs that calls DBCC PINTABLE on three tables
At 5:00 PM, another job runs that calls DBCC UNPINTABLE on those same three
tables
Both report to complete successfully, but the UNPINTABLE job causes an
access violation and creates a mini-dump file.
SQL Server 2000, sp4 plus the AWE hotfix (.2040), Windows 2K3, sp1,
single-instance 2 node cluster
Nothing on MS Site about UNPINTABLE causing AVs....
All input appreciated :)
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
| |
| Paul S Randal [MS] 2006-11-27, 7:12 pm |
| Contact Product Support...
--
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
http://blogs.msdn.com/ sqlserversto...ne/default.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin3NF" <kevin@SPAMTRAP.3nf-inc.com> wrote in message
news:e7tDJ6iEHHA.4404@TK2MSFTNGP06.phx.gbl...
> Customer's server, so I can't explain or change the jobs...
>
> At 3:00 am every day, a job runs that calls DBCC PINTABLE on three tables
>
> At 5:00 PM, another job runs that calls DBCC UNPINTABLE on those same
> three tables
>
> Both report to complete successfully, but the UNPINTABLE job causes an
> access violation and creates a mini-dump file.
>
> SQL Server 2000, sp4 plus the AWE hotfix (.2040), Windows 2K3, sp1,
> single-instance 2 node cluster
>
> Nothing on MS Site about UNPINTABLE causing AVs....
>
> All input appreciated :)
>
>
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
>
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>
>
| |
| Kevin3NF 2006-11-29, 7:12 pm |
| Hi Paul,
I have asked my customer if he wants to pay for that call. Unless you can
hit //bugcheck for me and see if this a known but "not going to fix"
bug...:)
I've also asked him why on earth he is still using PINTABLE and UNPINTABLE.
I thought that went out of style with 6.5
Thanks for the response!
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Paul S Randal [MS]" <prandal@online.microsoft.com> wrote in message
news:OKsXrnnEHHA.3836@TK2MSFTNGP02.phx.gbl...
> Contact Product Support...
>
> --
> Paul Randal
> Lead Program Manager, Microsoft SQL Server Storage Engine
> http://blogs.msdn.com/ sqlserversto...ne/default.aspx
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Kevin3NF" <kevin@SPAMTRAP.3nf-inc.com> wrote in message
> news:e7tDJ6iEHHA.4404@TK2MSFTNGP06.phx.gbl...
>
>
|
|
|
|
|