What port is SQL Server on PC1 listening on? If it's not the default, and if you don't have SQL Browser running on PC1, then you need to specify...

I don't imagine so, but I wouldn't swear to it. Somebody else may have an answer.

John

Have a read about cross database ownership chaining and post back if there's anything you still don't understand.

John

And what does that stored procedure do? Does it attempt to send an e-mail? Do you receive the e-mail if you execute the stored procedure outside of the...

So what happens when you try to send a test mail from Database Mail? Does it arrive? Does your job include an explicit sp_send_dbmail or is it just...

Rob

My intention was not to try to persuade you to use a natural key instead of a surrogate key as your primary key and/or clustered index. I do have...

Step 1: type set max server memory into your favourite search engine.

John

I don't know if this would work for you, but you could create the schema in the model database. Then it would appear automatically in all new databases.

John

Maybe you have an orphaned user. If you look at the properties of the user, what does it say next to Login name? If it's blank, try dropping...

Wow - that's a lot of indexes, and some of them looking very similar to others. I think I'd look at finding out which of them aren't used, and...

Sounds like you need to grant the service account the lock pages in memory right.

John

Mike

Where are those messages appearing? Are you getting anything in SQLAGENT.OUT?

John

Rob

I'm really sorry to hear about your health problems, and I hope it all works out for you.

It would really help if you could post the DDL for your table,...

Yes, it's been available since SQL Server 2005. Online index rebuilds are only available with Enterprise Edition, however. (At least that was the case up to 2008 R2,...

Ah yes, so it does. I'm running out of ideas now. How about creating a named local Windows account and seeing if you can start SQL Server Agent...