| Walden Leverich 2002-06-28, 11:25 am |
| It appears that the database specified on the job step can
not have a space in its name if you are using a SQLServer
login for the user on the job.
I had a database called 'Resume Video' that I could not
get to show up in the drop down when using a SQL login.
However, if I renamed the database to 'ResumeVideo' and
disconnected/reconnected it would showup in the drop down.
If I renamed it back to have a space and
disconnected/reconnected it wouldn't showup. This appears
to be a problem in the engine itself, not just the EM
editor because a job created through TSQL won't run if the
database has a space in the name.
Has anyone else seen this? What is the MS response?
|