What are the effects of adding SYSADMIN Server Roles ?
I have this user called "SDE". It has PUBLIC Server Roles. Then I add SYSADMIN. All of a sudden, all application that use SDE cant query data.
One known effect is that this query "SELECT * FROM city" must be reworded as "SELECT * FROM SDE.city" to make it works.
I dont think that adding SYSADMIN server role is dangerous. Maybe some one here can explain otherwise...