Questions tagged [datetime2]
The datetime2 tag has no usage guidance.
2
questions with no upvoted or accepted answers
0
votes
1
answer
75
views
Why some triggers run exactly at the same time?
I wrote a simple audit with triggers. when a trigger called, the data inside the trigger (inserted and deleted rows) are sent through broker to a procedure to write them in the Master Audit Table. ...
0
votes
0
answers
130
views
SQL Server database restore from backup changes all dates with datetime2 type return with values to future dates
I'm trying to restore a SQL Server database from a .bak file.
The process completes without any issues, but the dates with datatype datetime2 are presented with totally different values (change to ...