User Profile

Collapse

Profile Sidebar

Collapse
Krishna Ladwa
Krishna Ladwa
Last Activity: Aug 30 '07, 01:14 PM
Joined: Aug 28 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Krishna Ladwa
    replied to Locking
    I'm not sure what do you mean by locking......

    Anyways the first choice look good.
    For ex:
    Insert into tbl_test1
    SELECT col_Test2
    FROM tbl_test2 (nolock)
    WHERE NOT EXISTS
    (SELECT Col_test1
    FROM tbl_test1 (nolock)
    WHERE tbl_test1.Col_t est1 = tbl_test2.Col_t est2)


    Krishna :)
    See more | Go to post

    Leave a comment:


  • Schema Change of the table which is under replication

    How do I change schema of the table which is under replication to the reporting box without effecting or doing any changes to the publication or the subscription. I know there is built in SP sp_repladdcolum n & sp_repldropcolu mn to add new or drop columns. But I want to alter the datatype of some of the columns. I have 2 fields with Varchar(20) which I want to convert to varchar(40) and 1 column from text to varchar(255).

    Can anybody...
    See more | Go to post

  • No Notifications appears when converting text column to varchar column

    In Sql Server 2000 Version, I found that no Notification message box appears when converting text column to varchar but the data gets truncated to the given size for the varchar. Whereas it appears when you convert the varchar column to text column.

    Do this through Enterprise Manager Console

    Create a New table with a column as varchar datatype from Enterprise Manager  table created  Open the table and...
    See more | Go to post
No activity results to display
Show More
Working...