Isn't it part of the client setup process, which as I recall is just an option from the common setup routine?

OK, somebody help me out here...

I can't see why you need to do the embedded query if it's the same table.  Why just do the top 20 on the outer...

Five years into my programming life I needed to write a printer driver for a product and decided that C was the way to go (though I'd only ever written in...

First make sure where the problem is:  what happens when you run the query in Query Analyzer?

I suspect it is not a SQL Server problem but likely on the client...

You know you can always try this stuff out when you have a question like that:

create table #t ( a int, b image )

insert into #t select 1, 'sadsf'

select CONVERT(...

Yes, this is missing big time from all the advice I've seen posted, but let me say it differently (or more explicitly):

Approach the interview as if you are interviewing the...

BCP is a command line (DOS) utility (BCP.EXE) that exists in the same directory as isqlw.exe

You may be able to

master..xp_cmdshell "BCP ...command here"

But when I said BCP, I meant...

Run a trace for a good long time (days) and look for references?

Then there's always the drop one at a time and see who squeals...(!)

sysdepends system table gives you...

Is this the "inserted" table as in you're doing this in a trigger? 

If so, I am not aware that EXEC will allow you to reference the inserted table: the...

easier than trimming at the end:

Dont initialize @items

and

SELECT @items = ISNULL( @items + ',', '' ) + column...

ISQLw will display data in text datatypes.  There is an upper limit to what will be displayed in the result set window, so if you want to just see if...

Put literals in the embedded select use to insert

INSERT INTO table_a ( col_a, col_b, ...)

   SELECT col_a, col_b, col_c..., 2 as revision_no

       FROM table_a

   WHERE key = ...

Put a terminating comma in the list and use charindex (so that chris<>christine):

WHERE CHARINDEX( empname+',', @namelist) > 0

note that indexes won't be used

Yes, well, I'm certain that they and the penguins are in it together...

Ah sush... do you like green eggs and ham?