Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
3 Cards in this Set
- Front
- Back
|
server option
|
controlled by sp_configure and management studio
0 = disabled for all dbs 1 = enabled for all dbs - not recommended unless all dbs are need to participate |
|
|
controlling DB chaining
|
sysadmin fixed server role to turn cross-database ownership chaining on or off.
Before turning off cross-database ownership chaining on a production server, fully test all applications, including third-party applications, to ensure that the changes do not affect application functionality. You can change the cross db ownership chaining option while the server is running if you specify RECONFIGURE with sp_configure. |
|
|
controlling DB chaining cont
|
If you have databases that require cross-database ownership chaining, the recommended practice is to turn off the cross db ownership chaining option for the instance using sp_configure; then turn on cross-database ownership chaining for individual databases that require it using the ALTER DATABASE statement.
|
