Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: Ddl; Dml; Dcl; ???

    If DDL is

    CRAETE TABLE myTable99...

    And DML is
    INSERT INTO TABLE....

    AND DCL is

    GRANT....

    Then what is this? Just T-SQL?

    Code:
    /****** Object:  LinkedServer [<servername>\<instance>]    Script Date: 08/03/2009 10:54:40 ******/
    EXEC master.dbo.sp_addlinkedserver @server = N'<servername>\<instance>', @srvproduct=N'SQL Server'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'collation compatible', @optvalue=N'false'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'data access', @optvalue=N'true'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'dist', @optvalue=N'false'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'pub', @optvalue=N'false'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'rpc', @optvalue=N'true'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'rpc out', @optvalue=N'true'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'sub', @optvalue=N'false'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'connect timeout', @optvalue=N'0'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'collation name', @optvalue=null
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'lazy schema validation', @optvalue=N'false'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'query timeout', @optvalue=N'0'
    GO
    EXEC master.dbo.sp_serveroption @server=N'<servername>\<instance>', @optname=N'use remote collation', @optvalue=N'true'
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    SCL, server control language

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •