By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,372 Members | 1,950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,372 IT Pros & Developers. It's quick & easy.

Transaction id

P: n/a
lnd
Is it possible to find "system change ID" in SQL or stored procedures?
By "system change ID" I understand an internal serialized number which could
be used to serialize all SQL submitted into the database?

Thank you in advance, Laimis

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ln*@hnit.is wrote:
Is it possible to find "system change ID" in SQL or stored procedures?
By "system change ID" I understand an internal serialized number which could
be used to serialize all SQL submitted into the database?

Thank you in advance, Laimis


Not sure what you exactly envision here. What affects the serialization
of statements is more the time when their transaction commits, that the
time they are executed. From the point of view of the statement, that
order will be determined in the future, so how do you expect this thing
to work?
Jan

--
#================================================= =====================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================= = Ja******@Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.