Make it a regular practice to download the newest version of SSMS, even if your SQL Server is an older version! SSMS is always backward-compatible and each new release provides many new features, ...

We have a server with full text searching enabled and another where it is not. We have a stored proc that checks if full text indexing is enabled and runs a search query as appropriate but the ...

5. SSMS Debug: the ability to debug any Transact-SQL within SSMS using breakpoints etc. SSMS 2008 Debug – very cool… 4. Multi-Server Queries: being able to submit a batch of queries against ...

To verify this, I registered three servers in SSMS 2008, one SQL Server 2000, one SQL Server 2005 and one SQL Server 2008. I then ran queries through the Multi-Server Query interface with a single ...