Re: Rule disappeared

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Arne (Arne_at_discussions.microsoft.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 06:11:04 -0800

Sue,
I executed the two command that you suggested. There seem to be another
hidden constraint that I can't find.

"Sue Hoegemeier" wrote:

> Are you sure it's a rule you are looking for? If you used
> the upsizing wizard, it should have implemented this as a
> constraint.
> What are you using to manage SQL Server and where are you
> looking? You really don't want to address this by modifying
> system tables.
> To view information as well as constraints, rules on a
> table, you could execute:
> EXEC sp_help YourTable
> To check for constraints, you can execute:
> EXEC sp_helpconstraint YourTable
>
> -Sue
>
> On Wed, 19 Jan 2005 08:51:06 -0800, "Arne"
> <Arne@discussions.microsoft.com> wrote:
>
> >I seem to have a rule on one of my columns which prevents me from entering a
> >value above 25000 in an integer column.
> >I am not able to find the rule so that I can delete it.
> >Is there a system table that I should look for?
> >This table was upsize from Access to SQL 7.0
>
>

Relevant Pages

  • Re: Foreign key constraints problem in SNC SQL Native client
    ... it in differant way. ... application - take these statements and execute them using any other query ... configuration to also generate a constraint error since you cannot delete ... schema to compensate for this (using an instead-of trigger or defining the ...
    (microsoft.public.sqlserver.connect)
  • Bug in SQL Server 2000 sp3?
    ... Project nvarcharcollate database_default not null constraint ... If i execute the statement ... I get the following error (and no record shown in the result grid) ...
    (microsoft.public.sqlserver.server)
  • Re: How to disable a precedence contstraint
    ... "Allan Mitchell" wrote: ... path by disabling the steps of the path I do not want to execute. ... The last task in both paths have a constraint that points to the ...
    (microsoft.public.sqlserver.dts)
  • Re: Selectively executing steps disablestep
    ... >I have a package with many steps. ... >Each step's DisableStep property is valued using an INI ... >The idea is if I only want to execute the odd numbered ... Since disabled step does not match an On Completed constraint, ...
    (microsoft.public.sqlserver.dts)
  • Re: How do I incorporate a stored procedure into a select statement?
    ... EXEC sp_serveroption 'Server', 'Data Access', TRUE ... EXEC Member_Login_Delete @LoginID, @Type ... CompanyName varcharNOT NULL CONSTRAINT DF_Member_CompanyName ... CONSTRAINT PK_Member PRIMARY KEY CLUSTERED (MemberID ASC) ...
    (microsoft.public.sqlserver.programming)