Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-07-01 : 09:13:42
|
| Using sql, how do I get the value for the ownership chaining.I think I can get this using serverproperty ?Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-07-01 : 10:36:13
|
| You can retrieve the value set for "cross db ownership chaining" via sp_configure. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-07-01 : 10:44:52
|
| sp_config returns many records.Not sure which record I need?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 20:55:34
|
| Did Haywood mention 'cross db ownership chaining'? |
|
|
|
|
|
|
ownership chaining