I've tried profile , but it gives me always an error: conversion in varchar data in datetime generated a value not suitable (it's translated 'cuse I have an italian version)
I believe the correct translation for the error is "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
If so, the problem sounds very similar to this one:
Other languages may expect a DD/MM/YYYY format. SQL Server generates this error when there is a mismatch between what is provided and what the SQL Server is expecting.
The Free Tools are normally tested with US default settings and time zones. Given your location and language, try following the advice in the link and see if that resolves the issue.
SQL Data Profiler has been tested with SQL Server 2017 and it does work, so this should not be the problem.
So, I must change my server date and time defaults to MM/DD/YYYY? I can't 'because all the other programs won't work properly. It' s a pity 'cause I just needed this tool ..
Powered by IDERA