backup procedure

From: A. Tolga KILINĒ (kilinc@tis.havelsan.com.tr)
Date: 09/11/02 

From: "A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr>
Date: Wed, 11 Sep 2002 11:21:34 +0300

Hi,
I want to write a stored procedure that does only archieving (I think backup
is same for SQL) to a media and then automatically delete the archieved
table.
I want to give the execution right of this procedure to the user and he can
not delete the table on his own. He will only execute the procedure and the
procedure will then automatically clean the table.
Is this scenario possible? If yes, then how can I write such a procedure (or
find)?
Is such an authorization possible in SQL?

Thanks,
Tolga

Relevant Pages

  • Re: Performance problem on initial call of stored procedure
    ... It's the behaviour like SQL works. ... creates or validates access plans. ... For dynamic embedded SQL no access plan is stored in the program object ... After the first execution the data path will be closed again. ...
    (comp.sys.ibm.as400.misc)
  • Re: JDBC and Stored procedure performance problems
    ... After the SQL statement is executed. ... The second execution may be faster, but the access plan and the access ... After the second execution the data path stays open, ... Further the wait time may depend on the query engine that is used. ...
    (comp.sys.ibm.as400.misc)
  • Re: Poor performance after upgrading to sql server 2005
    ... I've included the SQL 2005 execution plan but I do not know ... <RunTimeInformation> ... <DefinedValues> ...
    (microsoft.public.sqlserver.setup)
  • "Parameter Sniffing" and Inner Join Questions
    ... What version of SQL Server are you running..? ... >We looked at estimated execution plan but saw nothing ... > TableA a INNER JOIN TableB b on a.MyKey = b.MyKey ...
    (microsoft.public.sqlserver.programming)
  • Re: Query performance
    ... ADO.NET or SQL Management Studio. ... query takes a lot longer to execute. ... I can only examine the execution plan in SQL Management Studio, ...
    (microsoft.public.sqlserver.clients)