<div>
Man, I love it when it's this simple. Thanks!<br />
<br />
John<br />

</div>


Man, I love it when it's this simple. Thanks!

John


<div>
<div class="content wysiwyg-content">
I'm trying to delete some records from my test database and I get this message:<br />
<br />
ERROR: The DELETE statement conflicted with the REFERENCE constraint &quot;FK__aspnet_Me__UserI__164<wbr />452B1&quot;. The conflict occurred in database &quot;DJRTest1&quot;, table &quot;dbo.aspnet_Membership&quot;, column 'UserId'. The statement has been terminated.<br />
<br />
So how do I delete a record from the aspnet_Users and aspnet_Membetrship tables? 
</div>
</div>


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? 

Deleting records from an aspnet_Users table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.