I need to split a file into substrings each beginning with --<LINKEDSERVER>. I'm trying to use the string.split method but it seems to only accept char[]. I want to use --<LINKEDSERVER> to delimit the file. See example text below. I would like a collection of substrings that all begin with --<LINKEDSERVER>.
--<LINKEDSERVER>
IF OBJECT_ID('FN_CHECKSECURITY') IS NOT NULL
DROP FUNCTION FN_CHECKSECURITY
GO
--<LINKEDSERVER>
CREATE FUNCTION FN_CHECKSECURITY
(
@sItemGUID varchar(50)
, @sUserGUID varchar(50)
, @bItemType tinyint
)
...
Go to the complete details ...