Great series Brad. I've used Profiler a fair bit for a while but will certainly be utilising it a lot more after watching your series using what I've learnt.

One thing...

Wouldn't you need to build your own sql admin interace to the server and restrict access to SQL tools?

Otherwise how else would you instruct the server to "hold fire" on...

Thanks, I have added valid params to the exec sp line.

They are date fields so I add '2005-1-1','2005-12-1'

The following screen (which enables you to select which fields to include, grouping...

I'm not I understood what you meant.

Run the query in VS?

the report is "fed" by a stored procedure. Therefore the "query" is exec mySPname param1, param2. A colleague has found a work-a-round and that is to hack the XML (.rdl)...

Thanks bkelley, that was exactly my thinking. (I didn't realise the double hop wasn't possible though).

Thanks, unfortunately that won't work in our scenario.

Our users all have individual logins to one (or more) databases.

Hi,

I'll describe the set-up... hopefully this will answer a couple of the questions.

I'll re-read through the questions when I've had my Monday morning coffee (yawn) and see if I can...

Hi John,

We have a 3rd party application with a SQL backend.

In the database are some (non out of the box) roles that allow users to do certain tasks within the...

Datasource credentials?

They are already set to windows authentication... as is IIS (anon access unticked)

Your question is a bit open but in a nutshell (and if I'm reading you correctly)

Create table - db_ddladmin

This will give a user the ability to create/alter/drop tables within a...

Hi Bob,

this isn't something I've done myself but hopefully this will point you in the right direction (?) until one of the resident gurus comes along.

This is SQL 2000 BTW.

Enterprise...

So I see. Strange behaviour IMHO.

Thanks for explaining. Seems there are many things that can trip you up in SQL.

It's almost as though you have to know the answer prior...

Hi and thanks.

I get the bit about count() returning integers because, of course, it is only counting whole units (so to speak). But it is the value of C I...

Panic over, I solved it!

I put the initial select 9test) in a cursor and then looped through adding a comma if necessary.

Thanks for all the help