I'm not quite sure what you mean by only addresses are in the form of. That is an active directory string that will relate to the object in active...

What is the default database for the login?

SELECT default_database_name

FROM sys.server_principals

WHERE name = 'MSSqlDB2K8\sqlsrvAcct';

GO

Is the database online and in multi user mode?

Cheers

Chris

In short No. The below script will prove this. There is an great book by Kalen Delaney that explains locking in great detail. Link below;

http://www.sqlservercentral.com/articles/books/93946/

-- Set database...

I can't think of a reason why you wouldn't want to make use of database mail. I enable database mail on all the servers in our estate as part...

You can fail the database on the principal to the mirror make the change test it and fail the database back to the original principal.

Cheers

Chris

The query and job should run without error, as for why you have NULL values I don't know why you have them. If you run the SELECT without the...

I imagine ghost cleanup is run when you migrate as some part of the recovery process trigger it. It may be worth posting the question on twitter using the...

That will certainly impact recovery time, Below is a script that will create a script to update the initial log file size and the auto growth settings based on the...

You can run SET STATISTICS IO ON before your change, execute the query and review the results in the messages tab. Then run DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS to...

If you run DBCC LOGINFO('DatabaseNameHere') for the affected database how many records are returned?

Each record is a Virtual Log File (VLF) a high number of VLF's would impact recovery time.

Chris

If I understand you correctly, when you can't connect the services are not running? What happens when you start the services, can you then connect?

Chris

Rather than selecting into your temporary table have you tried creating the temporary table and specifying NULL in the definition of the column that fails in the error message you...

True, good point.

Just create a foreign key between the audit table and source table on that column that will do the trick.

Chris

Great news, that is what we are here for 🙂

Chris