ok that is what we will do.

Thanks

i will try with the wizzard.

Thanks

No, i used a backup / restore

and i found a lot of dt_xxxx sp.

Thank you Karl, it works fine!

woow, it s exactly what i was looking for.

Many thanks.

yes but my problem is to concatene this 2 columns from table a to a single column to table b

thanks, i will work around and give the solution when i found it.

when i scroll to db properties , permissions, add users or role, i cant see the login i am looking for.

I only have public and guest.

Strange!

In the security part, the...

yes in DB properties... i mean my DB called NETEQCRECETTE and i look at propertie from this DB. Correct?

i see "view any database" or "view server state" but i dont see "view database state". Sorry

its sql2005

with SA rights, the user see the log file.

Hello

it doesnt work.I affected the user to the schema DB_Backupoperator.

I must say it s a sql login not a windows one.

But it s trange for me

Brian,

thank you for the answer. Our SQL server is not in a cluster. The first step wil be to migrate the dev server and see what will happen.

yes the domains are trudted and all account have to migrate. But i dont know what will happen with all the DTS, moving, copying files from servers to servers....