therein lies the problem, when I specify:

ALTER SERVER AUDIT Audit_MyServer_DBs WHERE server_principal_name NOT IN (N'myDomain\!sqlmonitoring', N'myDomain\myDomain\myServiceAccount')

I receive error:

Msg 156, Level 15, State 1, Line 198

Incorrect syntax near the keyword 'IN'.

Still a tad bit confused Mr. Ant ... I'd like to exclude 2 values found in server_principal_name from being COLLECTED: mydomain\!sqlmonitoring --AND-- myDomain\myServiceAccount

This ALTER is working great for 1 value...

thank you Mr. Ant !!   I now see that in addition to setting the spec at the Server level -- If you need to audit the SELECT / INSERT /...

thx.. let me give that a try..

Thx for your feedback.  As of SQL 2019, -- unfortunately there are no columns in distribution.dbo.msarticles table which differentiate TBLs from VWs from PROCs from UDFs -- so I cannot...

Jeff & Michael - thank you for your replies.   You've confirmed our thoughts on this subject.

In some cases in our environment:

This cmd did not work:  C:\setspn -L ourServername.domainname.com

This cmd did work:  C:\setspn -Q MSSQLSvc/ourServername.domainname.com

My resolution included adding a DATA CONVERSION task to my extract from SQL table to a flat file .. specifying Data Type: text stream [DT_TEXT] and Code Page 65000 (UTF-7)

PLEASE DISREGARD the above request..  this was NOT my issue.  thx anyway

thx all -- for your valuable feedback.  Ed B, exactly what I was looking for!   thank you.

thx , makes sense-- I will be sure to connect to an instance prior to opening the .sql file in SSMS...

thx for this feedback..  also found this query which we're trying to expand to find slqcommand:

USE SSISDB

SELECT pr.name AS [ProjectName], pr.description AS [ProjectDescription], pr.last_deployed_time AS [ProjectLastValidated], pr.validation_status AS [ProjectValidationStatus], op.object_name...

Steve, this looks perfect.  Thank you for the FAST reply and a working solution - very much appreciated

So I think I'd like to use Powershell to accomplish this.  This statement works in Powershell: (exactly as in DOS CMD SHELL)

xcopy \\myFileServer\SQL_BKUP\mySQLServerAAA\myDBname111\FULL\*.bak \\myFileServer\SQL_BKUP\DisasterRecovery

With your assistance, I'd like to procure a...

My alter ego just located a sample:  Finding newest file in all subdirectories - DosTips.com:  www.dostips.com/forum/viewtopic.php?t=3250

You will need nested for loops. The first one to get a list of the directories,...