To add to what Jeffrey said - if a CTE is mentioned in the following code 2 or more times it's evaluated and executed as many times. No...

the issue is not the sql itself but the whole combination - your system is likely constrained in memory and was unable to produce a plan for the full query.

the...

Of course it must vs taking locks.

"and use snapshot isolation."  MEGA-HUGE overhead.  SI should only be used...

you don't change the connection manager - you change the connection string that the connection manager uses.

only case where this is not possible is when your connection is a flat...

ahhhh. numbers....

2 situations - long ago, still on mainframes.

some reports were based on Lines of Code written.. so 2 teams each with their own type of code managed to "improve"...

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 3 years, 9 months ago by frederico_fonseca.