Forums » Community Server 2008 » Bugs and Issues » Trying to Upgrade a CS 2007 SP2 site to CS 2008

Trying to Upgrade a CS 2007 SP2 site to CS 2008

rated by 0 users
This post has 27 Replies | 3 Followers

Top 75 Contributor
Posts 304
Points 4,535
Reply
jeffesp replied on Mon, Aug 4 2008 1:19 PM

The lack of results for the last query bothers me.  I don't know where that would be getting called, but it seems like that might be a path to pursue.

--
--Jeff (ATGi)
  • | Post Points: 20
Top 10 Contributor
Posts 2,423
Points 19,635
MVPs
Reply
Nick replied on Mon, Aug 4 2008 1:22 PM

Just to be sure that no posts where set to a section that doesn't exist I've run:



SELECT     PostID, ThreadID, ParentID, PostAuthor, UserID, SectionID, PostLevel, SortOrder, Subject, PostDate, IsApproved, IsLocked, IsIndexed, TotalViews, Body, 
                      FormattedBody, IPAddress, PostType, EmoticonID, PropertyNames, PropertyValues, SettingsID, AggViews, PostConfiguration, PostName, UserTime, 
                      ApplicationPostType, Points, RatingSum, TotalRatings, PointsUpdated, IndexDate, PostMedia, SpamScore, PostStatus
FROM         cs_Posts
WHERE     (SectionID = 4) OR
                      (SectionID = 7) OR
                      (SectionID = 8) OR
                      (SectionID = 10) OR
                      (SectionID = 15) OR
                      (SectionID = 21) OR
                      (SectionID = 22) OR
                      (SectionID = 23) OR
                      (SectionID = 24) OR
                      (SectionID = 25) OR
                      (SectionID = 26) OR
                      (SectionID = 32) OR
                      (SectionID = 33) OR
                      (SectionID = 37) OR
                      (SectionID = 38) OR
                      (SectionID = 40)

and:



SELECT     ThreadID, SectionID, UserID, PostAuthor, PostDate, ThreadDate, LastViewedDate, StickyDate, TotalViews, TotalReplies, MostRecentPostAuthorID, 
                      MostRecentPostAuthor, MostRecentPostID, IsLocked, IsSticky, IsApproved, RatingSum, TotalRatings, ThreadEmoticonID, ThreadStatus, SettingsID
FROM         cs_Threads
WHERE     (SectionID = 4) OR
                      (SectionID = 7) OR
                      (SectionID = 8) OR
                      (SectionID = 10) OR
                      (SectionID = 15) OR
                      (SectionID = 21) OR
                      (SectionID = 22) OR
                      (SectionID = 23) OR
                      (SectionID = 24) OR
                      (SectionID = 25) OR
                      (SectionID = 26) OR
                      (SectionID = 32) OR
                      (SectionID = 33) OR
                      (SectionID = 37) OR
                      (SectionID = 38) OR
                      (SectionID = 40)

Nick - nb development

  • | Post Points: 5
Top 10 Contributor
Posts 2,423
Points 19,635
MVPs
Reply
Nick replied on Mon, Aug 4 2008 1:27 PM

ok, I've run that query against 2 other CS installs I have on my pc and here's what I get:




(1 row(s) affected)
SectionID   SettingsID  IsActive ParentID    GroupID     Name                                                                                                                                                                                                                                                             NewsgroupName                                                                                                                                                                                                                                                    Description                                                                                                                                                                                                                                                      DateCreated             Url                                                                                                                                                                                                                                                              IsModerated DaysToView  SortOrder   TotalPosts  TotalThreads DisplayMask                                                                                                                                                                                                                                                        EnablePostStatistics EnablePostPoints EnableAnonymousPosting MostRecentPostID MostRecentThreadID MostRecentThreadReplies MostRecentPostSubject                                            MostRecentPostAuthor                                             MostRecentPostAuthorID MostRecentPostDate      PostsToModerate ForumType   IsSearchable ApplicationType ApplicationKey                                                                                                                                                                                                                                                   Path                                                                                                                                                                                                                                                            SectionPropertyNames                                                                                                                                                                                                                                             SectionPropertyValues                                                                                                                                                                                                                                            DefaultLanguage                  DiskUsage            IsPublic HubSectionID IsCommunityAggregated WeblogMostRecentPostID WeblogMostRecentPostDate WeblogMostRecentPostName                                                                                                                                                                                                                                         WeblogMostRecentPostAuthorID WeblogMostRecentPostAuthor                                                                                                                                                                                                                                       WeblogMostRecentPostSubject                                                                                                                                                                                                                                      MostRecentArticleID MostRecentArticleDate   MostRecentArticleName                                                                                                                                                                                                                                            MostRecentArticleAuthorID MostRecentArticleAuthor                                                                                                                                                                                                                                          MostRecentArticleSubject                                                                                                                                                                                                                                         PostCount   ArticleCount CommentCount TrackbackCount
----------- ----------- -------- ----------- ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ----------- ------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -------------------- ---------------- ---------------------- ---------------- ------------------ ----------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------- ----------------------- --------------- ----------- ------------ --------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------- -------------------- -------- ------------ --------------------- ---------------------- ------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- ----------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------------ ------------ --------------
4           1000        1        0           4           Sample Weblog                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      2008-07-02 07:25:05.743                                                                                                                                                                                                                                                                  0           7           1           5           3            0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 1                    1                0                      0                0                  0                                                                                                                                                         0                      1797-01-01 00:00:00.000 0               0           1            1               sample_weblog                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    SectionOwners:S:0:5:Theme:S:5:6:aboutTitle:S:11:19:                                                                                                                                                                                                              adminaxcessAbout Sample Weblog                                                                                                                                                                                                                                   en                               0                    1        0            1                     8                      2008-07-24 15:39:24.263  another post with clipboard images                                                                                                                                                                                                                               2100                         Nick                                                                                                                                                                                                                                                             Another Post with clipboard images                                                                                                                                                                                                                               0                   2008-07-02 07:25:05.743 NULL                                                                                                                                                                                                                                                             0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           3           0            2            0

(1 row(s) affected)

SettingsID  Implied SectionID   GroupID     ApplicationKey                                                                                                                                                                                                                                                   RoleID                               AllowMask            DenyMask             ApplicationType
----------- ------- ----------- ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------ -------------------- -------------------- ---------------
1000        1       -1          -1          NULL                                                                                                                                                                                                                                                             040A20D5-7005-488B-B983-200EDA165E58 9                    4                    1
1000        1       -1          -1          NULL                                                                                                                                                                                                                                                             DE040E58-7FF5-48EE-BB4A-65EED0614AE0 589                  0                    1
1000        1       -1          -1          NULL                                                                                                                                                                                                                                                             367C1005-3B71-46E3-BB41-6A9619952288 589                  0                    1
1000        1       -1          -1          NULL                                                                                                                                                                                                                                                             CBA94219-746C-43AC-91C6-93210A36E5E9 9                    4                    1
1000        1       -1          -1          NULL                                                                                                                                                                                                                                                             A6E20300-6FBD-4507-BF2A-97FBDF9C0684 589                  0                    1

(5 row(s) affected)

SectionID   UserID      MembershipType DateAdded               ApplicationType
----------- ----------- -------------- ----------------------- ---------------

(0 row(s) affected)

Nick - nb development

  • | Post Points: 20
Top 75 Contributor
Posts 304
Points 4,535
Reply
jeffesp replied on Mon, Aug 4 2008 1:33 PM

What's the value of the output param (@p8) for all the queries?

Can you run the Profiler trace after you reset the app pool so we have an empty cache to work with?

--
--Jeff (ATGi)
  • | Post Points: 20
Top 10 Contributor
Posts 2,423
Points 19,635
MVPs
Reply
Nick replied on Mon, Aug 4 2008 1:50 PM

@p8 = 7

Profiler:

exec dbo.cs_EventLog_Add @EventType=0,@EventID=200,@SettingsID=-1,@Message=N'CS.Web Started',@Category=N'Application',@MachineName=N'NICK-PC'
go
exec sp_reset_connection
go
exec dbo.cs_SiteSettings_Get @SiteUrl=N'nick-pc',@SettingsID=-1,@ReturnAll=0
go
exec sp_reset_connection
go
exec dbo.cs_ApplicationConfigurationSettings_Get @SettingsID=1000,@ApplicationType=1
go
exec sp_reset_connection
go
exec dbo.cs_Licenses_Get
go
exec sp_reset_connection
go
exec dbo.cs_ApplicationConfigurationSettings_Get @SettingsID=1000,@ApplicationType=13
go
exec sp_reset_connection
go
exec dbo.cs_ApplicationConfigurationSettings_Get @SettingsID=1000,@ApplicationType=0
go
exec sp_reset_connection
go
exec dbo.cs_ApplicationConfigurationSettings_Get @SettingsID=1000,@ApplicationType=11
go
exec sp_reset_connection
go
exec dbo.cs_User_Get @UserName=N'Anonymous',@UserID=0,@IsOnline=1,@LastAction=N'',@SettingsID=1000
go
exec dbo.aspnet_CheckSchemaVersion @Feature=N'Common',@CompatibleSchemaVersion=N'1'
go
exec dbo.aspnet_CheckSchemaVersion @Feature=N'Membership',@CompatibleSchemaVersion=N'1'
go
exec dbo.aspnet_Membership_GetUserByName @ApplicationName=N'dev',@UserName=N'Anonymous',@UpdateLastActivity=0,@CurrentTimeUtc='Aug  4 2008  6:42:24:023PM'
go
exec sp_reset_connection
go
exec dbo.aspnet_CheckSchemaVersion @Feature=N'Role Manager',@CompatibleSchemaVersion=N'1'
go
exec dbo.aspnet_UsersInRoles_GetRolesForUser @ApplicationName=N'dev',@UserName=N'Anonymous'
go
exec sp_reset_connection
go
exec dbo.cs_User_Get @UserName=N'nick',@UserID=0,@IsOnline=1,@LastAction=N'',@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.aspnet_Membership_GetUserByName @ApplicationName=N'dev',@UserName=N'Nick',@UpdateLastActivity=0,@CurrentTimeUtc='Aug  4 2008  6:42:24:767PM'
go
exec sp_reset_connection
go
exec dbo.aspnet_UsersInRoles_GetRolesForUser @ApplicationName=N'dev',@UserName=N'nick'
go
exec sp_reset_connection
go
exec dbo.cs_ThemeConfigurationData_Get @ThemeName=N'hawaii',@SectionID=-1,@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.aspnet_CheckSchemaVersion @Feature=N'Profile',@CompatibleSchemaVersion=N'1'
go
exec dbo.aspnet_Profile_GetProperties @ApplicationName=N'dev',@UserName=N'Nick',@CurrentTimeUtc='Aug  4 2008  6:42:25:190PM'
go
exec sp_reset_connection
go
exec dbo.cs_Content_Load @ContentID=-1,@Name=N'StandardTop',@SettingsID=1000
go
exec sp_reset_connection
go
declare @p7 int
set @p7=0
exec dbo.cs_FriendRequest_SelectByUserID @UserID=2100,@FriendshipState=2,@pageIndex=0,@pageSize=9,@sortOrder=1,@sortBy=1,@totalCount=@p7 output
select @p7
go
exec sp_reset_connection
go
exec dbo.cs_Roles_Get @UserName=N'',@ApplicationName=N'dev'
go
exec sp_reset_connection
go
exec dbo.cs_SectionMembers_Get @SectionID=default,@UserID=2100,@MembershipType=default
go
exec sp_reset_connection
go
declare @p9 int
set @p9=5810
exec dbo.[cs_shared_Threads_GetThreadSet] @SectionID=-1,@PageIndex=0,@PageSize=5,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED
declare @lrc int; set @lrc = @localRowsToReturn; if @lrc IS NULL OR @lrc < 0 SET @lrc = 0; set rowcount @lrc;
Select  P.PostID From dbo.cs_Posts P right join dbo.cs_Threads T on (P.ThreadID = T.ThreadID) inner join dbo.cs_Sections S on S.SettingsID = P.SettingsID and S.SectionID = P.SectionID  where  
P.SettingsID = 1000  and S.ApplicationType = 1   and S.DefaultLanguage not in (''zh-CHS'',''zh-CHT'',''da'',''el'',''it'')  and S.IsActive = 1  AND S.HubSectionID = 0  and P.ApplicationPostType & 7
<> 0  and P.IsApproved = 1 and P.PostDate <= getdate()  Order by P.PostDate desc ',@sqlPopulateCount=N'SET Transaction Isolation Level Read UNCOMMITTED
Select  @recordCount = count(*) from ( select 1 From dbo.cs_Posts P right join dbo.cs_Threads T on (P.ThreadID = T.ThreadID) inner join dbo.cs_Sections S on S.SettingsID = P.SettingsID and
S.SectionID = P.SectionID  where  P.SettingsID = 1000  and S.ApplicationType = 1   and S.DefaultLanguage not in (''zh-CHS'',''zh-CHT'',''da'',''el'',''it'')  and S.IsActive = 1  AND S.HubSectionID
= 0  and P.ApplicationPostType & 7 <> 0  and P.IsApproved = 1 and P.PostDate <= getdate()  ) as countQuery (counter) ',@UserID=0,@IncludeCategories=0,@IncludePageIndex=0,@TotalRecords=@p9
output,@SettingsID=1000
select @p9
go
exec sp_reset_connection
go
declare @p8 int
set @p8=1
exec dbo.cs_Sections_Get @SettingsID=1000,@ApplicationType=1,@AllowInactive=1,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED
Select S.SectionID FROM dbo.cs_Sections S  where  S.SettingsID = 1000  and S.SectionID = 5  and S.ApplicationType = 1   and S.DefaultLanguage not in (''zh-CHS'',''zh-CHT'',''da'',''el'',''it'')  
Order by S.SortOrder asc ',@PageIndex=0,@PageSize=20,@IncludeMembers=1,@TotalRecords=@p8 output
select @p8
go
exec sp_reset_connection
go
exec dbo.cs_users_Get @PageIndex=0,@PageSize=2147483646,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED  SELECT P.UserID From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  
and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE @SearchText )  and UserID IN ( 4873 )  ORDER BY  UserName ',@sqlPopulateCount=N'SET Transaction Isolation Level Read
UNCOMMITTED  SELECT @recordCount = count(*) from ( SELECT 1 From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE
@SearchText )  and UserID IN ( 4873 )  ) as countQuery (counter) ',@SearchText=N'%',@ReturnModerationCounters=0,@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.cs_Membership_GetUsersByName @ApplicationName=N'dev',@UserNames=N'joeale'
go
exec sp_reset_connection
go
exec dbo.cs_Profile_GetPropertiesForUsers @ApplicationName=N'dev',@UserNames=N'joeale'
go
exec sp_reset_connection
go
exec dbo.cs_Roles_GetRoleIdsForUsers @ApplicationName=N'dev',@UserNamesXml=N'<UserNames><UserName>joeale</UserName></UserNames>'
go
exec sp_reset_connection
go
exec dbo.cs_weblog_Post_Get @PostID=8972,@IncludeCategories=1,@IsApprovedFilter=0,@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.cs_weblog_Post_Get @PostID=8951,@IncludeCategories=1,@IsApprovedFilter=0,@SettingsID=1000
go
exec sp_reset_connection
go
declare @p8 int
set @p8=1
exec dbo.cs_Sections_Get @SettingsID=1000,@ApplicationType=1,@AllowInactive=1,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED
Select S.SectionID FROM dbo.cs_Sections S  where  S.SettingsID = 1000  and S.SectionID = 28  and S.ApplicationType = 1   and S.DefaultLanguage not in (''zh-CHS'',''zh-CHT'',''da'',''el'',''it'')  
Order by S.SortOrder asc ',@PageIndex=0,@PageSize=20,@IncludeMembers=1,@TotalRecords=@p8 output
select @p8
go
exec sp_reset_connection
go
exec dbo.cs_users_Get @PageIndex=0,@PageSize=2147483646,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED  SELECT P.UserID From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  
and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE @SearchText )  and UserID IN ( 6934 )  ORDER BY  UserName ',@sqlPopulateCount=N'SET Transaction Isolation Level Read
UNCOMMITTED  SELECT @recordCount = count(*) from ( SELECT 1 From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE
@SearchText )  and UserID IN ( 6934 )  ) as countQuery (counter) ',@SearchText=N'%',@ReturnModerationCounters=0,@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.cs_Membership_GetUsersByName @ApplicationName=N'dev',@UserNames=N'john obrien'
go
exec sp_reset_connection
go
exec dbo.cs_Profile_GetPropertiesForUsers @ApplicationName=N'dev',@UserNames=N'john obrien'
go
exec sp_reset_connection
go
exec dbo.cs_Roles_GetRoleIdsForUsers @ApplicationName=N'dev',@UserNamesXml=N'<UserNames><UserName>john obrien</UserName></UserNames>'
go
exec sp_reset_connection
go
exec dbo.cs_weblog_Post_Get @PostID=8965,@IncludeCategories=1,@IsApprovedFilter=0,@SettingsID=1000
go
exec sp_reset_connection
go
declare @p8 int
set @p8=177
exec dbo.cs_Media_Posts_Get @SectionID=-1,@PageIndex=0,@PageSize=5,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED
declare @lrc int; set @lrc = @localRowsToReturn; if @lrc IS NULL OR @lrc < 0 SET @lrc = 0; set rowcount @lrc;
Select  P.PostID From dbo.cs_Posts P right join dbo.cs_Threads T on (P.ThreadID = T.ThreadID) inner join dbo.cs_Sections S on S.SettingsID = P.SettingsID and S.SectionID = P.SectionID  where  
P.SettingsID = 1000  and S.ApplicationType = 13   and S.DefaultLanguage not in (''zh-CHS'',''zh-CHT'',''da'',''el'',''it'')  and S.IsActive = 1  AND S.HubSectionID = 0  and P.ApplicationPostType &
2 <> 0  and P.IsApproved = 1  and P.PostDate <= getdate()  and S.ApplicationType = 13  order by P.PostDate desc',@sqlPopulateCount=N'SET Transaction Isolation Level Read UNCOMMITTED
Select  @recordCount = count(*) from ( select 1 From dbo.cs_Posts P right join dbo.cs_Threads T on (P.ThreadID = T.ThreadID) inner join dbo.cs_Sections S on S.SettingsID = P.SettingsID and
S.SectionID = P.SectionID  where  P.SettingsID = 1000  and S.ApplicationType = 13   and S.DefaultLanguage not in (''zh-CHS'',''zh-CHT'',''da'',''el'',''it'')  and S.IsActive = 1  AND S.HubSectionID
= 0  and P.ApplicationPostType & 2 <> 0  and P.IsApproved = 1  and P.PostDate <= getdate()  and S.ApplicationType = 13  ) as countQuery (counter) ',@UserID=0,@IncludeCategories=0,@TotalRecords=@p8
output,@SettingsID=1000
select @p8
go
exec sp_reset_connection
go
declare @p8 int
set @p8=1
exec dbo.cs_Sections_Get @SettingsID=1000,@ApplicationType=13,@AllowInactive=1,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED
Select S.SectionID FROM dbo.cs_Sections S  where  S.SettingsID = 1000  and S.SectionID = 20  and S.ApplicationType = 13   and S.DefaultLanguage not in (''zh-CHS'',''zh-CHT'',''da'',''el'',''it'')  
Order by S.SortOrder asc ',@PageIndex=0,@PageSize=20,@IncludeMembers=1,@TotalRecords=@p8 output
select @p8
go
exec sp_reset_connection
go
exec dbo.cs_users_Get @PageIndex=0,@PageSize=2147483646,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED  SELECT P.UserID From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  
and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE @SearchText )  and UserID IN ( 2103 )  ORDER BY  UserName ',@sqlPopulateCount=N'SET Transaction Isolation Level Read
UNCOMMITTED  SELECT @recordCount = count(*) from ( SELECT 1 From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE
@SearchText )  and UserID IN ( 2103 )  ) as countQuery (counter) ',@SearchText=N'%',@ReturnModerationCounters=0,@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.cs_Membership_GetUsersByName @ApplicationName=N'dev',@UserNames=N'harrison hoffman'
go
exec sp_reset_connection
go
exec dbo.cs_Profile_GetPropertiesForUsers @ApplicationName=N'dev',@UserNames=N'harrison hoffman'
go
exec sp_reset_connection
go
exec dbo.cs_Roles_GetRoleIdsForUsers @ApplicationName=N'dev',@UserNamesXml=N'<UserNames><UserName>harrison hoffman</UserName></UserNames>'
go
exec sp_reset_connection
go
declare @p8 int
set @p8=1
exec dbo.cs_Sections_Get @SettingsID=1000,@ApplicationType=13,@AllowInactive=1,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED
Select S.SectionID FROM dbo.cs_Sections S  where  S.SettingsID = 1000  and S.SectionID = 29  and S.ApplicationType = 13   and S.DefaultLanguage not in (''zh-CHS'',''zh-CHT'',''da'',''el'',''it'')  
Order by S.SortOrder asc ',@PageIndex=0,@PageSize=20,@IncludeMembers=1,@TotalRecords=@p8 output
select @p8
go
exec sp_reset_connection
go
exec dbo.cs_users_Get @PageIndex=0,@PageSize=2147483646,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED  SELECT P.UserID From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  
and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE @SearchText )  and UserID IN ( 2105 )  ORDER BY  UserName ',@sqlPopulateCount=N'SET Transaction Isolation Level Read
UNCOMMITTED  SELECT @recordCount = count(*) from ( SELECT 1 From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE
@SearchText )  and UserID IN ( 2105 )  ) as countQuery (counter) ',@SearchText=N'%',@ReturnModerationCounters=0,@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.cs_Membership_GetUsersByName @ApplicationName=N'dev',@UserNames=N'kip kniskern'
go
exec sp_reset_connection
go
exec dbo.cs_Profile_GetPropertiesForUsers @ApplicationName=N'dev',@UserNames=N'kip kniskern'
go
exec sp_reset_connection
go
exec dbo.cs_Roles_GetRoleIdsForUsers @ApplicationName=N'dev',@UserNamesXml=N'<UserNames><UserName>kip kniskern</UserName></UserNames>'
go
exec sp_reset_connection
go
exec dbo.cs_Sections_Get @SettingsID=1000,@ApplicationType=0,@AllowInactive=1,@IncludeMembers=1
go
exec sp_reset_connection
go
exec dbo.cs_users_Get @PageIndex=0,@PageSize=2147483646,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED  SELECT P.UserID From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  
and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE @SearchText )  and UserID IN ( 4319,4324,7245 )  ORDER BY  UserName ',@sqlPopulateCount=N'SET Transaction Isolation Level
Read UNCOMMITTED  SELECT @recordCount = count(*) from ( SELECT 1 From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE
@SearchText )  and UserID IN ( 4319,4324,7245 )  ) as countQuery (counter) ',@SearchText=N'%',@ReturnModerationCounters=0,@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.cs_Membership_GetUsersByName @ApplicationName=N'dev',@UserNames=N'davidk,poweruparies,rshutes90'
go
exec sp_reset_connection
go
exec dbo.cs_Profile_GetPropertiesForUsers @ApplicationName=N'dev',@UserNames=N'davidk,poweruparies,rshutes90'
go
exec sp_reset_connection
go
exec dbo.cs_Roles_GetRoleIdsForUsers @ApplicationName=N'dev',@UserNamesXml=N'<UserNames><UserName>davidk</UserName><UserName>poweruparies</UserName><UserName>rshutes90</UserName></UserNames>'
go
exec sp_reset_connection
go
exec dbo.cs_Threads_GetThreadSet @SectionID=-1,@PageIndex=0,@PageSize=5,@sqlCount=N'SELECT count(T.ThreadID)  FROM dbo.cs_Threads T  WHERE  T.SettingsID = 1000  AND T.SectionID IN (36, 39, 41, 35)
AND ThreadDate >= ''2008-06-04T19:42:30''  AND IsApproved = 1 AND IsLocked = 0',@sqlPopulate=N'SELECT T.ThreadID  FROM dbo.cs_Threads T  WHERE  T.SettingsID = 1000  AND T.SectionID IN (36, 39, 41,
35) AND ThreadDate >= ''2008-06-04T19:42:30''  AND IsApproved = 1 AND IsLocked = 0 ORDER BY ThreadDate DESC',@UserID=2100,@ReturnRecordCount=1,@IncludeCategories=0,@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.cs_users_Get @PageIndex=0,@PageSize=2147483646,@sqlPopulate=N'SET Transaction Isolation Level Read UNCOMMITTED  SELECT P.UserID From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  
and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE @SearchText )  and UserID IN ( 2102 )  ORDER BY  UserName ',@sqlPopulateCount=N'SET Transaction Isolation Level Read
UNCOMMITTED  SELECT @recordCount = count(*) from ( SELECT 1 From dbo.cs_vw_Users_FullUser P  where SettingsID = 1000  and UserAccountStatus = 1  and ( UserName LIKE @SearchText OR Email LIKE
@SearchText )  and UserID IN ( 2102 )  ) as countQuery (counter) ',@SearchText=N'%',@ReturnModerationCounters=0,@SettingsID=1000
go
exec sp_reset_connection
go
exec dbo.cs_Membership_GetUsersByName @ApplicationName=N'dev',@UserNames=N'chris'
go
exec sp_reset_connection
go
exec dbo.cs_Profile_GetPropertiesForUsers @ApplicationName=N'dev',@UserNames=N'chris'
go
exec sp_reset_connection
go
exec dbo.cs_Roles_GetRoleIdsForUsers @ApplicationName=N'dev',@UserNamesXml=N'<UserNames><UserName>chris</UserName></UserNames>'
go

Nick - nb development

  • | Post Points: 20