In the time that it takes for someone to explain these you'll make speedier progress if you just look this up in BOL...look under "constraints - in database diagrams"...

Trystan - take a look at this...apparently you have sp3..

How to determine which version of SQL Server 2000 is running
To determine which version of SQL Server 2000 is running,...

what a remarkably astute observation...

hmm..when I do a "select @@version" this is what I get...

Microsoft SQL Server  2000 - 8.00.2039 (Intel X86) 
May  3 2005 23:18:38 
Copyright (c) 1988-2003 Microsoft Corporation
Developer...

Congratulations Steve! I stumbled upon this site a few months after it was launched and it was a great site even back then in its inception days (has it really...

In QA - set "tools" - "options" - "results to text"...and do

SELECT @@VERSION

Since there isn't a separate "time" data type (the time column without the date would be irrelevant anyway) I'd just have the one datetime column and then query using "convert"...

You could store the results of the procedures in a table and select from that table..!!!

- said it was curious because running the SQL asis resulted in "The select list for the INSERT statement contains fewer items than the insert list...." not the msg that...

sam - remove the first select...

INSERT INTO Person(PartyID, LastName)
SELECT p.PartyID,
       d.LastName
FROM   Client d 
INNER JOIN Party p 
ON 
d.ClientID=p.PKID

though the error...

This (very popular) question has been answered...

in this post!

Twice in one day - what are the chances...

rachna - vivek asked the same question and got a response..

here!

Hi homebrew01...have never encountered this myself..but have an easy solution for you...don't use EM!!

Mathew...just as an FYI - if you search the script section on this site you'll find several that do exactly what you want...and here's another post - sp_spaceused tablename...

Graham..EM picks up from the regional settings - if you change the date format on his pc you'll see that EM displays the changes too...