September 4, 2012 at 1:35 pm
Hi All,
Can anyone help me with below sql server 2005 and up:
input string:
BUILTIN\ADMINISTRATORS: [System Admin]YES;[Security Admin];[Server Admin];[setup Admin];[Process Admin];[Disk Admin]YES;[Database Creator]
output string:
BUILTIN\ADMINISTRATORS: [System Admin]YES;[Disk Admin]YES;
I am playing with Stuff and Replace functions but without any luck.
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
September 4, 2012 at 1:35 pm
Somehow it posts twice .. Please delete this one..
Thanks,
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply