Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    115

    Unanswered: CREATE TABLE rights problems

    I cannot fix the rights depending on customers server...

    when i create a table dynamicly with ASP.NET for MS SQL 2000, should I use :

    CREATE TABLE [dbo] .[Component]

    or

    CREATE TABLE [Component]

    --------------------

    [id_Component] [int] IDENTITY (1, 1) NOT NULL ,

    or

    [id_Component] [int] IDENTITY (1, 1) COLLATE French_CI_AS NOT NULL ,

    --------------------

    shall I add COLLATE French_CI_AS to all columns ?



    thank you

  2. #2
    Join Date
    May 2002
    Posts
    299
    If you don't explicitly specify the collation, the system will use the database collation as the default.

    It's a best practice to be explicit for DDL/DML. So, [dbo] and [COLLATE] should be specified.
    --
    -oj
    http://www.rac4sql.net

  3. #3
    Join Date
    Jun 2005
    Posts
    115
    thank you !

Posting Permissions

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