When you try to create a new job in SQL Server Enterprise Manager and you try to assign a database for a Transact-SQL job step in Microsoft SQL Server 2000, only the master database and the tempdb database are listed.
Read More - Register for Free Membership