Really stupid things in my junior dba-years:

Dropping the wrong table in a 40gb database. Sure I'm on the testserver.

Update without where clause (where's my history table)

Merry Christmas!

You could recreate the view on the serverbackend and relink the view afterwards in Access.

This should be done whenever underlying datastructure changes, since views in sqlserver keep the definition of...

You can union both results together

select EmpID

,LName

,FName

,Role

,FileID

,FileNo

,SectID

,AttyID

,FileName

,DateOpened

,Dept

,Status

,Desc

from employees

inner join files

on empid=sectid

union all

select EmpID

,LName

,FName

,Role

,FileID

,FileNo

,SectID

,AttyID

,FileName

,DateOpened

,Dept

,Status

,Desc

from employees

inner join files

on empid=attyid

order by empid

Is the table definition in Access updated?

Thanks for providing the sample data.

I didn't find anything odd in query analyzer (still the same 13 records)

Yet some notes:

*The view uses TOP 100 PERCENT

This can be removed as sorting...

Could you post some sample data and the query to recreate the problem?

Odd that adding an index would cause duplicate records to appear.

Sure that the query is built correctly?

Hello,

I haven't coded in .Net since long.

Just some checks to narrow the problem area

Excel file imported:

Does the MessageBox.Show("The import is complete!", "Import File", MessageBoxButtons.OK shows up? (Excel file...

Back again.

What works:

Allows: swapping in a single update

Disallows: swapping in 2 separate updates

Sample data devices:

pk 10 , sim 10

pk 20 , sim 20

Allowed:

update devices

set simid=sim

from devices

inner join

(

--setting multiple values...

Cheers!

About the non-clustered index on device.simid.

By default, when you create a foreign key, sql server doesn't automatically add an index on both columns involved in the master-parent relationship (at least...

Autogrowth is recommended be a fixed size instead of a percentage.

A monitoring script for database-size should be in the scripts-sections.

Hello,

If you wish to restore a database to a point in time you will need

A full backup to restore from

+ A differential backup to restore from (optional, contains all...

Hello,

Thanks for the sample data. It was great for testing.

Columnnames can vary.

I would implement it via a foreign key (validation) +trigger (preventing duplicates)

--check if sim is valid using...

Are the new records inserted in "Tom" or is there replication involved (possible delay)?