I have got a similar problem. You have to change a registry entry because of the default bahavior of ADO which checks the first 8 rows of the excle file...

Brenna's solution looks to be the way to go.

As an another alternativ could be a left join approche where you could have the shift table as main table and the worked and...

Very nice summery, Mike

I wouldn't think aboput how to disable an integrity constraint. This is just doing its job (and it does it quite well in your case

If you have to insert the data almost in paralell into 2 different servers (which I wonder why) I would modify the data entry...

What about merge replication?

But if you want you can check the sysobjects and syscolumns tables in your databases to find a difference if you do not want to spend money for a 3rd...

Have a look on this topic where I've got the same problem: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=192093

Sufian,

As a general remark: This forum is a peaceful place where people are coming for help and the members are helping by their experiences.

So don't be agressive with us!

Here...

Maurice,

Take care by using the backup log <database name> with truncate_only command because you will loose the possibility to restore the data if your database is not in a simple recovery...

Guys!

This is not the way to go! If he is doing a log backup every 2 minutes then of cours his recovery mode shouldn't be set to simple. Otherwise it...

Also do not forget thw maximum size of all columns of a row is 8060 bytes.

So if you have a column which is declared as a varchar(8000) and if you...

select * from master..sysperfinfo

will give you access to the SQLServer related counters

SQLServer SP or trigger is a server side object.

What you want to do is call a client side object out of a server side one. And this is IMHO fundamentally...

You know, Rémi, this is exactly my issue why I was raising this topic!

This is a dilemma for me, because storing the data in a filesystem takes almost no ressource (beside...