In addition no user can be connected to the read only database while a log is trying to restore. It will cause log shipping to fail.

Log Shipping is not a...

Strings usually can be implicitly converted to a datetime, but since your table does not have the correct data type it is possible that you have bad data.

so...

create table #test...

No that is exactly how to do it.

It is actually very fast, and will not cause much additional overhead.

you need to try to make all of your triggers allow multi insert, it will only cause problems later if you don't

Try

Create trigger trinsTable

instead of insert on Table...

Try DATEADD(dd, 2, getdate()),

I cannot test, but often times passing a value to...

Use the Case function

Something like?

Select IsNull(p.firstName+ ' ','') + IsNull(p.MiddleName+ ' ','') + IsNull(p.LastName,'') as 'Player',

min(case when DATENAME(WEEKDAY, rzd.Date) = 'Monday' then rzd.Total end) as 'Monday',

min(case when DATENAME(WEEKDAY, rzd.Date) =...

Try This

Select idNo, RefNo

From TableA

Left Join TableB on TableA.IDNo = TableB.IDno

where TableA.cty='NY'

  and TableB.IDNo is NULL

I'm not exactly sure what you are asking.

Check your servers language setting

From Books Online

SQL Server Language Support

Microsoft® SQL Server™ 2000 is installed with 33 natural languages defined...

Something Like

select VoterId, a.QuestionText, coalesce(A.AnswerText, b.AnswerText) as AnswerText

from Tab1 a

join Tab2 b on a.QuestionText = b.QuestionText

              and a.VoterID = b.VoterID

For your example the # of columns in the table need to exactly match # of columns in the file.

If your file looks as you have posted, then there is...

Have you tried Books online?

http://msdn2.microsoft.com/en-us/library/ms188365.aspx

Do you have a specific question, issue?

Edit:

http://www.sqlteam.com/item.asp?ItemID=3207

Are you getting an error?

I don't see enough information to help U.

You need to use alter view statements.

and or use the replication procedures to modify schema.

http://msdn2.microsoft.com/en-us/library/ms151870.aspx

What is the file that you are using?

can't you open the file in Notepad?

If not, then open the file in word, and select Saveas, and change the format that it...

What is the datatype of the Processos.Dataabertura field and the processos.horaabertura field?

Also can you post some sample data of what works, and does not work?