Viewing 15 posts - 1 through 15 (of 98 total)
Apologies , that should read SQL 2016 and Compatibility levels
December 19, 2016 at 12:25 pm
thanks everyone , appreciate the advise and will be looking into the suggestions provided.
October 12, 2016 at 12:57 am
Thanks all some great topics for me to continue comms with the Devs there.
I will extract execution plan on the simple select I have been sent.
thanks again
September 16, 2016 at 1:08 am
Thanks everyone for the prompt replies.
I have been given a selection of queries from the users.
As an example a very basic select returns (669484 row(s) affected) in around 5 mins.
My...
September 15, 2016 at 4:36 pm
jasona.work (2/24/2016)
SCHEMA_OBJECT_PERMISSION_CHANGE_GROUP - Replaces Trace Event 103Audit Schema Object GDR Event
SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 104Audit Addlogin Event
SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 106Audit...
February 24, 2016 at 5:44 am
Ryan great script thank you.
Would it be possible to provide a script that writes to tables (not Temp) within a database call ZZZ (as an example ?)
For me the ideal...
January 6, 2016 at 7:03 am
Thanks for replies everyone , done some more investigation and the situation does not get any clearer.....
Ok this is what I found. To recap.
User in databases has red arrow. -...
November 3, 2015 at 1:54 am
Jayanth_Kurup (10/30/2015)
MickyD (10/29/2015)
Jayanth_Kurup (10/29/2015)
October 30, 2015 at 1:49 am
Jayanth_Kurup (10/29/2015)
October 29, 2015 at 2:24 pm
Gaz
Thanks for your reply. Will test it out today.
Cheers
February 5, 2015 at 1:46 am
Only requirement is to modify the role memberships , no object level permission changes as this stage.
August 20, 2014 at 4:38 am
Been working on this and still a bit stuck.
What I need to achieve is an output which will go thru the table of contents and dynamically produce an output script...
August 20, 2014 at 1:35 am
Thank you Scott
Will test and text again to ensure I understand the process.
Appreciate your efforts to help
August 19, 2014 at 4:38 pm
Scott
Thanks for this . Could you confirm if I need to add the select statement part ?
Ideal situation would be to read this from a table that exists in another...
August 19, 2014 at 4:23 pm
Scott hi
As requested. This will be the config of the table containing the removal data.
ServerNameDatabase UsernameRole Permissions ...
August 19, 2014 at 3:44 pm
Viewing 15 posts - 1 through 15 (of 98 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy