Results 1 to 3 of 3

Thread: Partition view

  1. #1
    Join Date
    Aug 2003
    Location
    Germany
    Posts
    20

    Question Unanswered: Partition view

    I have 2 servers with one being the main server. On the main server i set up some views which points to the other server.
    When i try to update a value on a view everything goes well, but if
    i have a join in my update statement like:

    update t1 set somecolumn=@value
    from t2 where ....
    (t1 and t2 are both partition views)

    it fails (the server goes into endless loop ....).

    t1 looks like this:
    pk1 : pk smallint
    pk2 : pk tinyint
    pk3 : pk int
    pk4 : pk int
    pk5 : pk tinyint
    ...
    and has a check constrain: ([pk1] = 1)

    t2 looks like this:
    pk1 : pk smallint
    pk2 : pk tinyint
    pk3 : pk int
    pk4 : pk int
    ...
    and has a check constrain : ([pk1] = 1)

    right now i have on the second server for each view 2 tables.

    the views on main server look like this:

    CREATE VIEW [t1] AS
    SELECT * FROM [S002].[mydb].[dbo].[t1_1] UNION ALL
    SELECT * FROM [S002].[mydb].[dbo].[t1_2]


    any help is welcome.

  2. #2
    Join Date
    Aug 2003
    Location
    Germany
    Posts
    20
    I could track down the problem a little bit:

    In the Query Analyzer in the execution plan i could see that
    sql server uses a "remote scan" instead of "remote query".
    What am am i doing wrong or what did i forget to setup so that
    sql server uses a remote query ?

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How about the actual DML and DDL (for the table and the view (is a view DML or DDL?)

    That'll help us some....
    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.

Posting Permissions

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