Hi Joe

When I click member list link followin error apears:

"Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation."

My Database is 2005 and database collation is :"Arabic_CI_AS".

thanks.

A.Samarian

Hi joe
After 1 hours working I find the error:
The default collation of temporary tables is Server collation (not Database collation).
I correct the mp_Users_SelectPage stored procedure like following:
Best Regards
A. Samarian
USE [Samarian]
GO
/****** Object: StoredProcedure [dbo].[mp_Users_SelectPage] Script Date: 10/05/2007 02:31:02 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[mp_Users_SelectPage]

/*
Author: Joe Audette
Created: 2004-10-3
Last Modified: 2007-07-14

*/

@PageNumber int,
@PageSize int,
@UserNameBeginsWith nvarchar(50),
@SiteID int


AS
DECLARE @PageLowerBound int
DECLARE @PageUpperBound int


SET @PageLowerBound = (@PageSize * @PageNumber) - @PageSize
SET @PageUpperBound = @PageLowerBound + @PageSize + 1

--SET @PageLowerBound = @PageSize * @PageNumber
--SET @PageUpperBound = @PageLowerBound + @PageSize + 1


CREATE TABLE #PageIndexForUsers
(
IndexID int IDENTITY (1, 1) NOT NULL,
UserName nvarchar(50) COLLATE DATABASE_DEFAULT,
LoginName nvarchar(50) COLLATE DATABASE_DEFAULT
)
.
.
.
.