Welcome to Sign in | Help

Re: Conversie backup sql 2005-la sql 2000

  •  01-15-2010, 3:29 PM

    Re: Conversie backup sql 2005-la sql 2000

    Multumesc pt raspuns.

    M-am uitat acu si nu am nici macar sp1.
    Primesc erori pe sql 2000 de ex la comenzile de creare loginuri :


    IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'CMAS')
    CREATE USER [CMAS] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[CMAS]
    GO
    IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'johnny')
    CREATE USER [johnny] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]
    GO
    IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'robert')
    CREATE USER [robert] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[robert]
    GO
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    Secolul XXI ori va fi religios ori nu va fi deloc
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems