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

Sounds like you might have to do it manually, then. Try creating a login for your domain account and adding it to sysadmin. Then use SQL Server Configuration...

If it's a single transaction that's causing the log growth, increasing backup frequency won't help. You'll need to rewrite the transaction or ensure you have enough disk space to...

Something like this:

SELECT 'USE ' + name + ' EXEC sp_addrolemember ''db_datareader'', ''myusername'''

FROM master..sysdatabases

That will generate the SQL to add the user to the role in each database. This...

You'll be looking for the COALESCE function.

John