Stored Procedure GetUsersAdvancedSearch fails

Description

In DNN 9.2.0 the stored procedure GetUsersAdvancedSearch fails with an error.

Executing the SP directly from SQL Server Management Studio results in the error:
Msg 3701, Level 11, State 5, Line 15
Cannot drop the table '#MatchingUsers', because it does not exist or you do not have permission.

Using the statement in a DNN module results in the error:
There was an error while executing the configured data source: There is an error in your SQL at line 15: Cannot drop the table '#MatchingUsers', because it does not exist or you do not have permission.

QA Test Plan

None

Assignee

Unassigned

Reporter

Michael Sciulli

Story Size

Unknown

Severity

Major

Triage

New

Reported in Build #

None

Fixed in Build

None

Dev Owner

None

Includes Code Fix

No

Documentation Required

None

Trouble Ticket

None

Requires More Info

None

QA Story Points

None

QA Owner

None

Injected

None

Automation Required

None

Code Review Owner

None

Affects versions

Priority

Medium
Configure