Error 15123

When trying to use the generate SQL Wizard, I get an error

Error 15123: The configuration option 'user options' does not exist, or it may be an advanced option. Valid configuration options are:

This just started happening this week. Does anyone have any ideas?

That error normally pops up when you're trying to use the xp_cmdshell function, but it doesn't seem like you're doing that. Can you think of anything that may have changed just before it quit working?|||To my knowledge there have been no changes to that server for awhile. It is a development server and has more hands in it than Carter has pills. I was hoping for a "oh, you shot yourself in the foot this way". We did have an event where we were keeping too many backups and filled the data disk and caused some hiccops in another area. Is there a possibility that something got corrupted? I know the values are in the tables, I traced that back and compared with this server's test counterpart.|||To my knowledge there have been no changes to that server for awhile. It is a development server and has more hands in it than Carter has pills. I was hoping for a "oh, you shot yourself in the foot this way". We did have an event where we were keeping too many backups and filled the data disk and caused some hiccops in another area. Is there a possibility that something got corrupted? I know the values are in the tables, I traced that back and compared with this server's test counterpart.
|||It's possible. Sometimes I try to move the error around or force it, so one strategy might be to back up the DB and restore it on the same or another server. Alternately, you could use the database copy wizard to copy to a new DB and see if the problem forces itself out somewhere.|||The error happens on all databases, so I did detach one of the dbs and copy it to another server. The problem did not follow the db. I figure, we get through this one project and then rebuild the box.|||

Wow - very odd. I wonder if it's a file-locking issue at the OS. In any caes, I'm glad that worked for you. Let me know if I can help in any way.