Loading

I do not delete the record automatically in SQL Server?

Sudheer G

10y860

I am doing one project(MVC) in that I have added one field is expired futures means < today date that item display, but issue is automatically item deleted in the SQL server table after 5 mints can any one clear this issue.

Thanks Advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
You should use "SQL Server Profiler". The shortest way to identify the issue is just run the SQL Server Profiler on your machine and wait for 5 mins. The profiler will catch the delete query, then you can easily identify which triggers that one.

In the SQL Server Management Studio "Tools" menu, click "SQL Server Profiler".

Hope this helps!