Hi, thanks for the replies.

The procedure logs "start time" before it does anything else.

example: Procedure started at 06:03:34.077, duration :127 ms.

...

Restart of the SQL service resolved the issue.

Thanks again.

Thanks.

The page life expectancy is going averaging around 100 sec. The proc cache hits are around 90%. And even if everything is ok, I would like to see more...

Yes, it shows Available Physical Memory MB 5,134

The resource monitor shows memory in stand by 4.3 GB and free 800 MB

Thanks for reply.

The problem is that .net is out of reach. I am looking for something on sql side.

Hi,

Thanks for the article. Makes complicated things simple.

Only one question.

In case when all the articles in the publication are set to @pre_creation_cmd = 'None', do I still need...

Very nice and useful script. Thank you.

Had problems with similar table names under different schemes as well.

However, there is no need for joins to sys.tables and sys.schemas.

INSERT INTO #TEMPFRAG

SELECTOBJECT_NAME(F.OBJECT_ID)

,I.NAME...

Still helpful 🙂

It's been a long time since the first post but still... to make clear all the doubts:

Note

ALTER TABLE DROP COLUMN is always replicated to all subscriptions whose partition contains the...