Access violation with DBCC UNPINTABLE

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
Contact Product Support...
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
http://blogs.msdn.com/sqlserverstorageengine/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
>
>
|||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/sqlserverstorageengine/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...
>

Access to several SQL Servers implementing trusted connection

Being an IT consultant, I have to visit a number of customers having applications running on SQL Servers that implement trusted connection security model. In addition, all of these companies have their own DOMAIN settings, and security implementation.

How can I access to databases without changing the DOMAIN settings of MY notebook? I do not want them to switch to SQL security model, and I do not want to create any security hole in those companies.

What shall I want from the system administrator so that I can login into their domain without changing my domain settings?

Thanks,

EIO.

Hi,

you can store user network crednetials for your account on the notebook which will be used if connecting to a remote server.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

May I ask: How?

I understand that:

1. I have to ask all the administrators in those separate companies to create a user account for me, in their local domains, that has access to the SQL Server databases. That is easy.

2. I have to register those separate domain accounts in my notebook (how?)

3. After I connect to the company network and login to my notebook with my own username, those registrations will make me be acquainted with the company network.

Is this correct? And how can I complete Step 2?

Thanks in advance,

EIO.

|||

Yes you can ask those companies to create a standard account with your name and you can access the SQL Server using Enterprise manager by regsitering those instances. I have done this previously without any problem, where the account name (username) should match for authentication.

On Step2 even though it says cannot connect to server you can still register on your EM lists.

access rights to the database list

Hello,
I have several customers on the same sql server machine, they all will
connect using the entreprise manager with individual accounts via the
network.
I'm looking for a way to block the listing of the database names. So
each customer could not see the names of all the databases.
Does anyone have an idea to do this ?
thank youThis is not possible unfortunately.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"nagrom" <nagroland@.yahoo.com> wrote in message
news:3f1e9dab.199765337@.news.mc2.net...
Hello,
I have several customers on the same sql server machine, they all will
connect using the entreprise manager with individual accounts via the
network.
I'm looking for a way to block the listing of the database names. So
each customer could not see the names of all the databases.
Does anyone have an idea to do this ?
thank you