error is very clear - that user (bit\pqScott) does not have permissions to create the table on database RRDB01 - fix the permissions as required.

that has happened often enough over last few years - and not only with that CU - some of the scripts that are part of the upgrade process are not...

What...

Hold on.  I explicitly stated that auditors should not be able to change anything on the system.  Talking about giving auditors "sysadmin" is a straw man.

Scripts that capture full permissions...

And in neither case did all inquiries go thru and be approved by the DBA, correct?

An "audit" that only allows what the DBA wants to run is not a...

use $($variablename) to see if it solves your issue.

As to password protected spreadsheets, I've not had to work on such things before.  I'll have to do a test to find out if the "ACE Drivers" have a...

Converting these excel files to csv files isn't much too much of an issue as I recently came across a powershell script which helps me to automate this piece...

you can retrieve the object_id of that object and then get the name form sys.objects for the returned object.

as a string replacement alone - do a replace of both brackets...

why do other uses need to see who can login on a server? that is on its own a security risk and should not be exposed by default.

If it is...

• This reply was modified 4 years, 7 months ago by frederico_fonseca.

Would there be any advantage(speed) to strip my backup even though my drive that I'm backing up to is part of a San where it's not on it own...

reading the manual is normally advisable as it does contain the information one is looking most of the of the times.

https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/export-csv?view=powershell-7.2

using columnstore is potentially one of  your other issues - while it is GREAT for space saving and for aggregation style SQL it can perform badly for plain joins to...

Jeff - I do believe that the sample supplied with 2 digits and "." as separator  is only how its displayed and not how its stored.

I would query why that is a requirement - in a properly designed cube a good analysis tool that can accomplished that within the tool (SSAS or similar) using their...