Are you getting any error messages?

From the last bit, I get theimpression that you've just updated the script to use SPs instead of statemnets?

So, how would you manage getting updates to your server? If Firefox is a user app then so is IE.

AFAIK there is no reason why you should NOT have...

I always use the restore wizard for this.

So long as the filepath matches the existing target database, and you use 'force restore', it should be fine.

-c is for command line though....

can EM start and allow the master database to be restored, even in single user mode? There has to be some point to starting from...

well, going on BOL(2k updated):

How to restore the master database (Transact-SQL)

To restore the master database

Start Microsoft® SQL Server™ in single-user mode.

Execute the RESTORE DATABASE statement to restore the master...

hope this one had an xmas theme.

which is probably why they shouldn't htmlencode in the first place, since its a link. But we're wandering offtopic here....

Since I humbly submitted this QOD, I'll pitch in my bit.

Yes, Access is horrible for the purposes of being a back end database, and it gives out some funny limitations....

Well, if the questioner had thought about it, and done something a little more subtle... like stuck a NULL somewhere...

Oh! just checked the running total, and a few now think...

but a bit of light relief all the same....

..pity the two who've got it wrong. Read the detail, guys!

hey - no worries!

Kind of surprised that no-one else had picked it up, but there you go. There seems precious few threads on web/sql with this kind of line....

that was kind of my line of thinking, Frank, but it'd be useful to know (judging by the quoted lines of statement) whether its been anywhere near Query Analyser.....

did you get anywhere with this?

Speaking from having done this myself, and having several years experience of such development work, how are you doing the sql debugging/scripting?

corrupt file on the sql install, possibly?

version/sp? os? etc.