some records are automatically deleted from aspnetdb database in aspnet_users table

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hi
This is Manjari.I am facing the problem 2 -3 times while creating the users in aspnetdb database .Usually it creates but after sometime its got automatically deleted.It is not happening everytime while creating the users account.I am wondering,how some of the records are automaically deleted.I have checked the schedulers and triggers also because of the confirmation.
Please suggest me the right path,Why this is happening ...
Any help really appreciable.

Thanks,
Manjari

Posted 28-Oct-14 1:09am

jagnyadatta

Add a Solution

Comments

Jitendra Ku. Sahoo 28-Oct-14 8:08am

Can you give more details or paste your code here ?

jagnyadatta 29-Oct-14 1:28am

i am using insert statement for creating the users in aspnetdb.dbo.aspnet_users
the user is creating in the db.but after 2-3 days automatically 2-3 records are deleting...from log files also..i m not getting any error ..why it is happening ...i am not getting any type of clue to sort out

Maciej Los 28-Oct-14 12:02pm

Are you using transactions?

jagnyadatta 29-Oct-14 1:25am

no mac,I am not using any transactions...with in 2-3 days some records are automatically deleting from aspnetdb.dbo.aspnet_users table ...today also 3 users record deleted automatically ..again i have created those records for giving access ..i m wondering ...why its happening
i checked log files also..but no help

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kskumaran · Answer 1 · 2014-11-04T05:42:00

Solution 1

Ex-
create trigger trg_delete on table_name for delete
declare @id bigint;
select @id=i.id from deleted d
as
begin
delete from table_name where id=@id
end

whenever delete table any key used where condition.

Posted 4-Nov-14 5:42am

kskumaran

Updated 4-Nov-14 5:48am

v2

Comments

jagnyadatta 4-Nov-14 23:50pm

Thanks for responding...But my problem is ...i am not deleting the records...after creation of records ....with in 2-3 days some of the records are deleting from aspnetdb.dbo.aspnet_users table....why it is happening and how to fix this issue..please let me know if you have some idea on this...