I recovered the database using a tool called "Recovery for SQL Server".

However, problem continues and I am able to reproduce a different crash:

I have a sp which is to delete...

Yes I have a dynamic sql in the sp, is it that causing problem?

Hi Greg,

The role has the execution right to sp.

Both table and sp have the same owner: dbo

I tested this way:

run: select * from table in QA, get permissiondeny error,...

That's not what I want.

What I am concerning is, since multiple users can access the database, which tables or sp/fn.. have been modified. It's just like Windows File Explorer,...

EM-->Tools-->SQL Profiler

Don't ask me what's EM.

Well, I am thinking there should be lots of similiar senarios in military application, because it's impossible for letting sa to know the content of a database, even if...

You forgot there are many 'sa' who can invoke any procedure if he wants

Hi Andy,

I tested your GROUP option this morning, the original one takes 00:04:58 to do it, yours spents 00:06:18. Is there anything wrong with the GROUP BY?

Thanks. Could you check your PM? I've send you the whole script.

Table [table_received] and [table_sent] has 50 000 000 rows each.

The new created tabels: .[Latest Mail Received] and .[Latest Mail Sent] has 20 000 roughly for each.

Thank you for your qucik response.

What info are you looking for? I stated in my first post. Here it is the code:

        DELETE FROM dbo.[Latest Mail Received]

        INSERT...

Could you state more detailed on your solution then?

Sorry I have a typo in my posting: >>They don't have no index. should be

>>They don't have index.

What do you mean: "Don't use cursors if there's an equivalent set-based operation"? I have...