have you run the above query to check table size to verify the space is being released from those tables?

if your resource are depending on node 2 when node1 faile then yes, they will switchover to node2 and will try to find reources there and after number of retry...

did you deleted your data and table or just flagged them as 'to be deleted'?

You can use below query to check space consuming by tables:-

/*

Obtains...

if your tables are fixed then just add those tables in model. And everytime you create new database, these tables will be there. As well you can configure the users...

it will fired whenever there is any syntax like create database either by query analyzer or EM

you need to create trigger for this event and place the trigger in master. It will keep track of any new databases addedd and will execute accordingly.

if your problem not yet resolved then can you just corss check that you getting only the required record in your temp table

i think you can give permission as view definition for a specific SP/s

if you got...

create a role/s and define required permission to that role.

Then you can add users in that role.

It will be easy for you to manage.

ok, but thats what I mean to ask in my original question.

ok, so you mean if the isolation level is not the read commited then he will not have any performance issue

check the update statement, are they 'with lock' hint which making the table not be available for other use.

Also what is the isolation level of the database/server?

is your snapshot agent running everytime? Check in the history of job for snapshot agent for that perticualr publisher.

Are you getting any error detail in replication monitor or msrepl_errors...

what is the logic?