GO is a batch sperator.

So you could say

Do Something

Do Something Else

Do Something More

GO

Do Something Even More

Do Something Better Than Before

GO

And it would execute the first three things in one batch,...

If the certificate is a machine based certificate yes it would affect everyone, but it is more than likely going to be a user based certificate which is why it...

It looks like a certificate problem, I would ask the creator of the certificate to provide you with an updated certificate that you can install to the termserver as it...

Using backup and restore commands no. SQL has to restore the database how it was at the time it was backed up, which means you will always get orphaned...

Yes that is correct

Well how do you plan to format the INT into the required format as a VARCHAR to convert to TIME?

That is why INT cannot convert to TIME.

CONVERT(TIME,'01:05',1)

Just convert direct from a VARCHAR value, but need to ensure it is of the correct formatting for it to convert, '5' will not convert to time.

Int to Time is not allowed

http://msdn.microsoft.com/en-us/library/ms187928.aspx

is it every query or just certain queries

do you do index and statistic maintenance on all your databases

CONVERT(TIME,varcharcolumn)

My bad, you cant change the table collation, that should of been the database level, to alter a table you can change column collations

Drop all indexes on any columns which...

@kapil_kk

numeric columns dont have a collation.

@memymasta

collation can be changed at the server, database or column level depending what you want to do

Yes, full backups do not affect the transaction log chain, so you can do as many full backups you want a day and can still recover from any of them...

Moonshine