Did you check your permissions to see what has changed?
I've seen no reports of such a thing happening elsewhere as a result of
applying SP3 (and it's not my personal experience either - we have 8 SQL
Server 2000 instances here). But we're running Integrated Authentication on
all of them, so I can't speak about instances that are using SQL Server +
Integrated Authentication.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Simon Harrison" <simon@t...>
Subject: [sql_language] SQL SP3 and Permissions
: We applied the SQL SP3 earlier this week and now seem to be getting a
number
: of permission related issues.
:
: An example error from a piece of code that worked historically is - Select
: Permission denied on object xxx, database xxx owner xxx
:
: Has anyone else experienced a similar issues and if so what is their
: resolution.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~