Hi all,
I'm using SQL 2K developer edition with SP3. (OS is XP)
I've one user database, which I'm detaching and
attaching. It works fine with Query Analyzer.
But when I use SQL's Enterprise Manager, it is
pointing to a log file, which is not existing and I'm
unable to attach the database.
What I'm thinking is:
The creator of the database may have created that log
file and may have deleted it. Now, EM is pointing to
that file.....I think...
Can anybody tell whether it is a bug or not?
'sp_attach_db' works absolutely fine in Query
Analyzer.
Thanks,
Siva.