Sean Lange (10/31/2012)

---

You don't need SSMSToolsPack to generate a script for the...

I could have done this... but my B server is a remote server, that don't accespt IMPORT db...

Create a linked server on 1 of the machines then use a cross...

okey then, well noted 🙂

thankx again 😉

INDEED JUST MET THIS RESULT AND ADDED ORDER BY TO MY QUERY, BUT DID WORKED THO WITH OTHER LESS COMPLEX QUERIES

SO IT DEPENDS 🙂

thankx for the replies guys 🙂

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

Sean Lange...

okey 🙂 thankx for the advice 'll think doing so

you're right, it's just that I didn't mentioned or write it in here, but I did wrap it with a single quotation to the whole string 🙂

thank you 🙂

I found it 🙂

here is the solution

public string mySTRING (string singleQ){

return singleQ.Replace(" ' ", " ' ' ");

}

SELECT ID, Title

FROM viewTopTitles

WHERE Title =...

thanks imex

but it would work in Query Engine in SQL Server but as in my case am in ASP.NET and can't fix with this all the links (Titles) that contain...