var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sp_helpconstraint problem
The BOL says that doing this:
will dump out details about the foreign key constraints above.
However all I get is one row in the resultset with the column "Object name" with the content "Ref_mytable387" ?
Is this a access security issue ? I'm logged in as "sa" in SQL2000. Thanks all.
Well I have never played with this before so I just tried it out...
When I run it against a table with constraints the first line is the object name line you meantioned then further down are the primary keys and foriegn keys that I have created...
If I run it against a table without contraints then all I get is the first line as you meantioned....
Does that help at all?? Are you sure the table you are checking has constraints??
You know what, I think it's the DB query tool that's the problem. I'm not using Query Analyzer. And this tool is probably just returning the first resultset and left the rest out.
Yeah, that would probably do it.