>
>SELECT * from myTable WHERE ID = @ID WITH (READPAST)
>
>
>That's a good guess....but a READPAST essentially ignores a row where it can't get a shared lock.
>
>Again, in this situation, if a shared lock could not be obtained, we want the last good committed version.
>
>Give you a hint....think "camera"
Based on the hint I guess you're talking about snapshots.
CREATE DATABASE AdventureWorks_dbss1800 ON
( NAME = AdventureWorks_Data, FILENAME =
'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\AdventureWorks_data_1800.ss' )
AS SNAPSHOT OF AdventureWorks;
http://technet.microsoft.com/en-us/library/ms175876.aspxI haven't played with them yet.
If it's not broken, fix it until it is.
My Blog