error:sp_MStablekeys

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited August 18, 2003 10:33AM in SQL Compare Previous Versions
Hi Matt,

Having had a look at this stored procedure, I can tell you that @indid
is not an argument that gets fed to the stored procedure; it's something
deep inside the SP. According to the comments, it's part of a routine that
gets the index id of a constraint. It may help to find out which table is
generating the error and drop and re-create the Primary Key on it.

Regrads,

Brian Donahue
Red Gate Software Support

"Matt Mitchell" <mattm@edpi.com> wrote in message
news:w9Zz2bzYDHA.1284@server53...
> When running a compare, I am getting the error message: Assert Failed:
> @indid is null in sp_MStablekeys (pk/uq)
>
> If anyone has any ideas on how to remedy this, please let me know.
>
> Thanks!
>
>
This discussion has been closed.