Luis Cazares (9/4/2012)
Can you explain more your requirements?Because I'm sure that this won't work for you.
SELECT inputString, SUBSTRING( inputString, 1,42) + SUBSTRING( inputString, 105,16)
FROM (SELECT 'BUILTIN\ADMINISTRATORS: [System Admin]YES;[Security Admin];[Server Admin];[setup Admin];[Process Admin];[Disk Admin]YES;[Database Creator]' AS inputString) Input
However, it gives the correct output.
I am just writing a report that will show the login information with their privileges
NT AUTHORITY\SYSTEM: [System Admin]YES;[Security Admin];[Server Admin];[setup Admin];[Process Admin];[Disk Admin];[Database Creator]
NT SERVICE\MSSQL$instance1: [System Admin]YES;[Security Admin];[Server Admin];[setup Admin];[Process Admin];[Disk Admin];[Database Creator]
NT SERVICE\SQLAGENT$instance1: [System Admin]YES;[Security Admin];[Server Admin];[setup Admin];[Process Admin];[Disk Admin];[Database Creator]YES
I want the result as below:
NT AUTHORITY\SYSTEM: [System Admin]YES;
NT SERVICE\MSSQL$instance1: [System Admin]YES;
NT SERVICE\SQLAGENT$instance1: [System Admin]YES;[Database Creator]YES;
Thanks for you code .. but you code truncates the
SELECT inputString, SUBSTRING( inputString, 1,42) + SUBSTRING( inputString, 105,16)
FROM (SELECT 'NT SERVICE\SQLAGENT$instance1: [System Admin]YES;[Security Admin];[Server Admin]YES;[setup Admin];[Process Admin];[Disk Admin]YES;[Database Creator]YES' AS inputString) Input
NT SERVICE\SQLAGENT$instance1: [System Adess Admin];[Disk
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂