Re: archieving and deleting SQL 2000 table

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

From: "A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr>
Date: Fri, 25 Oct 2002 16:20:48 +0300

Hi,
I really find your site useful. I tried the stored procedure you give but
there are some problems with it. First, I created a similar database for
copying but I have such an error: "Error 8101: An explicit value for the
identity column in table 'Master.dbo.COPYTABLE' can only be specified when a
column list is used and IDENTITY_INSERT is ON" .
I set the IDENTITY_INSERT on but it did not worked.
How to solve this?
Secondly, can I get an email alert when this procedure runs or when someone
deletes the original table? how?
Regards,
Tolga

"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
news:e2LFZTCfCHA.2240@tkmsftngp10...
> For info on archiving, try this link:
> http://vyaskn.tripod.com/sql_archive_data.htm
>
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server FAQ, articles, code samples, interview questions and more @
> http://vyaskn.tripod.com/
>
>
> "A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr> wrote in message
> news:Otut8Y$eCHA.2544@tkmsftngp11...
> > Hi,
> > there is a strict requirement from one of my customer that some SQL
tables
> > never deleted before they are archieved. First problem is how to achieve
> > archieving? Can I do backup instead??
> > I can set a user as backup operator, but then he can not delete the
table.
> > If I give rights to delete it, he can do it without backing it up!!
> > Please suggest a solution about the requirement.
> > Regards,
> > Tolga
> >
> >
>
>

Relevant Pages

  • Re: archieving and deleting SQL 2000 table
    ... Vyas, MVP (SQL Server) ... > there is a strict requirement from one of my customer that some SQL tables ... > I can set a user as backup operator, but then he can not delete the table. ...
    (microsoft.public.sqlserver.security)
  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Re: Adding date to parameter
    ... SqlClient provider which is specifically written for SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I made the assumption that the stored procedure went by the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with the Legacy ASP files and the Sql Server Express
    ... table, if another inserting occurs at the nearly exactly the same moment, ... SQL Server will pass it a default value. ... assume that you do have a connection that can reach SQL Server Express. ... unless your stored procedure has some thing that only works ...
    (microsoft.public.dotnet.framework.aspnet)