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...

You can use openquery and put the nolock inside

SELECT * FROM OpenQuery(server,'Select * from sometable with (nolock)')

There are a few interesting things there. first, I'll echo the recomendation the error gave. Run CheckDB on your database RAProd. There may be corruption. I hope you have a...

The database has an id of 7. Run SELECT db_name(7) to find out which that is.

Go into that database and run select object_name (1125769272) to find out which table

Why...

Sorry about that. I read in something that wasn't there.

I am interested in your experience with 2005, as mine has been exactly the opposite. I did a little experiment this...

Do not bother to include an "order by" because when the "merged" table has a clustered index, SQL server will automatically perform an order by.

Just a comment on that. If...

In SQL 2000 the seeks turn to scans only when the nvarchar is on the right hand side compared to a varchar. when the table is nvarchar and the sarg...

Cannot recover the master database. Exiting

There's your problem. Wiith the master db corrupt, there's no way SQL will start. May have been disk corruption. Might be worth while checking the...

Very odd. Local system should always be able to log on. does agent have the same service account?

Do you know a local admin account for the machine? (not a domain...