Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Is SCN an issue?

Author  Topic 

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2012-01-19 : 04:40:38
I've just been reading about an Oracle issue [url]http://www.infoworld.com/d/security/fundamental-oracle-flaw-revealed-184163-0?page=0,0[/url]

I don't recall hearing of an equivalent in SQL Server but that could be my failing memory, anyone know any different?

-----------

What color do you want that database?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-19 : 05:51:03
The Log Sequence Number (LSN). But that is not synced between interconnected databases (except in mirroring, where the two databases are identical), it increments strictly on the basis of the log used (it's VLF number: Log block number: Log record number), so it can't be incremented by a few million like the Oracle one, and other than the hard limit of the data type there are no 'too large' values for it.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -