Hi,

something like that maybe...

INSERT [YourTable] (columna, columnb, columnc)

SELECT [YourDate] , DATEADD(yy, 1, [YourDate]), DATEADD(dy, -30, DATEADD(yy, 1, [YourDate]))

I experience exactly the same problem.

I don't know if I'm doing something wrong... I also receive the SQLServerCentral.com Daily Update email on a hotmail.com account.

Yep, that's what I'm using now. So I guess there's not better/faster/easier way.

Thanks anyway.

hi,

thanks for your answer and sorry, I was not precise enough when I said I was interested in the "physical location of the DB files". I meant the current physical...