Seriously go and redefine the design of the database.

Add A and C to T2 and then create a foreign key, or create some kind of identifier on T1 which is...

Is there already a PK on the table? Are the values of ColB unique or is there a requirement going forward which means that you can have the same...

Is the data in the database static or does it change? Also what is the turn around time from you providing the backup for the 3rd party to do...

No, if you want relationships they should be done via FK's, I would seriously go away and re-think the design on this one.

Either create a unique constraint on T1 ColB or add in ColA and ColC to T2

Why do you not want to use the built in SQL mail procedures?

One way would be to build a CLR proc which does the sending of the mail for you.

The problem is that this is RBAR as your only ever updating 1 row at a time instead of trying to update 566787 records in one set based operation, meaning...

If SQL doesn't start it will tell you why in the Windows event viewer, if a DB doesn't start it will be in the SQL error log.

As Perry has already...

depends on the query.

you will need to elaborate a lot further to get a more detailed answer, is it one particular query, what is the query doing, do you have...

look in the sql and windows logs

Backup restore is stored in MSDB, in the restore history and backupset tables and many more.

Some DML (Insert, Update, Delete) is stored in the transaction log, assuming you have bulk...

Maximum key length for an index is 900 bytes, as ntext can store up to 2GB you cant index it

sys.dm_db_index_physical_stats is not an SP its a DMV and depending what DB_ID() you pass in for the first parameter it will look through that DB for index fragmentation.

Take a look...

The only way would be to change the column to NVARCHAR, collation changes may work but then you introduce a whole host of potential problems as certain characters will change...

All down to the code page and ASCII conversion.

select ASCII('š')

select ASCII('c')

The first returns ASCII code 154 which is the correct code for that character, but the latter returns ASCII code...