Validation Text

From: Chris (chris.charlesworth_at_national-ice-centre.com)
Date: 06/14/04 

Date: 14 Jun 2004 09:38:32 -0700

Hi, we are upsizing from Access to SQL Server 2000

I have set up constraints for a table in SQL Server 2000 Enterprise
Manager, The consraints are only simple ie: ([Surname] is not null) we
are using Access as the front end and i have noticed you are able to
specify the validation text if the above constraint is used - for
example I can enter the validation text as 'please enter a surname'
Then on the enrty form, users can see clearly what they have not
entered.

Unfortunatly this validation text will only work for the dbo. Any
other users just get the basic SQL error message.

How can I re-create this at in enterprise manager / query analyser so
that it will always produce a specific error message.

Thankyou..

Relevant Pages

  • Replication Problem
    ... I've registered the Remote Computer in my Enterprise ... "SQL Server Agent on 'MyComputer' currently uses the ... how can I use Enterprise Manager ... from another computer to configure Replication Scenario's ...
    (microsoft.public.sqlserver.replication)
  • Re: Nevermind: Problem Between the Chair and the Keyboard
    ... There is a situation where you can end up with deleted data from Enterprise ... If you increase a constraint level in a table using Enteprise ... Manager, and then apply the script that the table designer creates, you can ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Launching Enterprise Manager
    ... I uninstalled and deleted the SQL Server Enterprise ... Manager file that was causing the message. ... I cannot launch Enterprise ...
    (microsoft.public.sqlserver.setup)
  • Re: Kann Wartungsplan nicht korrekt erstellen
    ... > überhaupt in den vorhandenen und mit SQL Server erworbenen Enterprise ... > Enterprise Manager zusammen? ... Next by Date: ...
    (microsoft.public.de.sqlserver)
  • Re: SQL 2005 Tools
    ... I have tried my best to warn the manager who authorized this sort of work. ... and I need to know how to use this thing to connect to the database remotely. ... I have already forwarded TCP port 1433 and UDP port 1434 to the SQL server ... a clumsy or inept developer (or ...
    (microsoft.public.sqlserver.connect)