I have checked the Save License In Database and now when I try to open database a very long SQL error is displayed: difference of two datetime columns caused overflow at runtime.. (then something about sessions). Noone can open the database and I don't have any idea about this case.
Please helppp!!!
Ufuk Asci
Pargesoft
0
Answers
there are other posts you can read by searching the forum for
"datetime columns caused overflow at runtime"
http://www.BiloBeauty.com
http://www.autismspeaks.org
I killed ever session but I am still getting the message. You posted this code. But Where I have to run this code?
CASE WHEN SP.[cmd] = 'AWAITING COMMAND' THEN (CASE WHEN SP.[last_batch] < DATEADD(day, -30, GETDATE())
THEN 999999999 ELSE CAST(DATEDIFF(SECOND, SP.[last_batch], GETDATE()) AS BIGINT) * 1000 END) ELSE 0 END AS [Idle Time]
Pargesoft
http://www.BiloBeauty.com
http://www.autismspeaks.org
Regards,
Ufuk
Pargesoft
If you want urgent support, then buy a support ticket with Microsoft.
Putting urgent in your message is not the right way to get a response in this forum.
Please see Forum Rule #16: Forum Rules.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
If someone puts Urgent in topic and if the case really seems urgent then I try much more to help him cause one day I could be in a case like his. Buying Ticket couldn't be always possible and I do not have a right to impose something; I can only suggest...
On the other hand I also have to say that this the best forum I have ever been
Pargesoft