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  General SQL Server Forums  New to SQL Server Programming  sql sharepoint

Author  Topic  karikn11 Starting Member 1 Post Posted - 2012-05-14 : 05:34:10 Haloo, We have sql server locks of the sps 2007, does anyone know? ----------- <?query -- SELECT TOP 1 @ItemGUID = tp_GUID, @oldVersion = tp_Version FROM dbo.AllUserData WITH (UPDLOCK, INDEX=AllUserData_Url) WHERE tp_ListId = @ListId AND tp_DirName = @dirName AND tp_LeafName = @leafName AND tp_Level = @Level AND (@Version = 0 OR tp_Version = @Version) AND tp_RowOrdinal = 0