Welcome to Sign in | Help

Re: Creeare/atasare baza de date

  •  03-12-2008, 3:31 PM

    Re: Creeare/atasare baza de date

    Adaugand la ideea Dianei, se poate face o procedura stocata:

    CREATE PROCEDURE dbo.usp_ManageDB @DBName NVARCHAR(128)
    AS
    BEGIN
    DECLARE @sqlstatement NVARCHAR(150);
    SET @sqlstatement = 'DROP DATABASE '+@DBName;
    EXEC (@sqlstatement) AS LOGIN='LoginWithRights';
    END;
    GO


    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems