there is a primary key on both sides?

The service pack setup is the same for client-tools and server.

Client version:

Open query analyzer

Menu Help -> About

You can find the various build versions of sql 2000 at

http://www.aspfaq.com/sql2000builds.asp

could be a mismatch in servicepack level between your client-machine and the server.

from the books online:

AUTO_SHRINK

When set to ON, the database files are candidates for periodic shrinking. Both data file and log files can be shrunk automatically by SQL Server. When...

be aware that a field in a table can have a different collation than the default collation for a database.

1) find the query/command causing the trouble

2) check all the fields and their...

move the "AND weeklyuserscores.weeknum = 2" to the left join clause, otherwise it will be filtered out.

SELECT

    users.username

    ,weeklyuserscores.score IS NULL AS Score

    ,weeklyuserscores.absolutevaluescore IS NULL AS AbsoluteValueScore

    FROM users

    JOIN groupmembers

    ON users.ID...

Hello,

What kind of technology do you use ADO,DAO?

Anytime my passthrough gave an error Access notified me, unless on error resume setting is on. (in order to process the error in...

Could it be that the saturday backup job is still running because of the ongoing stored procedure?

Are you taking 2 full backups on saturday (one regular, one stored procedure after...

Hello

1. Are there any db parameters for configuring # of processes for the db, simultaneous sessions per user, idle_time for a session etc.

->So far I know this is a...

You can compare the execution plans with query analyzer. (Show (estimated) query plan.

I guess with literals the optimizer immediately figures out is it one date (index seek), with variables an...

declare @datelast datetime

declare @dateprevious datetime

set @dateprevious='20070101'

set @datelast='20070102'

/*find items that are in

inventorylast but not in inventoryprevious

*/

select inventorylast.SKU

,inventorylast.qty int

,inventorylast.invdate

from inventory inventorylast

where not exists

(select 1 from inventory inventoryprevious

where inventorylast.sku=inventoryprevious.sku

and ...

Probably needs some refining since you use dateadd

declare @datestart datetime /*start of period*/

declare @dateend datetime /*end of period*/

set @datestart='19990906'

set @dateend = '19990917'

select roomnumber,rate

from room /*check al rooms if in not...

Always mention the column names when inserting. In case someone decises the names have to be alfabetically sorted.

insert into Sep_92 (Regno,Payment) values (19,'2005/12/05')

You can rebuild indexes with DBCC INDEXDEFRAG OR DBCC DBREINDEX

Shrinking parts of the database can be done with DBCC SHRINKFILE

It is fine to have primary keys with "no meaning". Mark the other unique fields with unique indexes/constraints and eventually a foreign key so later on you still will able...