Home > Archive > SQL Anywhere database replication > January 2006 > sysremoteuser table updates









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author sysremoteuser table updates
Jim Diaz

2006-01-10, 11:23 am

ASA 6.0.3 -- I'm interested in determining what modifications were made to
the system table sys.sysremoteuser from some old log files. Running
dbtran -it sys.sysremoteuser doesn't seem to do this. Is there a way to get
this information?

Thanks

Jim


Reg Domaratzki \(iAnywhere Solutions\)

2006-01-10, 11:23 am

If you run dbtran with -sr (not positive it exists in your version, but you
can always download the v902 developer edition and use the v902 dbtran on
your v603 transaction log), it will add --REMOTE comments to the translated
SQL file that represent updates to the SYSREMOTEUSER table.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


"Jim Diaz" < jimdiazatemprisecorp
orationdotcom> wrote in message
news:43c3d578$1@foru
ms-1-dub...
> ASA 6.0.3 -- I'm interested in determining what modifications were made to
> the system table sys.sysremoteuser from some old log files. Running
> dbtran -it sys.sysremoteuser doesn't seem to do this. Is there a way to

get
> this information?
>
> Thanks
>
> Jim
>
>



Jim Diaz

2006-01-10, 1:23 pm

OH I LOVE YOU MAN.....


"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:43c3e0d4$1@foru
ms-2-dub...
> If you run dbtran with -sr (not positive it exists in your version, but
> you
> can always download the v902 developer edition and use the v902 dbtran on
> your v603 transaction log), it will add --REMOTE comments to the
> translated
> SQL file that represent updates to the SYSREMOTEUSER table.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "Jim Diaz" < jimdiazatemprisecorp
orationdotcom> wrote in message
> news:43c3d578$1@foru
ms-1-dub...
> get
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com