Post reply

Updated Rows not showing up

  • August 6, 2012 at 9:25 am

    #259708

    Hello Folks,

    I've a strange issue. I've updated a table in server A and tried to get data into a table in server B thru openrowset. Now when I run the query below I don't see updated data.

    SELECT * into dbo.temp_tbl FROM OPENROWSET('SQLNCLI','Data Source=Server A;trusted_connection=yes;Integrated Security=SSPI;',

    'select * from DBName.schemaname.tblname')

    Why am I still getting old data. What can we check and make sure everything is fine. Thanks.

  • August 6, 2012 at 9:29 am

    #1522115

    Did you open a transaction for the update and not commit it?

    Jared
    CE - Microsoft

  • August 6, 2012 at 9:30 am

    #1522117

    No. I just wrote an update query.That's all

  • August 6, 2012 at 9:32 am

    #1522118

    If you query directly from serverA, is the data updated? How did you verify that your update statement affected data?

    Jared
    CE - Microsoft

  • August 6, 2012 at 9:33 am

    #1522120

    Yes. I ran a select to see data is updated in Server A. That's the queer thing.

  • August 6, 2012 at 10:13 am

    #1522154

    Figured out why it is odd. It has been querying the same table(local) in Server B instead of Server A. When I deleted some rows and ran a query for those specific rows, it didn't give any result set. Turns out to be some delegation issue. I'll post if I have anything more just to help some one who will be in the same boat.

    Thanks all.

  • August 6, 2012 at 10:20 am

    #1522158

    Glad you figured it out.

    Jared
    CE - Microsoft

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply