even under english the second query will not work if you are using a binary collation.

We solved the same issue using an extended stored procedure.  The complicated logic of reading the registry and adjusting for the bias and the complicated daylight savings time logic is all handled...

when I do this I usually leave the identity field unchanged and use

the SET IDENTITY_INSERT command.

you can also use DBCC CHECKIDENT to change the numbering sequence as

well.

look at the following

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servtools_5cfm.asp

its doesn't affect access to the server.  the sql server process itself is just running under a different account.     I would recommend that the account be an administrator on the...

In order to perform bulk insert, the sql server service must have access to the network share.   If you are running as LocalSystem (the default), that will not have.  Change...

See the following article - its not a extended stored procedure, but involves returning a resultset.   I've generally opted for the extended stored procedure, because of the performance impact of...

One way would be to write an extended stored procedure.

Actually our code is written in OLEDB which does catch it.  I would run sql

profiler to see whether you are truly getting a deadlock or a lock timeout.  Its possible...

deadlocks occur right away.  The setting of the lock timeout may just increase (or decrease) the likelyhood of a deadlock. 

It throws an sqlexception.  in the errors collection look for...

not unless you convert it back to a date, which won't work for the dates prior to 1753.  I supposed you could wrap it in a udf and not support...

the issue is that some of the dates coming in from oracle are below the sql server min date (somewhere around 1753)

this query works

SELECT *  from OPENQUERY(ORACLE,'SELECT TO_DATE(''1/1/1900'',''MM/DD/YYYY'') FROM DUAL')

this...

Oracle can use casts to convert dates as well.

oracle doesn't have a datatype called datetime. OpenQuery is executed as a passthru query on the remote server.  Thats why you are...

Oracle supports a SUM OVER function that allows a rolling sum for a row.  Its quite flexible in that it can be used

to sum over all rows, or a...

It can be downloaded from Microsoft in various languages.

go to http://www.microsoft.com/sql/ and follow the links to the downloads pages.   It contains installation instructions as well for various languages.