Remove them from the create table and alter the table as below:

Alter table dbo.tblRentalContract add

Constraint C1 check (ReturnDateTime > PickupDateTime),

Constraint C2 check (ReturnOdometer>PickupOdometer)

See the topic "constraints, overview" in BOL for...

You should be able to remove all of the registered servers from the client machines by editing the registry on each machine.  Then you can set permissions on the appropriate...

Actually the answer is the only correct answer.  It can set the victim, given the right circumstances.  Or perhaps a lack of the wrong circumstances.

The answer flies, but just barely. ...

SQLBill...

By "Fun for All", I meant "Fun for Me and at least SQLBill".  Looks like you and I got bit by the same BENT bug.

jg

I'm using Veritas NetBackup 4.5GA MP6 for SQL backups.  It works just fine.  It is tricky to configure backups just right, but once they're on tape, I have never had...

It's not so bad to forget the where clause, as long as you forget the commit.

jg

Open REGEDT32 and list out the permissions on the key (under HKLM/Software/ODBC/ODBC.INI) that matches the DSN that doesn't show up in the system DSN dialog box.

Compare that list with the permissions for one of the DSN...

the procedure that I use is quite simple:

Go into EM, right-click the database and select properties.

Click the Transaction Log tab.

Select the secondary file.  Press the Delete button.

Accept the confirmation.

You're done.

Did you try checking the registry permissions?

Hello,

I think I've seen this one.  Good thing you mentioned Crystal, because that made me remember.

Installing Crystal Reports v8 breaks your computer, but there is a fix:

http://support.businessobjects.com/library/kbase/articles/c2007581.asp

You can either d/l their...

And I do mean "In the list of performance objects".  :o)

Hello,

In the list of counters, there should be a SQLSERVERNAME:Buffer Manager object.  The PLE counter is in there.

Jeff

Jan,

can you tell us if you are using mirroring?  You mention 3 drives, which sounds like you are using striping.

If you are mirroring, then the other drive should have a...

Hello,

I would look at the Page Life Expectancy counter.  If it stays above 300, then you don't need more memory.  If it drops below 300, then you do. 

And that buffer...

I wish you luck.  I remember seeing exactly that:  DNS lookups, even internal ones, didn't work when the Internet connection was down, due to a misconfiguration.