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

That's a difficult one to answer, Gail. I have been using Windows Authentication, with my first name as User (with Administrator rights) and a blank password.

Not what are you logging...

Well, the on-disk page structure and the in memory page structure are identical (afaik) so it should be enough to take 2 very large tables, with lots of columns in...

I've never heard that myself. Got a source? I'd like to check it out.

afaik, the position of columns within the data page has no impact on speed of searching. If it does,...

What account is SQL running under? (check services, from administrative tools.)

I believe it is best to have frequently searched fields of a static size early in the table

Why do you think that?

You can change the order of columns in...

And was there anything in the application event log from sql server at the time you tried to start it?

I saw your reply, but the answer to my question isn't there. When you tried to start SQL from the services manager and it wouldn't start, what error or message...