The version you posted does the same thing: several rows for each parameter with the parameter as a different data type.

I figured it out, just had to change around the...

Awesome, thanks for the help.

Here's what I came up with so far:

SELECTprocs.name as ProcName,

params.name as ParameterName,

types.name as ParamType,

params.max_length,

params.precision,

params.scale,

params.is_output

FROMsys.procedures procs

LEFT OUTER JOINsys.all_parameters params

ONprocs.object_id = params.object_id

LEFT OUTER JOINsys.types types

ONparams.system_type_id = types.system_type_id

WHEREparams.user_type_id = types.user_type_id

ANDprocs.is_ms_shipped = 0

ORDER BYprocname,

params.parameter_id

The...

How do I add a join predicate?

I tried to add another join clause but the tables are already contained in a join clause. I tried aliasing the tables to...

I don't understand the difference. Sorry... Could you explain more?

I had to modify the query a bit to get it to run. Here is what I got:

select procs.name as ProcName, params.name as ParameterName, types.name as ParamType,

params.max_length, params.precision, params.scale,...

Awesome. Thank you.

got it. Thank you for the help.

got it, thank you.

I'm look through the dbs, and don't see sys.sql_modules. Where should I be looking?

Thanks.

Thank you for the help.

Cheers

I found a post online saying that there is a problem with network installs for client tools with the first disk. I installed from the second disk and it...

no I did not. Why would that effect client tools install?

Thank you.