Rowversion

Question

Post reply

Rowversion

Steve Jones - SSC Editor

SSC Guru

Points: 734434
More actions
August 11, 2008 at 8:13 pm

#63683

Comments posted to this topic are about the item Rowversion

Viewing 15 posts - 1 through 15 (of 18 total)

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

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

i get an error "'MIN_ACTIVE_ROWVERSION' is not a recognized built-in function name. "..

"Keep Trying"

HanShi SSC-Dedicated Points: 33506 More actions · Answer 2

@Chirag: on the internet I've found "Min_active_rowversion() was introduced in SP2 for SQL Server 2005".

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Jamie-2229 SSCrazy Eights Points: 8156 More actions · Answer 3

MIN_ACTIVE_ROWVERSION (Transact-SQL)
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

This question is good but a bit confusing. It is keeping track of of transactions and actually returns a hexadecimal number that can be either cast as an int or a bigint. I kinda figured I would get this one wrong since hexadecimal was not in the list.

I never thought to try casting it as a datetime value - I'm interested in hearing more.

Saw this post after I answered:

http://newsgroups.derkeiler.com/Archive/Comp/comp.databases.ms-sqlserver/2008-03/msg00466.html

Jamie

dmbaker SSCertifiable Points: 5086 More actions · Answer 4

HanShi (8/12/2008)
@Chirag: on the internet I've found "Min_active_rowversion() was introduced in SP2 for SQL Server 2005".

That's all well and good, but the question doesn't say "In SQL Server 2005, what data type does this return."

In SQL Server 2000, it returns the error "'min_active_rowversion' is not a recognized function name.".

Given the text of the question, I would say that "Nothing as this is not a real SQL Server function" is as correct as the "correct" answer. 🙂

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 5

The question has been edited to show SQL Server 2005 as the context.

Steve Eckhart SSCommitted Points: 1880 More actions · Answer 6

I got the question right, but actually the answer is not correct. Since the question asked, what does "PRINT MIN_ACTIVE_ROWVERSION()" return, the answer is (from Books Online) "Returns a user-defined message to the client." which is what PRINT returns. Also, technically, MIN_ACTIVE_ROWVERSION() returns "[t]he rowversion data type [which] is also known as timestamp."

Steve Eckhart

StarNamer SSCrazy Eights Points: 8744 More actions · Answer 7

So now we have QotD questions which are Service Pack specific as well as version specific!

For all the production systems I access (all 2K5 SP1) this is a non-existent function ... which is why I gave that answer.

Derek

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 8

I think it's good that we ask questions about things that you don't know about. We can't control when something is introduced, so the question was designed to help you learn about a new feature in SP2.

While the PRINT does return a text value, the value is the rowversion. I've changed this to SELECT to clear up confusion.

Will Strutts Mr or Mrs. 500 Points: 558 More actions · Answer 9

It also says its a Binary(8) value which isn't on the list of possibilities.

ChiragNS One Orange Chip Points: 26137 More actions · Answer 10

HanShi (8/12/2008)
@Chirag: on the internet I've found "Min_active_rowversion() was introduced in SP2 for SQL Server 2005".

thanks for the info.

Steve - I think the question ought to have been clear and also we should have done lil bit more research before answering the question.

"Keep Trying"

hrushiatre SSC Enthusiast Points: 166 More actions · Answer 11

I got the question right, but actually the answer is not correct. Since the question asked, what does "PRINT MIN_ACTIVE_ROWVERSION()" return, the answer is

Returns a binary(8) value.

and The rowversion data type is also known as timestamp.

so timestamp is not a correct answer

Correct answer is binary(8) value

Please see

http://msdn.microsoft.com/en-us/library/bb839514.aspx