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 2000 Forums
 SQL Server Administration (2000)
 Automating truncatiion of Log

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-28 : 23:49:04
Kaushik writes "I was issuing this command.....

Use Master
Exec sp_dboption 'abc','truncate.log on chkpt.','True'


:- 'abc' is the name of the database

It's giving an error like this :-

Server: Msg 15011, Level 16, State 1, Procedure sp_dboption, Line 153
Database option 'trunc.log on chkpt.' does not exist.

Please advise


Kaushik Majumder"
   

- Advertisement -