You're quite right, Lynn, I understand he's a very busy man, and it's only natural that he delegates from time to time.

Your confusion is understandable...it's actually called [sp_fulltext_catalog] (without the s).

We didn't declare a smallint, Bill Gates and his pals did.

I would tend to agree.

Do you have the option of creating a copy of the stored procedure with the variable declared as an int, and running that instead?...

The file size should double, for example, for a unicode file. (2 bytes per character.)

A text editor such as Ultraedit would confirm (Ctrl-H)

don't think it's a space - it's an alias

I've no supporting evidence to hand...but I'd be inclined to insert into a temp table (with appropriate KEY) and then join on the temp table (rather than use IN). ...

...and guess what,...

put in square brackets

[safasd\zasdf]

If it's a second instance then you should have something in the format

MYSERVER\INST01.Mydb.dbo.Mytable

(assuming your linked server is correctly set up.)

I already did

only use the server name for the linked server instance - not for the 'home' instance.

also I mentioned EXCEPT not union.

....you also need a linked server to query the other instance.

If you run your query on InstanceA then you need to create a linked server to point to InstanceB, at...

The more I know, the more I know nothing. More specifically, there are three levels of knowledge: Things you know, things you know you don't know, and things you...

What I've learned is that you don't have to be the authority on a subject to write about it. Sure, you should check the veracity of what you've written,...