Viewing 15 posts - 1 through 15 (of 74 total)
It was the missing END. It works perfectly now. There is only one LogOn record per SessionId so a MIN or MAX will have the same results.
January 21, 2022 at 3:33 pm
Yes and I do thank you. The STRING_SPLIT pointed me in the right direction.
September 28, 2021 at 7:27 pm
Kept googling and googling and found this and it works. https://www.youtube.com/watch?v=htpoAyuWw5o
September 28, 2021 at 7:08 pm
Yes they have leading and trailing spaces and it's literally in every single table of the database. It's many of the key fields too. I think I'll stick with Crystal...
September 28, 2021 at 12:50 pm
Our SQL is hosted and still only on 2016 so have no control over the version. I already have a separate DataSet created that is the source of the phases...
September 27, 2021 at 7:29 pm
I figured it out but no option to delete post
September 1, 2021 at 3:19 pm
I figured it out. Instead of using Subreports, which I'm so used to, I added an image then added an action to it to open the report. Works like a...
June 17, 2021 at 2:16 pm
Fantastic! The number of records that each @Incl filters out is minimal.
June 15, 2021 at 6:07 pm
Sweet! sp_who2 then kill works perfectly.
January 28, 2020 at 5:18 pm
i'm running SSMS 18.4 so not sure if that 17.9 article applies. Anyway, when I open it the processes is not paused it's just empty. All of them are. Eventually...
January 27, 2020 at 8:10 pm
Yes it's very clear the backup system is flawed but unfortunately our IT is outsourced and that was all I was given and have access to. I've requested a new...
January 3, 2020 at 2:01 pm
Unfortunately now that it's in Emergency mode I cannot connect to any tables in order to update our live table's with a query. Is there NOTHING I can do?
I tried...
January 2, 2020 at 6:01 pm
I've been able to get the database in Emergency mode so at least I can run queries on it and export the data I need.
January 2, 2020 at 5:18 pm
Created the database manually on a new instance with a new name. Stopped SQL. Renamed new empty database and renamed backup. Started SQL. It's now in "Recovering Pending". Can I...
January 2, 2020 at 5:11 pm
I have a new instance installed. I also cannot attach this mdf file in this new instance as it's still trying to locate the original ldf file (it's looking at...
January 2, 2020 at 5:01 pm
Viewing 15 posts - 1 through 15 (of 74 total)