Have a look at this:

http://ruggierolauria.blogspot.it/2016/02/sql-server-audit-security-events.html

http://ruggierolauria.blogspot.it/2016/02/sql-server-audit-security-events.html

Thanks a lot Gila

Here there is everyting you asked for:

/* SP */

CREATE PROCEDURE dbo.Vista_Parafarmaco

AS UPDATE dbo.Parafarmaco_AGG

SET ...

Ops... SPID 162=164 little mistake

Solved it was a query with the schemabinding option.

Everything worked fine.

Thks again

Ruggiero

Well finally had time to try this:

1) rename doctors original table (or drop it after copying alla data in a new table)

2) build up a query with same original table's...

Ok gone up with my analisys, but still have problems, sp_recompile mainly does

a dbcc LockObjectSchema (obj_name) - undocumented!

This option locks out schema changes until commit. Now I think this...

another issue trying to open a view: field field_name is readonly

I know that sp_recompile mark's the obiect to recompiled to the next execution, now i wonder what does it change that put in crysis a ADP project using views?

two kind of syntomps when in access you click on a view:

1) it simply doesn't open, anything appens.

2) gives error saying there is some missing field or table

I repeat...

It's a geat puzzle, also because i didn't manage the db from it's start and there are a lot of things not planned correctly.

However I admit there your suggestion is...

Yes I confirm, I have an identity column on doctors table referred in the doctors_address table. We have always performances problems, because of about 100 users using a program, is...

Well this has only a problem, our doctors table contains about 100k records, their address are supposed to be the some number (now) or more (in the next future), a...

Ok it seems I've to give more details about the problem I'm solving.

A customer has a table containing doctors data (name, surname, email, telephone, mobile, address...) now we understand that...

ops guests=customers sorry about my english I do the best i can :hehe: