Internet solutions team

I was using following query
select top 10 * from [sqlserver02\sqlserver02].mydatabase.dbo.aspnet_membership (nolock)
whereas “sqlserver02″ was a remote serever  and I found following errro
Msg 4122, Level 16, State 1, Line 1
Remote table-valued function calls are not allowed.
Then I remove (nolock) from the query and it worked.
Does any one know why remote serever doesn’t allow (nolock)?

Removes extra space from the string using Regular expression.

public static readonly RegexOptions Options =          RegexOptions.IgnorePatternWhitespace |
RegexOptions.Singleline;
public string RemoveExtaSpaces(string text)
{
Regex regex = new Regex(@”\s{2,}”, Options);
text = regex.Replace(text.Trim(), ” “); //This line removes extra spaces and make space exactly one.
//To remove the  space between the end of a word and a punctuation mark used in the text we will
//be using following line of code
regex=new Regex(@”\s(\!|\.|\?|\;|\,|\:)”); // “\s” whill check for space near all puntuation marks in side ( \!|\.|\?|\;|\,|\:)”); )
text = regex.Replace(text, “$1″);
return text;

}

Above function removes all extra spaces in the string to make one space exactly. Feel free to use, its been used and tested

static void Main(string[] args)

{

string mytext = “blah    blah    blah   blah   .”;

Console.WriteLine(mytext);

Console.WriteLine(RemoveExtaSpaces(mytext));

}

Result