SQL native backups are ineffecint.

I have also tried red gate backcup. it was ok with me.

I had the same issue. It didn't resolve until i re-install the sql server.!

I don't think there is an issue with timstamp column. check the other fileds

Jan,

sorry UNION will not if you have 100 columns. even UNION will slow doen the things.

In that case Frank method is ok

Sorry about it!

As far I know, you can only load .dts files. I will check the net and let you know

We need more explanation than this.

At what point do you want to save and delete the dts

Most safest methos would be adding a columna s you said. Substring method does not gurant that it will not return same code for two differetn countries.

select id,order1 from od union select id,order2 from od union select id,order3 from od

CREATE TABLE [AA] (

 [SentDate] [smalldatetime] NULL CONSTRAINT [DF_ADS_RemitanceTransaction_SentDate] DEFAULT (getdate()))

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

oops!!

sorry I didn't know

oh! sorry for the mistake

is field1 your primary key of the table?

I think you are refering to identity filed

so you start with

SET IDENTITY_INSERT [dbo].[Transactions1 ] ON

YOUR CODE

SET IDENTITY_INSERT [dbo].[Transactions1 ] OFF

Check this

http://www.sqlservercentral.com/columnists/dasanka/findminmaxvaluesinaset.asp

in the next version o fsql server this can be done much easily