[thelist] What I hate about MS SQL Management Studio 2005 - Part 2

Anthony Baratta anthony at baratta.com
Wed Jun 28 07:38:48 CDT 2006


<TIP Author="Anthony Baratta" Subject="MS SQL Management Studio 2005">

In order to manage DTS packages for MS SQL 2000 in SQL Management Studio 2005, you need to download an additional package for 2005.

Microsoft SQL Server 2000 DTS Designer Components 
http://msdn.microsoft.com/SQL/bi/integration/downloads/default.aspx

Also, this package freaks out your keyboard, so only open when you absolutely have to. After leaving the DTS Designer window open and attempting to edit a stored procedure - my arrow keys, backspace key, delete key, Ctrl-C, CTRL-V did not work while editing the SP. I could cut and paste with the mouse and overwrite selected text. Keybaord worked correctly in other applications just not in SQL Management Studio. When I closed DTS Designer, my keyboard worked correctly in Management Studio.

Go figure.

(Side Rant: Why did Microsoft name this application SQL Management Studio? The ancronym comes out to MS SMS, which is the same as Microsoft Systems Management Server.)
</TIP>

Still looking for a way to export SPs using 2005 into individual files. I know I can do this will a C# or an SP itself - but I'd prefer to do this via the Management Studio Interface.




More information about the thelist mailing list