Hehe was about to say something under those lines.

Agreed... but that could cause an infinite loop so I might retract that statement .

Maybe something like this :

If exists (Select * from LinkedServer.DbName.dbo.TableName)

begin

--do what you need to do

end

if @@error > 0

begin

--linkedserver is down, raiserror...

end

but you could always do what you have to...

I thaught that the month name was required in the select... but it obviously can be generated in the application. Thanx for the solutions.

I still have to agree .

Yes replace the emoticon with ")".

I don't remember that last part beeing part of my code... what's that supposed to do?

"I will give the answer what i want and i dont want that u suggest me to read BOI."

Just feel that I must mention this : It's BOL...

The magic solution is to go back to Oracle where he's a God amongst insects and not the contrary . Looks like...

Nicer than my version... Looks like I still have to agree with you .

In english?

CONTAINS(ArticleDescription, 'magazine')

is not the same as

LIKE '%magazine%'

it's more like

LIKE 'magazine%'.

I can't explain it but I can assure you that those queries are not the same.

3) Listen to Noeld and try to find a set based approach for this.

What is the goal of that stored proc?

Can't think of anything to add .

Do you have a better solution than this one?

I'd like to flush out the last column so that no useless data is sent back (I can do a derived table...

Not this time though... you had a good 15 minutes to finish the job .

Here's a solution (maybe not the best but it...