Gonzo TechNet
Microsoft SQL Server tips, tricks, configurations, & How-To's

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.

WARNING:Use at YOUR own risk!

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...

Errors, Fixes, & General Stuff...

How to re-create/reset the Shortcut Icon for the SQL Services Manager (sqlmangr.exe)

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:

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe"
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlmangr.rll"

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:
"Exception has been thrown by the target of an invocation(mscorlib). An error has occurred while establishing a connection to the server. When connecting to sql server 2005, this failure may be cause by the fact that under the default settings, sql server does not allow remote connecitons. (provider: tcp provider, error: 0 no such host is know) error 11001"
See: How To delete a Rogue SQL 2005 Maintenance Plan
How to create/reset the Shortcut Icon for the SQL Enterprise Manager (SQLEM)

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:

You can now copy the shortcut and paste it back into your "Programs\Microsoft SQL Server" menu folder.

Retrieving information

Maintenance procedures and functions

Setup and Configuration

Home | TechNet | ADO.Net | DOS | ASP.NET | IIS | VB.NET | VIM (vi) | Windows | XHtml
MS-SQL | T-SQL | SSIS | Oracle