Yes... but I want to make this task automatic. If my server fails, I need to rebuild the databases with the logins in order to make my software work again (windows...

*seems* to be... you're not sure yet?!

thanks for the quick answer!

Remi:yep, all on the same directory, on the same server. In fact, I'm doing an automatic database restore script and I'm checking to be sure that...

Thanks for the answer... it's good to see a nice developped opinion on the pros of identity!

Like Remi, I would like Celko's opinion on this one!

Or trying to tell if it's better to be a separatist or not... (I do hope someone understands this one

Ok... I thought that index seek was faster than index scan. Guess I still have to read about that subject!

Thanks everyone for your answers. It finally works today (first time in 3 weeks...

They called an external company to test the drive onsite. He...

Quantum DLT sdlt320 (scsi) on Win2k server with Veritas as the backup software.

We sent them the tape backup and send another one... which cause the same problem. Now they'll try tonight...

In Em, right-click on your database and select properties. Look at Date Created.

Note that there's probably a t-sql way of doing this....

Erik

Neither do I... thanks anyway

More specs (maybe we'll find something out of this...):

- I use Windows authentification (I run ITW on username Administrator)

- I run profiler on another computer than my sqlserver (maybe it's...

<We work hard on these, but mistakes are made. I'm sure all of you make mistakes at times.>

nope... I never make mistake

... the company you work for achieve their break even with the vending machine next to your office

thanks! exactly what I needed!

That was problem, my connection was not set to master!! It's now working!

For your information, here's what I did:

1) Backup DB + Log from server X (sql server) to server...