Depends whether you want a desktop or an industrial-strength solution. Interbase is fine if all you want is a small discreet desktop datbase solution similar to MSACCESS.

If on the other...

I don't know if this is an answer to your question, but VSS does not have to be integrated with your IDE for you to use it. In other words...

If your developers are using any kind of front-end (VB Delphi ASP etc.) encourage them NOT to do database work on the client side and particularly keep SQL scripts on...

Hi Richard.

One of the problems of ADO is that it encourages us to re-invent the wheel. Looking at your code I'm wondering why you need to work on the records...

I don't think you can, but I'd love to be proved wrong.

One way to solve your problem might be to split your big view up into smaller views, I.E. create...

Hi Rocware. Yup ORACLE To SQLKSWERVER has some interesting Gotcha's, triggers being one of them. More of a general answer than specific to your problem here are some pointers I've...

From BOL

There is no way to determine the sequence in which uniqueidentifier values were generated. They are not suited for existing applications that depend on serially incrementing key values.

At...

Thanks Brian

I'd sussed those procs, I was really after any known Gotcha's.

Well let's be brutally honest I was hoping that someone had a ready-rolled proc I could clone, why...

Check out DTS (Data Transformation Services) which offers, amongst other features, the ability to export data to text files (CSV or fixed-length) and of course to import.

There are other utilities,...

Hi Simon

Thanks for that, we'll give it a whirl, hopefully if it cuts the 7 second delay time down we're in your debt.

Graham

I have found it is possible to please...

If you use the EXECUTE method of the ADO CONNECTION object this takes Number Of Records affected as it's second parameter.

I have found it is possible to please all of...

Why do you need to load the temp table prior to your insert? Is it not possible to insert direct from T1 into T2 by using SELECT INTO (or if...

Boy do I agree that this practice is a Right Royal Pain. I agree that there is a apucity of testing. It would really pay these Vendors to include an...

We use VSS extensively. It may be a freebie but it's nice and simple and does a bussineslike job.

One thing I would reccomend if you do use it is...

Just an aside really on the query optimiser. SQLServer may not always use a particular index, if it deduces that to do so won't be too efficient, for example where...