SQL Server Blog

Rather annoyingly today, I had this error message pop up when trying to view a Stored Procedure.

The error is generated from SMO (). I knew that the stored procedure hadn’t been updated in a long time and my first thought was that there was some form of corruption.
Read more…

Ever had this really annoying error pop up when you are trying to view or edit a step within a Job? It happened to me again today.

I found a nice simple fix in the end.

Open up the command line tool Navigate to your Microsoft SQL Server\100\DTS\binn folder. From there run regsvr32 dts.dll

You should get a popup stating “DLLReigsterServer in dts.dll succeeded.” You’ll then need to restart Management Studio.