error:sp_MStablekeys
Brian Donahue
Posts: 6,590 Bronze 1
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!
>
>
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.