Hi Gurus,

I am attempting to install KB970892 on SQL Express 2005SP3,
and I am unable to do so, due to a SQL suspended installation.

When I try to continue the installation (which I have no idea what is it trying to install - I have inherited this server the way it is), the following errors occur:

"there is already an object named 'sysmail_update_profileaccount_sp' in the database"

followed by

"there is already an object named #InstMsdb in the database"

and the installation is unable to continue from this point.

I have tried searching the web and forums but no answer ..

Any leads will be greatly appreciated!

Thank you,

-Ishay

probably a bug in the patch, authors probably didn't checked if newly created object is not already exists.

Hey VIeditorlover,

How would you suggest I go about finding the already existing object? or even just its name and location?

Thanks,

-Ishay

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.