Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Creating a recycle bin for SQL Server 2005\2008

    Here is what it looks like in the script

    USE [AdventureWorks]

    GO

    /****** Object: StoredProcedure [zz_RecycleBin].[dbo_$_uspGetManagerEmployees_$_TOSHL35@dad_$_2009_06_07T23_55_38_100] Script Date: 06/08/2009 09:24:18 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    ALTER PROCEDURE [zz_RecycleBin].[dbo_$_uspGetManagerEmployees_$_TOSHL35@dad_$_2009_06_07T23_55_38_100]

    ...

  • RE: Creating a recycle bin for SQL Server 2005\2008

    Hi, I tried the scripts and it works great. However, the restored table or function name has zz_RecycleBin prefix and postfix with user name and time stamps. Needs...

Viewing 2 posts - 1 through 2 (of 2 total)