I agree with matt.  In a relational database, a Primary Key is simply a unique (hence non null) row identifier.  Indexing is an implementation issue.  But since the RDBMS must check that the PK...

How about prior convictions being positive indicators?

eg This applicant has speeding convictions, maybe they have been picked up for possession of cocaine.  But the job's for CEO,...

I agree that a record establishes only that there might be some interesting questions to resolve.  But what if it a conviction for violence came from a time when the person...

Don't forget RAM - Server 2003 Standard can use 4GB, but SQL Server 2000 Standard will use 2GB of this at most.

"The /3GB switch in boot.ini will allow SQL Server 2000 Standard to use 3GB RAM on a 4GB server."

All the references I can find say that > 2GB support is available...

You don't say what OS, which is relevant to the amount of RAM the computer can use.  But whichever OS it has, SQL Server 2000 Standard will only ever be able...

I would second (third... fourth...) all those comments so far about keeping it clean and simple, avoiding irritating animations and pointless fancy flashes.  And those that praise the current simplicity...

I agree that some threads vanish just where you want to know "Yes - and then what...?".  At the risk of sounding like a Project Manager, this one has been a...

I sympathize with you over the slow performance of text - we use a Third Party database that grinds exceeding slow when you select the text column.

All that advice looks...

From my dim recollection of managing user permissions under an NT domain, the principle was

1. create a Local group on the system where a resource (eg SQL Server) exists eg L_DBNAME_READONLY
2. grant...

The usual with XP is to check you have all the permissions you need - you are running the install with local Admin rights...?

I'd be surprised if it's MDAC (though that's...

Not replication, but you could use the trick I've used recently:  redirect the SQL Backups from the NT server to subdirectories on the 2003 server, and restore from those backups.  I...

Filegroups are not my thing because I don't run massive databases.  15GB is far from massive, and personally I would not worry about managing data placement for a database of that size,...

Can you log on to the box as local administrator?  The local admin proabably has SQL Server sysadmin permissions from BUILTIN\Administrators.

I have a colleague with exactly the setup you suggest for use at home.  He browses in safety, because as soon as he kills the virtual session the "PC" just vanishes.

But as for the practice of keeping...