cross db ownership chaining,need help

Im going through configuration settings at server level in SQL-2K5.Can anybody provide me best explanation about the property cross db ownership chaining.I already gone thorouh msdn but its giving me confusion.

what are the limitations?

what about the security risk?

when should we enable this property?

more ▼

asked Mar 25, 2010 at 12:02 PM in Default

venkatreddy gravatar image

562 29 29 32

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Rob Farley has wrote a good article on this.. Pro's and Cons...


more ▼

answered Mar 25, 2010 at 01:01 PM

sp_lock gravatar image

9.3k 26 28 31

+1 (ha!) - Oh wow, someone's found something I did on sqlblogcasts. That takes me back... (and saves me writing a proper answer here). Funny... I jump online in the Australian morning, and see a bunch of questions, but almost all are answered. So I vote for questions and answers, and then there's almost no activity here for ages.
Mar 25, 2010 at 08:19 PM Rob Farley
@Rob - to be honest - it hasn't felt like there's been much activity for a while - the whole net seems a bit 'sleepy' this week
Mar 25, 2010 at 08:29 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 25, 2010 at 12:02 PM

Seen: 1509 times

Last Updated: Mar 25, 2010 at 12:02 PM