Aaron Akin

March 18, 2009

Nested Common Table Expressions

Filed under: CTE,SQL,SQL 2005,SQL 2008,TSQL — Aaron Akin @ 8:01 pm

If you’ve looked up a Common Table Expressions in Books Online, you might have noticed that Microsoft says that you cannot have nested CTEs (meaning, you can’t define a CTE in the definition of another CTE. Although this is technically true, you can still accomplish the same functionality in a different manner.


February 18, 2009

SSIS 2005 Connections from SSMS 2008

Filed under: SQL 2005,SQL 2008,SSIS,SSMS — Aaron Akin @ 5:17 pm

After I first installed SQL 2008, I tried to connect to SSIS 2005, and to my surprise, received the error, “Connect to SSIS Service on machine xxx failed: Class not registered.”  Thanks for the descriptive error message, Microsoft.

Cannot Connect to Server

Apparently, you cannot connect to SSIS 2005 from within SSMS 2008.  I found a feedback ticket with Microsoft that confirms the issue, though I wasn’t completely clear if they are planning on fixing it or not.

So, for those of you who installed SSMS 2008, make sure you keep SSMS 2005 installed as well if you still have SSIS 2005 packages out there…even if it is a pain to have to switch back and forth.


February 2, 2009

Sorting SSIS Packages & Folders in SSMS

Filed under: SQL,SQL 2005,SQL 2008,SSMS — Aaron Akin @ 5:24 pm

It had always bothered me when I opened a SQL 2005 Integrated Services instance to find an SSIS package, only to see that the folders and packages were not in alphabetical order.

SSMS Object Explorer

It wasn’t long before this started to get irritate me.  I did some digging and found 2 system stored procedures (sp_dts_listfolders and sp_dts_listpackages) in the msdb database that SQL Server uses to display the packages and folders in menus.


January 5, 2009

Cleaning Recent Projects List in Visual Studios

Filed under: SQL 2005,SQL 2008,Visual Studios (BIDS) — Aaron Akin @ 6:16 pm

I’m always creating a bunch of projects in Visual Studios for testing purposes, all of which clutter up my Recent Projects list on the VS Start Page.  If you’re like me and want to clean up this list, make sure Visual Studios is closed and then open up the Registry Editor (Start > Run > regedit) and find the following key:

Visual Studios 8.0 (SQL 2005):

Visual Studios 9.0 (SQL 2008):

Here you’ll find a list of keys that represent the projects/solutions that appear in your Recent Projects.  You can either delete all of these entries, or just specific ones.  Be careful if you only delete specific ones though.  If you have 4 items (File1, File2, File3, File4) and you delete File2, only File1 will appear in your Recent Projects list.  To fix this, you’ll just need to rename the rest of the keys so that there are no gaps in the sequential numbering.  In this case, you would need to rename File3 to File2 and File4 to File3.

When you re-open Visual Studios, you should find a much cleaner list.


Blog at WordPress.com.