Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unanswered: Inserting New Columns

    Hi!
    How to insert new colunm into a old Table by Sql Script?
    Thanks!

  2. #2
    Join Date
    Feb 2004
    Posts
    14
    ALTER TABLE tabletobeedited ADD newcolumn VARCHAR(20) NULL
    GO

  3. #3
    Join Date
    Feb 2004
    Posts
    9
    Thank-you for your answer!!!
    How to set up the replication in SQL Server from database1 in Server1 to database2 in Server2 by Sql Script?Please give me the Script! Thanks-you very much!

  4. #4
    Join Date
    Feb 2004
    Posts
    14
    Not sure about that one, far as I know you setup replication on your tables in enterprise manager. Not sure how to script it though.

  5. #5
    Join Date
    Feb 2004
    Posts
    9
    - I'm set up the the replication in Sql Server from database1 in server1 to database2 in server2, in Visual Basic.
    - Can I set up by stored procedures?not by the Vizard,how many method can i set up the replication in Sql Server from database1 in server1 to database2 in server2?
    Please give me a good method!!

  6. #6
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Originally posted by vi_heo

    How to set up the replication in SQL Server from database1 in Server1 to database2 in Server2 by Sql Script?Please give me the Script!
    hi,
    for scripting the replication check BOL under the topic scripting replication, it may be of some help.

    harsh.

  7. #7
    Join Date
    Feb 2004
    Posts
    9

    Red face Empty Log files and Data files

    Hi!
    I'm using replication with two database on SQL 2000,when begin, the log files size is 50mb and the data files size is 150mb. But now the log files size is 2Gb and the data files size is 4Gb. I would like to decrease the log files and the data files ??? How do i do this???
    (I using Truncate and shrink doesn't change )
    Thanks!!!

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd suggest sp_repladdcolumn.

    -PatP

Posting Permissions

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