The perform volume maintenance right is needed to enable instant initialization - probably not your issue though.

You are already looking at the things I would focus on.

What is the datatype for the id column?

Are you running Standard or Enterprise Edition?

Do you have lock pages in memory right set for the service account?

Do you have perform volume maintenance right set for the service account?

If...

This is not about the server having access, but the login matching the domain account. If the domain account is all uppercase, and the login is not - you...

For some reason, that instance of SQL Server (or that system) is having problems communicating with the domian controller.

When an agent job starts up and is owned by a domain...

I would probably go with a third option:

Create a separate instance of SQL Server for each one. This would keep each database in it's own instance, with the same...

A global temp table will only exist as long as there is a process accessing it. My bet is that once your process completes, there is no active connection...

Instead of writing your own search utility, go to Redgates site and download their free SQL Search utility. This will search all objects in the database - or system,...

The issue with updating statistics after a rebuild is that it will update statistics that were just updated by the rebuild index task.

Instead of using the update statistics task in...

You need to check the windows event logs to see why the server crashed - or if the server was shut down and restarted.

If there is nothing in the SQL...

Would you mind posting what the problem was and how you solved it? It could help someone else later on.

Because a table name cannot start with a number, unless you quote it. You can quote it using either brackets or double-quotes. For example:

ALTER TABLE [3NF_Medarbejder] ALTER COLUMN...

You need to separate out each call using the batch terminator GO. So you need:

SELECT ... FROM ...

GO

ALTER TABLE ...

GO

SELECT ... FROM ...

GO

djackson 22568 (3/13/2011)

---

OK, for all those others who seem to have this issue, I was able to figure out what the cause was.

First, one MS article suggested issues with SP2....

You should not have any data in the model database - that is the database the SQL Server uses to build tempdb and as the 'model' for new databases that...