Browse by Tags

All Tags » SSMS (RSS)
Wednesday, December 09, 2009 8:44 PM

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 by Steve | 1 comment(s)
Filed under: ,
Wednesday, May 20, 2009 8:23 AM

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...
Posted by Steve | with no comments
Filed under: ,
Thursday, March 19, 2009 6:00 PM

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 by Steve | 7 comment(s)
Filed under: