Viewing 15 posts - 1 through 15 (of 312 total)
Can you give some indication of the reason people might want to use KQL rather than SQL? What advantages does it have that justify the effort of learning it?
January 6, 2022 at 9:33 pm
There are a lot of reasons... The biggest one is: beeing forgotten. Or for example, when one database comes from a completely different server but the login is beeing...
January 6, 2022 at 9:09 pm
i added the update one for users that have a different Id than the login on the server.
INSERT INTO ##tbl_db_principals_statements (stmt, result_order) SELECT...
July 28, 2021 at 4:17 pm
Ever get anywhere with this? I came across https://techcommunity.microsoft.com/t5/sql-server-support/getting-cross-domain-kerberos-and-delegation-working-with-ssis/ba-p/318361 that explains it, but falls short of identifying what is needed for constrained delegation. TIA.
July 6, 2021 at 9:27 pm
Thank you for the script. Very useful!
One issue I have discovered is that the type level permissions syntax is incorrect. The script shows this: IF... GRANT EXECUTE ON [schemaName].[typeName]...
June 10, 2021 at 7:10 pm
Are there additional changes to the script if it will be ran on an Azure SQL Managed Instance aside from adding the type 'E' and 'X' (E =...
June 10, 2021 at 7:03 pm
Can you please suggest in running the same script on all databases in one go.
Unfortunately, this isn't designed to run that way since it is generating print statements. It...
June 10, 2021 at 6:39 pm
Hey all. There have been quite a few comments recently, and some edits provided by Andrew G last year (I'm a bit behind, eh?). I am reviewing these and will...
June 10, 2021 at 6:08 pm
What a time to be alive, Jeff! We all need to start branching out, I feel.
November 2, 2020 at 8:55 pm
Seems like SSC moved to a new editor on the backend, and the attachments didn't come along. I published the zip to https://github.com/fuixx217/whatever so you can download from...
April 25, 2019 at 3:57 pm
Good write-up, Steve. I like that once you have the session defined the way you like, you can script it out, and I think it might actually be easier than...
June 21, 2018 at 7:02 am
June 6, 2018 at 9:35 am
This thread is ancient, but I was having this same exact issue on a SQL 2012, windows 2008 R2 OS machine. By looking at the C:\Users\<username>\AppData\Local\Temp\SqlSetup.log file after trying to run...
April 19, 2018 at 10:04 am
January 26, 2018 at 2:54 pm
My apologies to those replying and leaving feedback for this script. I am reviewing them and will get an update posted with the provided enhancements. Also, many thanks for some...
July 10, 2017 at 1:40 pm