Para saber como trata el servidor los acentos y mayusculas

Declare @Accentvar1 char(1)
Declare @Accentvar2 char(1)
Declare @Casevar1 char(1)
Declare @Casevar2 char(1)
set @casevar1 ='A'
set @casevar2 ='a'
set @Accentvar1 ='a'
set @Accentvar2 ='á'

if @casevar1 = @casevar2
    begin
        print 'A and a are treated same'
    end
    else
    begin
        print 'A and a are not treated same'
    end

if @Accentvar1 = @Accentvar2
    begin
        print 'A and á are treated same'
    end
    else
    begin
        print 'A and á are not  treated same'
    end