I guess I'm not clear on what you're asking. If you execute a select statement, you'll get a resultset on the screen.

SQL 2008 has intellisense in Management Studio. Won't work on 2005 connections, but if you write the query on a 2008 connection (Dev edition maybe), you could then port...

I'm going to suggest e-mailing Steve and asking for one. That's...

What do you want to change the month in? A query? A filename? The e-mail?

Yep, traces rock.

You listed three or four different queries earlier in this thread. Try each of them on each index, see what the average run-time and IO are on all of...

There's a feature in SQL 2005 called "output", that can return the values from an insert. You could use that to detect which exact rows were successfully inserted into...

If you can add triggers to tables, you can log stuff that way.

If you can get a log parser, you can check the SQL Server log files.

If neither of those...

Check out sp_executesql. You can return values as output parameters from dynamic SQL with that.

When you open the surface area configuration, what server does it say it's connected to? Local?

Try replacing all of that with:

SELECT @sql =

'select

dis

from

mshq_ivr_a1

where

plannbr = ' + cast(@qPlanNum as varchar(10)) + '

and

question = ' + cast(@qQuestion as varchar(10)) + '

and...

Can you provide the code for the two UDFs?

Ninja's_RGR'us (2/24/2009)

Since when are the words shirt and shits not interchangeable :P.

Ok I type too fast...

Are you running the configuration manager on the server where you are running SQL Server, or are you running it from a separate workstation?

You'll need to use dynamic SQL to accomplish what you're talking about. Build the query string, execute it.

For example:

declare @sql varchar(max);

select @sql = 'select q' + @Col + '...