I am not a DBA but I have been tasked (via an audit) to change our Server Authentication to Windows Authentication mode. (effectively disabling the SA user). We have a half dozen critical databases on our SQL Server and I am trying to find out the effect this would have on those Databases.
Is there a script or something that I can run that shows where/what the SA account is doing in the background? I have gone into SQL Server Profiler and set the 'Login' - LoginName to [Like sa] and the Trace does not show anything.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…