January 23, 2014 at 4:18 am
Hi Guys,
can you give me solutions to solve intellisense problem in sql server 2008 r2 sp1
version details:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
i re-registered "TextMgrP.dll" but not solve intellisense problem.
--chalam
January 23, 2014 at 4:38 am
Has it ever worked for you? If so, what has changed?
January 23, 2014 at 4:48 am
Check the compatibility level of the database you're querying against. If it's an older version, that can prevent Intellisense from working. Other than that, ensure that it's enabled and understand that it's extremely limited.
Intellisense never worked well for me. I always use Red Gate SQL Prompt[/url] instead (and yeah, I work for Red Gate now, but I've been using that tool for years & years before I went to work for the company).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2014 at 6:06 am
Do you have any versions of Visual Studio/TFS installed as well? One of our developers' Intellisense stopped working which was caused by an SP install of VS 20101 if I remember rightly, and a hotfix was supplied by MS (via Windows Update) to rectify this.
January 23, 2014 at 10:38 pm
Hi Valued Member,
i have install vs sp1 in my system,for rectify this problem which software(hot fix) i have to install .
Below are sql server version details which i use in my system.
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
--chalam
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply