May 25, 2016 at 3:37 am
Good morning,
I want to disable the sa account across my estate. I would rather avoid finding out in a week this has stopped some process working & hope not to be called in at midnight by some app guy.
Is there any way I can be sure this account isn't being used & disabling it won't cause an issue? I plan to check sysprocesses & the default trace.
I guess the system processes like the lazy_writer which are listed as being logged in as sa in sysprocesses will continue to run?
Forgive me if this has been dealt with elsewhere. I couldn't find anything.
Thank you.
May 25, 2016 at 12:49 pm
I would run a trace, for as long as possible on just activity relating to SA, save that info to a file/database and then do some good old fashion data mining....
Link for info on creating a SQL server trace using SQL Server Profiler
https://msdn.microsoft.com/en-us/library/ms175047(v=sql.105).aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply