Welcome to the Gonzo TechNet pages for Microsoft SQL Server versions 2000 & 2005. Due to the Microsoft policy of providing minimal instruction with maximum confusion, I've developed my own set of cheat sheets to enable me (and you!) to complete the daily duties of a Database Administrator. Hopefully, the will shed some light on what you need to accomplish and how to actually do it.
Below are links to answers for some of the problems I've run into over time. Feel free to use, plagerize, copy, and mangle at your discretion.
I might be wrong, Microsoft is constantly changing things, objects are closer than they appear, results may vary depeding on mileage, my dog told me to do it that way, someone else has a better way, Jesus was a spaceman, the book I stole it from is out of print, etc., etc...
Did that cute traffic light icon/gizmo that you use to stop and start the SQL Server, SQL Server Agent, & MSDTC service disapper? And now you can't find the link to the program that starts it. Ok, make sure you have both of these:
The ".rll" is a resource linked library and the ".exe" is the actual program. When you find them (or copy them back to their directory if you deleted them) create a shorcut in your "Programs\Microsoft SQL Server" menu folder for "Service Manager" and point it to the .exe (Don't forget, surround it in QUOTES!)
Issue: Can't modify or delete a SQL 2005 maintenance due to error:Aaaah...This one was a pain in the ass to fix. If you (oops) delete the shortcut to SQL Enterprise Mangler, you can't just create a shortcut to an .exe to get it back. This is because it isn't a "program". SQL Enterprise Manager is a "snap-in" to the MMC (Microsoft Management Console). To recreate the SQL Enterprise Manager shortcut: