October 5, 2004 at 9:40 am
Brian,
You are certainly right. Ownership Chaining is not a feature. It is a concept and as such it was present in 7.0 (I am not sure about 6.5 security) What I did mean by a new feature is as you say, a checkbox to turn it on or off and a recommendation keeping it off.
Yelena.
Regards,Yelena Varsha
October 5, 2004 at 9:41 am
Could you think of any server level or Query Analyzer level settings which would cause it to behave different on my side ? I am also curious to find out the value you have for uid in syscacheobjects for the three queries. BOL says that a value of -2 in uid indicates that the batch submitted does not depend on implicit name resolution and can be shared among different users.
October 5, 2004 at 11:34 am
Looking at syscacheobjects, I actually have three different entries. The first is the actual query as I submitted it, with uid = 1. The second is the parameterized query with uid = -2. The third is a parameterized query with uid = 1. As for QA and server side settings, mine are all default.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply