|
Posted by Dan Guzman on 11/14/06 12:28
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.googlegroups.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
>
Navigation:
[Reply to this message]
|