![]() PERSISTENT_LOG_BUFFER=ON ( DIRECTORY_NAME='' ) We recommend that you never set the TRUSTWORTHY option to ON for the master database. The value cannot be changed for the model and tempdb databases. TRUSTWORTHY is set to OFF whenever the database is attached.īy default, all system databases except the msdb database have TRUSTWORTHY set to OFF. When OFF, database modules in an impersonation context cannot access resources outside the database. When ON is specified, database modules (for example, views, user-defined functions, or stored procedures) that use an impersonation context can access resources outside the database. Syntaxįor more information about the syntax conventions, see Transact-SQL Syntax Conventions. It can also be used to create a database snapshot, or attach database files to create a database from the detached files of another database. In SQL Server, this statement creates a new database and the files used and their filegroups.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |