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)...

Do not cross post it fragments replies

http://www.sqlservercentral.com/Forums/Topic1391939-1550-1.aspx

Sounds like you need to do some transaction log management.

What is the output of this query

select recovery_model_desc, log_reuse_wait_desc from sys.databases where name = 'testdb'

And some reading material

Managing Transaction Logs -...