Make sure your SQL agent is setup to use SQL Mail. http://msdn.microsoft.com/en-US/library/ms177408%28v=sql.90%29.aspx

Create a SQL Agent Operator, http://msdn.microsoft.com/en-us/library/ms175962%28v=sql.90%29.aspx

Then in the job where you want the email to send, select properties, Notification...

Turn off power

Wait for screams

Turn on power

Organise outage window with screamers

Move server

😀

It's used when creating a CLR function, the reserved word EXTERNAL is part of the reserved phrase "EXTERNAL NAME"

See books online example from http://msdn.microsoft.com/en-AU/library/ms186755.aspx:

DECLARE @SamplesPath nvarchar(1024);

-- You may have to...

Post the execution plan, you might be lucky and have a 80/20 rule problem which someone can quickly solve. (long shot though)

Add COLLATE_DATABASE_DEFAULT on all your joins and where clauses..

or change the database collation, its all here: http://www.sqlserverclub.com/articles/understanding-sql-server-collation-sequences.aspx

I'd like to question if it is actually running as sa.

Is it the same if you use sys.dm_exec_sessions rather than the old sysprocesses?

Also can you write the current security context...

Deferred transactions:

http://msdn.microsoft.com/en-AU/library/ms188290.aspx

How did you fix the underlying disk issue? Was the database restored from backup?

Did you check replication monitor? Seems like you did but didnt specifically mention it.

That or

select * from distribution.dbo.msrepl_errors order by time desc

Also regarding permissions, is the service account different...

Why would you use SQL 2008 to print a file?

You've typed most of the code, why not run it and try it? Turn on "include actual execution plan" and create and drop indexes to test

create table Table_A (A_id...

Not sure if this is what you're after, but here http://zainuvk.blogspot.com.au/2011/09/hise-username-and-password-with-sqlcmd.html

discusses using a Windows environment variable to input a default user and password so that they're not specified as...

Apart from manually going through HKLM\SOFTWARE\Classes and looking at each CLSID, you could try the suggestion on this page which uses a tool and lists the CLSIDs which can be...

The account provisioning section is referring to administrator within the SQL environment, not your Windows administrator. So it's asking for any account that you would like to have administrator...

In an enterprise environment you would create an account specifically to run those services separately from your login account. In your case, since it's running on your desktop machine,...

Yes that's correct, completely uninstall that instance, then reinstall but ensure you select the Full Text Indexing feature during installation