I used SQL developer edition in my pc.
By accident, I deleted some files in installed folder.
Now, I can not open management studio.
I tried to re-install it, but keep on telling me that components are already
installed.
How to fix it without uninstall it?

--
Message posted via http://www.sqlmonster.com

aspfun via SQLMonster.com (u53138@uwe) writes:
Hm, a good setup should have a Repair option, but the SQL 2005 Setup
may not have one. You could try using Add/Remove Programs and use
Change and see if this helps.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Actually, the SQL 2005 installer does have a decent repair option. However
it will leave the install at RTM. You will need to reapply any service
packs or cumulative updates after the repair.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote