stored procedure - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

stored procedure

Author

Topic

sdumarali
Starting Member

7 Posts

Posted - 2007-08-31 : 06:12:16

Hi

Can any one explain this in detail
i'll thanful to those.

bye

exec sp_dboption N'Library', N'autoclose', N'false'
GO

exec sp_dboption N'Library', N'bulkcopy', N'false'
GO

exec sp_dboption N'Library', N'trunc. log', N'false'
GO

exec sp_dboption N'Library', N'torn page detection', N'true'
GO

exec sp_dboption N'Library', N'read only', N'false'
GO

exec sp_dboption N'Library', N'dbo use', N'false'
GO

exec sp_dboption N'Library', N'single', N'false'
GO

exec sp_dboption N'Library', N'autoshrink', N'false'
GO

exec sp_dboption N'Library', N'ANSI null default', N'false'
GO

exec sp_dboption N'Library', N'recursive triggers', N'false'
GO

exec sp_dboption N'Library', N'ANSI nulls', N'false'
GO

exec sp_dboption N'Library', N'concat null yields null', N'false'
GO

exec sp_dboption N'Library', N'cursor close on commit', N'false'
GO

exec sp_dboption N'Library', N'default to local cursor', N'false'
GO

exec sp_dboption N'Library', N'quoted identifier', N'false'
GO

exec sp_dboption N'Library', N'ANSI warnings', N'false'
GO

exec sp_dboption N'Library', N'auto create statistics', N'true'
GO

exec sp_dboption N'Library', N'auto update statistics', N'true'
GO

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-31 : 07:12:33

Those are settings for how SQL Server should behave.
What did Books Online tell you?

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources