My intellisense is not working

Question

Post reply

My intellisense is not working

forsqlserver

SSCoach

Points: 18902
More actions
May 26, 2011 at 4:42 am

#240355

This is the out put of one row of Intellisense.Actually My intellisense is not working and when I am enabling,it is showing this in SP_who2.
The below one is a row of SP_who2 output.
56
sleeping
XYZ\XYZ
ANKIT-ITSM-HO
tempdb
AWAITING COMMAND
0
0
05/26 16:07:17
Microsoft SQL Server Management Studio - Transact-SQL IntelliSense
56
0
Thanks

Viewing 15 posts - 1 through 15 (of 34 total)

You must be logged in to reply to this topic. Login to reply

Ryan007 SSCrazy Eights Points: 8275 More actions · Answer 1

Please restart your sql server and check if it works.

Ryan
//All our dreams can come true, if we have the courage to pursue them//

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 2

I'm not a fan of intellisense, when it works, it doesn't do enough.

That said, instead of sp_who2, take a look at sys.dm_exec_requests and see if you see an active connection that is blocked or waiting for the intellisense task. If so, figure out what it's waiting on. It might be blocked by another process or it might be loading a large set of tables or something. If not, try killing the process. I wouldn't reboot.

"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

Lowell SSC Guru Points: 323518 More actions · Answer 3

Sumanta Roy (5/26/2011)
Please restart your sql server and check if it works.

uhh..no.

intellisense as well as syntax highlighting are contained in a DLL called from the client app of SSMS; nothing to do with the server...

so don't bounce the server for no reason.

best thing to do would be

1 check your file associations: for example, if SSMS doesn't look at .txt files the same way as .sql files,

refresh the intellisense, as it ccan get confused when switching databases sometimes, or if intellisense still doesn't work

maybe repair/reinstall the client tools

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

forsqlserver SSCoach Points: 18902 More actions · Answer 4

Thanks,

I know also restart will work But I cant restart.

I have killed the intellisense SPIDs also.

Lowell I am not getting why u have pasted your "OPTION" Screenshot.

session_idrequest_idstart_timestatuscommandsql_handlestatement_start_offsetstatement_end_offsetplan_handledatabase_iduser_idconnection_idblocking_session_idwait_typewait_timelast_wait_typewait_resourceopen_transaction_countopen_resultset_counttransaction_idcontext_infopercent_completeestimated_completion_timecpu_timetotal_elapsed_timescheduler_idtask_addressreadswriteslogical_readstext_sizelanguagedate_formatdate_firstquoted_identifierarithabortansi_null_dflt_onansi_defaultsansi_warningsansi_paddingansi_nullsconcat_null_yields_nulltransaction_isolation_levellock_timeoutdeadlock_priorityrow_countprev_errornest_levelgranted_query_memoryexecuting_managed_codegroup_idquery_hashquery_plan_hash

102011-05-26 15:29:44.767backgroundRESOURCE MONITORNULLNULLNULLNULL01NULL0NULL0SLEEP_TASK010NULL000523003310485780x055EE1C00004096us_englishmdy7000000002-10001001NULLNULL

202011-05-26 15:29:44.767backgroundXE TIMERNULLNULLNULLNULL01NULL0XE_TIMER_EVENT7008XE_TIMER_EVENT010NULL000522984110x0017E7180004096us_englishmdy7000000002-10001001NULLNULL

302011-05-26 15:29:44.767backgroundXE DISPATCHERNULLNULLNULLNULL01NULL0XE_DISPATCHER_WAIT5229806XE_DISPATCHER_WAIT010NULL000522982600x0018A3880004096us_englishmdy7000000002-10001001NULLNULL

402011-05-26 15:29:44.767backgroundLAZY WRITERNULLNULLNULLNULL01NULL0LAZYWRITER_SLEEP113LAZYWRITER_SLEEP010NULL0031522919300x0018A5500004096us_englishmdy7000000002-10001001NULLNULL

502011-05-26 15:29:44.767backgroundLOG WRITERNULLNULLNULLNULL01NULL0LOGMGR_QUEUE10659LOGMGR_QUEUE010NULL0078522915410x0017E8E00004096us_englishmdy7000000002-10001001NULLNULL

602011-05-26 15:29:44.767backgroundSIGNAL HANDLERNULLNULLNULLNULL11NULL0KSOURCE_WAKEUP5185245KSOURCE_WAKEUP010NULL000518524510x0017EAA80004096us_englishmdy7000000002-10001001NULLNULL

702011-05-26 15:29:44.767backgroundLOCK MONITORNULLNULLNULLNULL01NULL0REQUEST_FOR_DEADLOCK_SEARCH3677REQUEST_FOR_DEADLOCK_SEARCH010NULL000522905100x0018A7180004096us_englishmdy7000000002-10001001NULLNULL

802011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x000000000004096us_englishmdy7000000002-10001001NULLNULL

902011-05-26 15:29:44.767backgroundTRACE QUEUE TASKNULLNULLNULLNULL11NULL0SQLTRACE_INCREMENTAL_FLUSH_SLEEP1990SQLTRACE_INCREMENTAL_FLUSH_SLEEP010NULL000522663110485790x059181C00004096us_englishmdy7000000002-10001001NULLNULL

1002011-05-26 15:29:44.767backgroundBRKR TASKNULLNULLNULLNULL11NULL0BROKER_TO_FLUSH323BROKER_TO_FLUSH010NULL000522540010x0017F0000004096us_englishmdy7101011112-10001001NULLNULL

1102011-05-26 15:29:44.767backgroundTASK MANAGERNULLNULLNULLNULL11NULL0ONDEMAND_TASK_QUEUE5226347ONDEMAND_TASK_QUEUE010NULL000522634710x0017EC700004096us_englishmdy7000000002-10001001NULLNULL

1202011-05-26 15:29:44.767backgroundCHECKPOINTNULLNULLNULLNULL41NULL0CHECKPOINT_QUEUE130887CHECKPOINT_QUEUE010NULL000522634700x0018A8E002515024096us_englishmdy7000000002-1000-1001NULLNULL

1302011-05-26 15:29:44.767backgroundBRKR EVENT HNDLRNULLNULLNULLNULL11NULL0BROKER_EVENTHANDLER5195521BROKER_EVENTHANDLER010NULL0015522545900x0018AE385213034096us_englishmdy7101011112-10001001NULLNULL

1402011-05-26 15:29:44.767backgroundBRKR TASKNULLNULLNULLNULL11NULL0BROKER_TRANSMITTER5223405BROKER_TRANSMITTER010NULL000522340510x0017F1C80004096us_englishmdy7101011112-10001001NULLNULL

1502011-05-26 15:29:44.767backgroundBRKR TASKNULLNULLNULLNULL11NULL0BROKER_TRANSMITTER5223366BROKER_TRANSMITTER010NULL000522336600x0018B0000004096us_englishmdy7101011112-10001001NULLNULL

1602011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x000000000119204096us_englishmdy7000000002-10001001NULLNULL

1702011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x000000000014774096us_englishmdy7000000002-10001001NULLNULL

1802011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x00000000006964096us_englishmdy7000000002-10001001NULLNULL

1902011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x00000000008504096us_englishmdy7000000002-10001001NULLNULL

2002011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x00000000015254096us_englishmdy7000000002-10001001NULLNULL

2102011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x00000000059334096us_englishmdy7000000002-10001001NULLNULL

2202011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x00000000007434096us_englishmdy7000000002-10001001NULLNULL

2302011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x00000000006454096us_englishmdy7000000002-10001001NULLNULL

2402011-05-26 15:29:44.767backgroundDB MIRRORNULLNULLNULLNULL01NULL0DBMIRROR_EVENTS_QUEUE5206805DBMIRROR_EVENTS_QUEUE010NULL000520695300x0018BAB000164096us_englishmdy7000000002-10001001NULLNULL

2502011-05-26 15:29:44.767backgroundDB MIRRORNULLNULLNULLNULL01NULL0DBMIRROR_EVENTS_QUEUE25DBMIRROR_EVENTS_QUEUE010NULL000520635610x05E523880594096us_englishmdy7000000002-10001001NULLNULL

2602011-05-26 15:29:44.767backgroundDB MIRRORNULLNULLNULLNULL01NULL0DBMIRRORING_CMD5183599DBMIRRORING_CMD010NULL000520624500x0018BC780034096us_englishmdy7000000002-10001001NULLNULL

2702011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x000000000015604096us_englishmdy7000000002-10001001NULLNULL

2902011-05-26 15:29:44.767backgroundBRKR TASKNULLNULLNULLNULL11NULL0BROKER_TASK_STOP25BROKER_TASK_STOP010NULL0015520624310x05E5271830924096us_englishmdy7101011112-10001001NULLNULL

3002011-05-26 15:29:44.767backgroundBRKR TASKNULLNULLNULLNULL11NULL0PREEMPTIVE_OS_WSASETLASTERROR271PREEMPTIVE_OS_WSASETLASTERROR010NULL00889520555300x060721C020010234096us_englishmdy7101011112-10001001NULLNULL

3102011-05-26 15:29:44.767sleepingTASK MANAGERNULLNULLNULLNULL11NULL0NULL0MISCELLANEOUS010NULL0000NULL0x000000000010154096us_englishmdy7000000002-10001001NULLNULL

5702011-05-26 16:56:11.823runningSELECT0x0200000002C6D42F7AAACE541C95D637FEB5A6185258B4350-10x0600010002C6D42FB840150A00000000000000000000000011E80AA216-2A3D-4304-BAF1-F76B61F167B60NULL0MISCELLANEOUS01642150x000210x0017FE400002147483647us_englishmdy7111011112-1031000020x3699BA96D3F9F6A10xAD412BC185253225

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

What's the version of the SQL Server that you are connected to?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

forsqlserver SSCoach Points: 18902 More actions · Answer 6

Thanks a lot Gila,

My Edition is:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Enterprise Edition on Windows NT 6.1 <X86> (Build 7600: )

Thanks

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 7

Try registering a DLL by running the given command in run window - [regsvr32 "%commonprogramfiles%\microsoft Shared\MSEnv\TextMgrP.dll"].

forsqlserver SSCoach Points: 18902 More actions · Answer 8

I am getting this error:

https://picasaweb.google.com/117663646730679854624/26May2011#5610996827147206882

Thanks

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 9

Latheesh NK

SSCertifiable

Points: 6559

May 26, 2011 at 6:31 am

#1330243

Not many organizations support picassa...Sorry...

Lowell SSC Guru Points: 323518 More actions · Answer 10

sqlzealot-81 (5/26/2011)
Not many organizations support picassa...Sorry...

blocked at my job too....

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 11

forsqlserver (5/26/2011)
Thanks a lot Gila,
My Edition is:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Enterprise Edition on Windows NT 6.1 <X86> (Build 7600: )

That's not what she asked. What SERVER's version are you connecting TO. You can't use intellisense in the edition you're connected to is pre-2008.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 12

forsqlserver (5/26/2011)

I am getting this error:

https://picasaweb.google.com/117663646730679854624/26May2011#5610996827147206882%5B/quote%5D

Here's the image in questions.

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 13

ohhhh....Can you try just close your SSMS window and check it is working?

forsqlserver SSCoach Points: 18902 More actions · Answer 14

Error:

The module "C:\Program Files\common files\microsoft Shared\MSEnv\TextMgrP.dll" was loaded but the call to dll register server failed with error code 0X80070005

Thanks