Steve's SQL Server Blog

My thoughts to your thoughts.

Browse by Tags

All Tags » SSMS (RSS)
SSMS 2008 cannot connect to a SSIS 2005 instance
Read the title carefully and take it literally. I had discussions with people trying to convince me this is indeed possible. What they were trying to explain to me is the following: Let's take a SQL Server Management Studio 2008 and connect to a SQL Server Integration Services 2005 instance. Proof can be found here . It won't...
Posted: dec 09 2009, 08:44 by Steve | with no comments
Filed under: ,
SQL Server Management Studio Hack
Database administrators are lazy by nature. And although Books Online is a very good resource I'd like to get my own mini overview of most used statements in a new query template such as this one: So whenever I hit "New Query" I get my template. It's also usefull when you want to send your script to a colleague...
Cannot find template file for the new query
Be carefull when using cleanup tools which remove empty files from your system. The application I used deleted files with 0KB sizes. Apparently it also deleted files like C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql which is 108 Bytes. You can spot it from a 20...
Posted: mrt 19 2009, 06:00 by Steve | with 2 comment(s)
Filed under: