"I review it".  How long does THAT take?

And why does it need reviewed for "safety" if they don't have the permissions to change anything on the...

What on...

• This reply was modified 4 years ago by ScottPletcher.

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...

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...

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...

One of the annoying things about the $(ESCAPE macros is that they are recognized only in job code (at least the last time I checked this).

So you'll have to run...

Correct.  That's why I have them witness the runs.  And, as a...

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...

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

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...

Interesting.  I was not aware of that quirk of PARSENAME.

SELECT PARSENAME(LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(@statement, CHAR(9), ''), CHAR(10), ''), CHAR(13), ''))), 1)

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...

Use: SELECT PARSENAME(@statement, 1), viz.:

declare @statement varchar(100) = '[dbo].[vw_EmployeeData]'
SELECT PARSENAME(@statement, 1)

set @statement = 'dbo.Employee'
SELECT PARSENAME(@statement, 1)

;WITH UDT_CKB_SNAPSHOT AS
(
  SELECT  [UPC] ,[MASTERCHAINNAME] ,[EVENT_TYPE],[STARTDATE],[ENDDATE] ,[EVENT_NAME] 
  FROM [BYIntegration].[SCPOMGR].[UDT_CKB_SNAPSHOT]
  WHERE [EVENT_TYPE]='Promotion' AND
        [STARTDATE] BETWEEN...

So, if I created a test table right now, and made an identity column, added 10 rows to it, then rebooted the server, and added another row, you're...