SEO

#1 (**permalink**) 03-01-2008, 11:34 AM

I am using sp_helpindex to get the indexes of the database.......

how do i pass the parameter tablename as a parameter????....and
is the parameter a built-in or userdefined???

I used @TableName....which throws a exception saying "@TableName is not
a parameter of the database"

Thanks a Lot in advance

#2 (**permalink**) 03-01-2008, 11:35 AM

You can use sp_help to list stored procedure parameters and data types:

sp_help 'sp_helpindex'

This reports that sp_helpindex expects parameter @objname.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"frien" <001frien@gmail.com> wrote in message
news:1163472019.753512.139630@i42g2000cwa.googlegr oups.com...
>I am using sp_helpindex to get the indexes of the database.......
>
> how do i pass the parameter tablename as a parameter????....and
> is the parameter a built-in or userdefined???
>
>
> I used @TableName....which throws a exception saying "@TableName is not
> a parameter of the database"
>
> Thanks a Lot in advance
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

urgent help!!!!!