Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2008
>Hello all
>
>I've got two tables (TestResult and IndvStats) and a generic userid.
>
>Userid has Insert, Update and Select rights on both tables.
>
>The only difference between the two tables is that TestResult has two fields that are defaulted to 0 on new record insertion.
>
>Userid can insert into IndvStats, but not into TestResult. Would these two field constraints cause this? I'm going to remove the constraints and see if that is indeed the issue, but if so - Why? And if it doesn't make a difference, has anyone seen behavior like this in SQL?
>
>Thanks
>
>Dorris
check triggers
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement