Thanks a lot.

I already know the "issue" of my problem.

The instance was restarted for 11 times in the same day, as the rollover its done when the instance start i...

Thanks Gail.

Regards,

JMSM 😉

Hello again,

Sean,

I've comment the line as you tell me to do it but and uncomment the line select @sSQL but i really dont have any usefull results.

I only want...

Hi Sean,

I'm sorry but i'm using your code to test and ......i really dont know if i'm using it in the right way.

I create a table in a specific database...

Hello,

I dont understand when you're telling me "conflit between tempdb and youre database".

The server collation its different in both instances and there's an aplication that automatically will create databases. So...

Hello again,

I'm really but really sorry, but i'm completely lost and hope that anyone explain me what should i do like if i was a donkey :crying:

Sorry but i really...

Hello again,

I've attached the execution plan and the code of both views, the oldest and the new one.

I've change yet the column names, and the tablename on both views.

Thanks and...

Thanks a lot LutzM.

I'll change the function as u tell me.

Regards,

JMSM 😉

Thanks a lot Koen.

I'll do the right checks and i'll tell you the solution.

Once more thanks.

Regards,

JMSM 😉

Thanks and regards,

JMSM 😉

Ok.

So can you send me a query where i can see in the output the following information.

The spid xxx that is locking spid yyy for x min (for example 5...

Thanks a lot.

Regards,

JMSM 😉

Hello again,

Sorry for i didn't respond with the solution.

My solution was asa follows.

Thanks and regards,

JMSM 😉

declare @sd as datetime

declare @sdaux as datetime

set @sd = cast('2010-07-23 07:00:00' as datetime)

set @sdaux =...

Thanks a lot everybody.

Regards,

JMSM 😉

Hi,

I think that will be posible to make the change from snapshot replication to transactional............. but i'd like to understand is if the time that the snapshot is running is...