Author: InsanePaul | Posted on: 7/2/2009 8:18:54 AM | Views : 295

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 ...