Comments
Sort by recent activity
I've found I can use this query in DB Browser for SQLite to get similar behavior, however it would be great if this worked in the SQL History tool: select qv.DateSaved, qv.Contents, qvp.Server, qvp.Database, qvp.Name from Queries as q inner join QueryVersions qv on q.Identity = qv.QueryIdentity inner join QueryVersionProperties as qvp on qvp.Identity = qv.QueryPropertiesIdentity inner join (select QueryIdentity, max(datesaved) as maxDateSaved from QueryVersions group by QueryIdentity) as qv2 on qv2.QueryIdentity = qv.QueryIdentity and qv2.maxdatesaved = qv.DateSaved where Server is not null and Contents like '%<some string>%' order by DateSaved DESC / comments
I've found I can use this query in DB Browser for SQLite to get similar behavior, however it would be great if this worked in the SQL History tool:select qv.DateSaved, qv.Contents, qvp.Server, qvp....
Ahh, yes I have that registry setting. I used this guide to save my history in Onedrive, I have history going back to 2013. Removing that entry resolved the issue; however, I lost all the historical SQL. When I change it back the issue returns. Is there a way to fix the database or something so I don't have to lose all that? On a side note, restoring open queries has been going a bit crazy lately, opening up a ton of duplicate tabs, I'm guessing these two issues are related. / comments
Ahh, yes I have that registry setting. I used this guide to save my history in Onedrive, I have history going back to 2013. Removing that entry resolved the issue; however, I lost all the historica...
Sure thing, thank you for looking into it. I've had it happen before but then it resolved itself, I'm not sure what caused it or fixed it. It would be nice to have a fix. / comments
Sure thing, thank you for looking into it. I've had it happen before but then it resolved itself, I'm not sure what caused it or fixed it. It would be nice to have a fix.