Few months ago, when we upgrade from VSS to TFS, somehow we lost intellisense in SQLServer Management studio 2008 R2. We struggle a lot to obtain. But no luck till now. However, currently we are using Visual Studio 2010, which enriched with lot of futures.
Instead of using SQL Server Management, what I did was open the SQL file using Visual Studio 2010. In Visual Studio, Right click on the Menu bar, from the floating menu “check” the “Transact-SQL Editor”.
Now we got the toolbar available in SQL to do some basic operations like connect the SQL Server, Execute the Transact SQL etc., The main benefit in this approach is the intellisense works fine with in the “Transact-SQL Editor”. So my problem solved temporary.
Hope this may help to some one!!
Instead of using SQL Server Management, what I did was open the SQL file using Visual Studio 2010. In Visual Studio, Right click on the Menu bar, from the floating menu “check” the “Transact-SQL Editor”.
One of the main attraction in this feature is, we can do all basic operations with in this editor. However, I’m not at all a DBA, just a developer who used SQL server as a backend. This is more convenient way work as of now.
Hope this may help to some one!!
0 comments :