• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 566
  • Last Modified:

Deleting records from an aspnet_Users table

I'm trying to delete some records from my test database and I get this message:

ERROR: The DELETE statement conflicted with the REFERENCE constraint "FK__aspnet_Me__UserI__164452B1". The conflict occurred in database "DJRTest1", table "dbo.aspnet_Membership", column 'UserId'. The statement has been terminated.

So how do I delete a record from the aspnet_Users and aspnet_Membetrship tables?
0
gabrielPennyback
Asked:
gabrielPennyback
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
you have to delet the user information from the dbo.aspnet_Membership first then from the other table
0
 
gabrielPennybackReliability Business Tools Analyst IIAuthor Commented:
Man, I love it when it's this simple. Thanks!

John
0
 
gabrielPennybackReliability Business Tools Analyst IIAuthor Commented:
Thanks again!
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now