You can put the Convert into the join expression to evaluate simply based on the day instead of the day-time initiallly represented by a smalldatetime value...

Declare @Dateparm smalldatetime

Set @dateparm =...

SQL Server doesn't come with very good tools to do this....

If the database(s) is not too large you could script out the DB structure (generate SQL script, including the create DB...

If the in-house users are not having any problems, I would first verify if the "timeouts" the remote users are getting are truly Access timeouts. Try to replicate the error over your...

Use xp_cmdshell...it's much easier than using the sp_OA procs...

ciao ciao

Eoin,

I'm afraid that it is not possible to go back via the GUI and comprehensively update the columns selected in your DTS packages without doing it one by one.

Do...

Are you saying that you are supposed check the CRM system to find out if the attributes of the product you sold match the attributes of the product you put...

First, I should say that I can't endorse the use of cursors, but that is really a 'do as I say and not as I do' sort of thing. Second,...

1. Make sure the table has an appropriate clustered index...this will physically order the records and greatly increase query performance. This site has plenty of good pointers on indexing...search for...

You need to identify the event that will flag an insertion as a success or a failure. This could be by using @@RowCount (telling you how many records were affected...

Honestly, I think the DTS method is more complex (and clearly slower) than it needs to be. I pull alot of data over from Oracle into SQL 2000, and this...