An insult to all paperclips!

I had exactly the same problem and got rid of it when I changed my sqlserver and sqlagent startup accounts to domain accounts in stead of local admin accounts. ...

Somebody has advised to store the text fields in separate tables which will be linked to the original table with the GUID key. Will this improve performance? It...

Nice link for when you have sqlmail problems:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886#1

You will probably find all you need to make this script in de backup tables in msdb - check backupset and backupfile tables.

Thanks again. And yes, the key is indeed a guid and will be changed in a next release. After more discussions with the developers it looks like the...

Thanks to all. After scheduling a job to do frequent rowcounts on the table, I saw that there are really many inserts being done. I advised them to change...

I used to use Codewright and loved it, but since I do little developement these days and Codewright is not used at the company where I am currently contracting, I...

Thanks Paul. Adding the users to the TargetServersRole indeed solved my problem. (If I look at the permissions for this role, I don't know how!, but it works.) ...

Yes, SQLserver was stopped - something which does not happen often and the logs are cycled every day and I therefor do not have any other logs to...

No, nothing in the eventlogs either.

This is it:

2003-05-08 07:40:22.08 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)

Dec 17 2002 14:22:05

Copyright (c) 1988-2003 Microsoft...

No, OS has been running for weeks......

And there are 12 databases on this server, but this 'check' was only done for 4 of them - db_options for these...

No, there are no jobs scheduled to run at startup and also no sp's which are executed at startup!

Problem solved! The startup account for the sqlserver service was a local admin on the server and not a domain account.

No, this is an NT domain, not WIN 2000.