Since you're not using a where, you will get limited improvemetn from indexes. I would suggest, as a first pass, put indexes on the foreign key columns. It may not...

It's going to be my file and database server, as well as a backup site for stuff from my desktop.

I do computer graphics as a hobby, so I have...

Just bought myself a server, with 4 160GB drives. I'm going to set them up in a RAID 5 array. That will give me a nice total of 480GB on...

SET SHOWPLAN_ALL ON

GO

<your query here>

You won't get results, just the plan in text format. Then you can use any search function (including the one in management studio/query analyser) to find the...

Using float for financial values is a bad idea. It's an inaccurate data-type and you may well get rounding errors.

Use either numeric or decimal and set the scale high enough...

I haven't worked with Access for several years, but if I recall, those queries should be executed client side, not server-side.

Can you please post the exact error, that way maybe...

It's the data source for a form? Is it set as a pass-through query?

What error are you getting?

OK, that makes a bit more sense.

Where is that query? Within a report/form/object data source? in a stored proc?

What's the error that you get?

Drop them and recreate with the new name. Constrants (primary key, unique, foreign key) are objects themselves and don't depend upon the tables for their names.

Your indexes also won't have...

I have attached an access database to my SQL Server 2005 as a backend

Please clarify what you mean by this. SQL Server is a backend database already. Do you mean...

Where the item no doesn't start with RA, or some other field. I'm assuming the first. If it's another field you want to filter on, then replace Item_No with that...

SQL does not keep any form of log of logins, unless either the option to log successful logins to the error log is checked, or the server has c2 auditing...

That's interesting.

I'll take a look this weekend, if I get a chance, see if I can find a way to trigger it.

Are you sure a DDL trigger won't tell you? Changing a column name is an alter table statement, so it should get caught by a ddl on alter table.

As Lynn said, if depends on how the table is queried. If most of your queries filter on CompanyID alone, or LocationID alone, then you will want two indexes. If...