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

Look at using openrowset and inserting into the table not the view passing in the parameter.

INSERT INTO myTable(ProjectID,FName)

SELECT @ProjectID, FName

FROM OPENROWSET(BULK N'C:\Text1.txt', .....)

GO

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

bubby (12/3/2012)

---

I have to SQL Server and one has version,

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c)...