During the engagement suddenly a Jr. DBA asked me if I have a query that will list all the jobs in their system with the Job’s owner.
Question: Can Admin Rename SA Account in SQL Server?
Answer: Yes, of course. The syntax for to rename SA account is very simple:
During the Comprehensive Database Performance Health Check, I do receive questions about pretty much anything like Public Database Role.
First thing first – the command DBCC FLUSHAUTHCACHE only is supported on SQL Azure. The behavior of change of password is a bit different on SQL Azure.
In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login-mapping exists.