Yep, it came from Access! THanks a million, I'm in a mad rush..

This worked perfect:

UPDATE APTLocal.dbo.[User]SET PersonUID = '999999'

FROM ((APTLive.dbo.Person INNER JOIN APTLive.dbo.Employee

ON APTLive.dbo.Person.PersonUID = APTLive.dbo.Employee.PersonUID)

INNER JOIN...

Thanks for the good advice guys!

Brill! That worked..

I had changed the quotes to single quotes before, but got scared by the red text so didn't try running it.

Thanks a million 😉

Nearly worked! I got rid of the column, but now it gives me the error:

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'VOID'.

hmm..

PS: Thanks for...

Yep, the paths are all there alright. I'm not sure what you mean restore header only? So no, I haven't tried that..

Thanks for the reply. Yeah, I've tons of disk space.

Hmmm... I've changed that script accordingly and I keep on getting an error on that script saying:

Server: Msg...

Yeah, sorry I didn't outline it properly, but when I try and create the database via the restore procedure, that's when I get the second error.

Yeah, that's what I've been doing and that's what should work, but unfortunately it doesn't and all that happens is me getting aforementioned errors.

Does anyone know a script or some...

timscronin (3/13/2008)

---

On your PC are the sql client tools installed? If so make sure you have tcp/ip and multi protocol. Go to your server and make sure the...