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

You're very fortunate to have this problem on the day the latest article in the transaction log stairway[/url] is published.

John

That will always make mistakes since you haven't declared @where.

To solve your problem, please search this site for "running totals". You should be able to find something that you...