I am not sure that I understand the question, I see wrong MonthNumberV2 values for the column.
If you use this simple update statement, it should be fixed:

[code...

Thanks for your replies.

I've seen that the locking issue while starting a replication is normal, so we have to do this outside production hours.

Thanks again for your help!

Greetings,

Mischa

I just tried it, and it worked... Same server, nothing else changed, except for a reboot.

Best regards,

Mischa

Thanks for the replies! I have the solution, mail was not configured completely. Run this script:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Database Mail XPs', 1;

GO

RECONFIGURE

GO

Problem solved! I just do not understand...

On a other forum, I did get the following solution: Make a log-backup, then shrink, works perfect, even online! Thanks for your help!

Best regards,

Mischa

Ok, I have done that:

USE [ivs]

GO

DBCC SHRINKFILE (N'IVS_Log' , 5000)

GO

Now I get this result:

DbIdFileIdCurrentSizeMinimumSizeUsedPagesEstimatedPages

2226713280128067132801280

And the error (in messages):

Cannot shrink log file 2 (IVS_Log) because the logical log file located at...

Thanks for all of your help, I did run the script as mentioned above, and most problems where fixed, I just needed to recreate one script!

Best regards,

Mischa

Thanks for all of your help, I have not found the solution yet, but I will keep on working on it, and I will inform you all when I have...

Thanks, I will try this, I have full msdn licences, so I have the developers edition here... Thanks for the advice! But I think that this could be improved a...

Thanks you very much! That was exactly where I was looking for !

Thanks! 🙂

Thanks! This was a big help for me! 🙂

It works great now... I have made a table that holds the hostnames that are allowed to log in using this account...

thanks for your time, I think that the answers given are helping me a lot!