July 9, 2013 at 8:09 am
Finding them in one of the tables referenced by sys.server_principals was just a hunch. They could be somewhere else too. Have you tried adding the Login and then dropping it to see if that changes things?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 9, 2013 at 8:21 am
no, I don't tried create/drop login because now the problem is solved
I do not know how, I just deleted and created some other logins and it seems that synchronization is done!
but I want to find a solution for the next time 🙂
I will see if I can do some other tests to try your workaround
July 9, 2013 at 8:39 am
chauchs (7/9/2013)
no, I don't tried create/drop login because now the problem is solvedI do not know how, I just deleted and created some other logins and it seems that synchronization is done!
I am speculating because none of this seems to be documented, but adding any new Login may have prompted SQL Server to re-resolve group-member SIDs to names the next time they are used so you may have indirectly and inadvertently solved the problem by adding a new Login.
but I want to find a solution for the next time 🙂
If you happen to isolate it, please post back. I, am I'm sure others as well, could benefit from the information.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 9, 2013 at 9:30 am
Is there a way to edit the system functions?
As the system procedures in the database mssqlsystemresource, because I can see them but can't generate script !!
I would like to know where the functions (like SUSER_SID, SUSER_SNAME ...) get information.
July 9, 2013 at 9:36 am
chauchs (7/9/2013)
Is there a way to edit the system functions?
Nope. The ability to mess with system objects was taken away in SQL 2005 because people were modifying the system in unsupported ways, getting wrong behavior, and then calling Microsoft in to help them fix their system. That's when the System/Catalog Views and DMOs were introduced.
As the system procedures in the database mssqlsystemresource, because I can see them but can't generate script !!
I would like to know where the functions (like SUSER_SID, SUSER_SNAME ...) get information.
That stuff is likely buried in a DLL compiled from C++ code, so no again.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply