Allowing users to truncate log file

I would like to allow a particular user to truncate a log file in a
stored procedure that the user runs every day. At this moment the only
personnel that can truncate the log file are personnel with sysadmin
rights. Is there any way to do this in sql server 2005 without
granting this user sysadmin rights (something we REALLY don't want to
do)? Thanks for all your help in advance.

Dave C.

.

Relevant Pages

  • Re: truncate log file for replication database
    ... Looking for a SQL Server replication book? ... I encountered problem when I tried the truncate the log file the 2nd time ... We just start the transaction replication for the database few month ...
    (microsoft.public.sqlserver.replication)
  • Re: truncate log file for replication database
    ... I tried to stop the log reader from the distributor, ... Now I am unable to truncate the log file. ... We just start the transaction replication for the database few month back. ...
    (microsoft.public.sqlserver.replication)
  • Re: truncate log file for replication database
    ... We just start the transaction replication for the database few month back. ... Due to the heavy transaction on the database, we schedule daily log file ... Ensure the Log Reader Agent is running or use ... there must some standard way to truncate the log file for a live ...
    (microsoft.public.sqlserver.replication)
  • Re: Log Invalidated after truncate table
    ... > just enough information in the log file to rollback if the transaction ... TRUNCATE TABLE logs the extent deallocations, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Manually truncate a LOG file
    ... going to truncate the log why not set the recovery mode to SIMPLE? ... Andrew J. Kelly SQL MVP ... > How can I get rid of all of this space in the LOG file? ...
    (microsoft.public.sqlserver.server)