Sql String Split

Declare @ObjectName nVarChar(1000)

Set @ObjectName = 'HeadOfficeSQL1.Northwind.dbo.Authors'

SELECT

        PARSENAME(@ObjectName, 4) as Server,

        PARSENAME(@ObjectName, 3) as DB,

        PARSENAME(@ObjectName, 2) as Owner,

        PARSENAME(@ObjectName, 1) as Object

        

Server                    DB             Owner        Object

------------------------- -------------- ------------ ------------

HeadOfficeSQL1            Northwind      dbo          Authors

(1 row(s) affected)

If  we want other delimiter we use following code 

Declare @ObjectName nVarChar(1000)

Set @ObjectName = 'HeadOfficeSQL1,Northwind,dbo,Authors'

Set @ObjectName =  REPLACE(@ObjectName, ',', '.')

SELECT

        PARSENAME(@ObjectName, 4) as Server,

        PARSENAME(@ObjectName, 3) as DB,

        PARSENAME(@ObjectName, 2) as Owner,

        PARSENAME(@ObjectName, 1) as Object

                

Server                    DB             Owner        Object

------------------------- -------------- ------------ ------------

HeadOfficeSQL1            Northwind      dbo          Authors

(1 row(s) affected)