I have a SP that is deleting all DNN user related table records for the users in my company table that are being deleted. THis works for all the table except the  ASPNet_Users and ASPNet_Membership tables. WHen I attempt to delete from there I fail with the following error:

Msg 529, Level 16, State 2, Procedure TTS_DeleteCompanyFromAllFiles, Line 70
Explicit conversion from data type int to uniqueidentifier is not allowed.

The SP compiles in SQL Studio but errors when running
My original code:

DELETE from aspnet_Users where UserId in
(select dnnid  from tts_payRollemployees where [BureauID] = @BureauID
 AND [CompanyID] = @CompanyID)

I have also tried with cast and convert to Int or varchar Both throw errors:

DELETE from aspnet_Users where UserId in
(select cast(cast(dnnid as varchar) as uniqueidentifier) from tts_payRollemployees where [BureauID] = @BureauID
 AND [CompanyID] = @CompanyID)

THe Field in my table is a string
Still no luck. ANy Help?

please be aware, that ASPNET tables do not use userid from DNN users table, but an internal GUID. you need to retrieve username from DNN users table to look up users to delete from aspnet_Membership and _users tables - but, as Cathal stated before, there is some risk, as these relations may be subject to change in future DNN versions.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN