.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Intelisense not working in SQL server 2008 R2

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
I downloaded the 431250_intl_x64_zip. For extracting I tried with 2 passwords given by hotfix ,but it is not extracting

View Complete Post

More Related Resource Links

Not working on Windows Server 2008




I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.

We are using SharePoint 2007.

Is there another work thru for 64bit environment.

I notice windows server 2008 has a directory  C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???

Please help!

Indexing services on window server 2008 is not working with .net

Hi, I am useing Microsoft indexing services in windows 2008 64 bit .I am getting error like "Exception from HRESULT: 0xC0000005" while i am createing  new catlog from .net 2.0.I am using  "ciodm.dll" for adding new catlog. i am using this code for create new catelog.   Dim Admin As New CIODMLib.AdminIndexServer   Admin.AddCatalog(varContractNo, txtCatelog.Text + "\" + varContractNo) Admin.Stop() Admin.Start() AddScope(txtDocFolderPath.Text, txtSite.Text, txtCatelogname.Text)   Please help me anybody have fixed this issue on window server 2008 64 bit.  

how to make working WPF 2010 program make changes to SQL Server 2008 Express files

(1) I have a working WPF 2010 program that manipulates a table in SQL Server 2008 Express (2) the program does delete, update, select and insert correctly however in its own project file folder logbooklmk.mdf   logbooklmk_log.ldf (3) I want the actual SQL Server 2008 express files to be changed yes I know the issue is sharing and the copy option only applies to the local project files. I found this out by trying always copy, never copy and copy if newer. I probably have to change the .xsd folder to refer to the actual SQL Server 2008 Express file. Tried that once and it failed. Something about sharing not allowed.

CLR stored procedures asssemblies working in sql server 2005 but giving issues over sql server 2008

Hi I developed CLR stored procedures assemblies using VS2005 and deployed in sql server 2005 are working fine. Currently we are migrating to sql server 2008. The same CLR assemblies are not working in 2008 version and raising following error. Here i created CLR assemblies in sql server 2008 using 'sa' user account which is having db_owner permission over 'mydatabase'. I am getting an error message like "A .NET Framework error occurred during execution of user-defined routine or aggregate". In sql logs showing messages like as -- Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from C:\Windows\Microsoft.NET\Framework\v2.0.50727\. -- AppDomain 2 (mydatabase.dbo[runtime].1) created.   Please let me know what may be the cause for this type of issues. Is there any specific backward compatibility settings has to be done over sql server 2008 or sql server 2008 R2 while using 2005 CLR routines?   Thanks in advance.  

query with locks not working in sql server 2008

I have a select query with join on some view and locks as (readpas,updlock) after executiong this query it executes the same query with little modification( no locks etc). This sequence of query executes fine in SQL server 2000/2005.   When I am executing same seq in sql server 2008 through application, I am getting timeout for second query. Can someone please suggest what can be the reason? I cannot post the query.Cheers!!! Vatsa

SQL Server 2008 R2 64 bit working with out Hot fixes -- Job modification and Creattin


 Hi all

I Installed SQL Server 2008 R2 and it is side by side with SQL Server 2005 (64bit)

Here my version

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) Hypervisor).

I am able to create Jobs and able to modify the Jobs with out appling any hotfix.

old post which is recomended to applu hotfix


1. Why my server not given  gives error while creating /modifing Job ?

2.From  wizard/mantenancePlans  Iam creating Jobs it is correct test.

2.Is it because of SQL Server 2005


Please some suggest me..why I a

restore SQL server 2005 database on new SQL server 2008 not working

please any one advice me ,i have Great Plain database on SQL server 2005 when i tried to install new SQL server 2008 and restore my Database the GreatPlain not working well as well the Data Base

2008 Report not working on 2005 report server


Hello, I have been researching this issue and it seems if I have created a report using 2008, I cannot upload it to a 2005 report server.

I just wanted to check and see if I have any other options than to re-create the report using 2005? Would copy/paste of the XML from 2008 to 2005 work?

Thanks! Linda


property setting in report server (2008) config file is not working as expected.



I have set the <WorkingSetMinimum> property to 2.4GB in my reportserver 2008 config file.

By defintion, <WorkingSetMinimum> setting means,

  1. Lower limit of service memory consumption; memory will not be released if the consumption is below this amount, though the service will not reserve the designated amount of memory when it starts.
  2. If service uses more than the designated amout of memory, it will release back the memory only till this declared value and not beyond that, which means it should keep 2.4GB as designated.

See this link for definition: http://books.google.com/books?id=mzY_Xo_9J-gC&pg=PA589&lpg=PA589&dq=What+is+%3Cworkingsetminimum%3E+in+report+server+configuration+file&source=bl&ots=r_xhRp8erj&sig=E_o0-Dh2SXOgMNrW3sptt5oZrYI&hl=en&ei=f5mjTNeNM5O8ccmErJMI&sa=X&oi=book_result&ct=result&resnum=4&ved=0CCAQ6AEwAw#

Linked server from SQL Server 2008 R2 to SQL Server 2005 not working


I'm trying to create a linked server from SQL Server r2 to SQL Server 2005 (both 64 bit Enterprise) using the following script

 EXEC master.dbo.sp_addlinkedserver
 @server = N'TestLS'
 ,@provstr='Integrated Security=SSPI;';

I verified that the Kerberos is working.

When I try to run a four part query as below it gives me the error

Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
OLE DB provider "SQLNCLI10" for linked server "TestLS" returned message "Invalid connection string attribute".

If I try to set up the linked server against localhost (i.e. SQL 2008 R2, it works just fine).



Distributed transaction using linked server not working in SQL Server 2008 64 bit


Hi. I have had an issue trying to get distributed transactions to work in SQL Server 2008 using a linked server. The error message I get is

OLE DB provider "SQLNCLI10" for linked server "pod1" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "pod1" was unable to begin a distributed transaction.

My Environment:

Windows Server 2008 Enterprise 64 bit, SQL Server 2008 Enterprise 64 bit

Problem occurs with multiple different builds of SQL Server 2008 - I have been able to reproduce the problem with 10.0.1600.0, 10.0.1779.0 (CU 2), as well as 10.0.2531 (SP1)


I am aware that other people have had this issue and have reviewed all existing posts. I have verified that the MSDTC is configured correctly on both machines. I have also used DTCTester to verify that DTC is working correctly on all machines in question. None of the mentioned resolutions has solved this problem for me.

I am not seeing this problem occur on my 32 bit test machines - it is only occurring if at least one of the two machines is 64 bit.


SQL Server 2008 R2 IntelliSense not working


I am running SQL Server 2008 R2 (version info below) and IntelliSense is not working.  I am connected to a SQL Server 2008 Edition database.

IntelliSense is enabled, SQLCMD mode is turned off.  I refreshed the local cache.  I am accessing simple table objects for which I have access rights.  All of the usual suspects are covered and still I have no IntelliSense functionality. 

Any ideas?

Microsoft SQL Server Management Studio                        10.50.1600.1
Microsoft Analysis Services Client Tools                        10.50.1600.1
Microsoft Data Access Components (MDAC)                        6.1.7600.16385
Microsoft MSXML                        3.0 5.0 6.0
Microsoft Internet Explorer                        8.0.7600.16385
Microsoft .NET Framework                    &

SQL Server 2008 Report Manager is not fully working



On Windows server 2008 R2 Enterprise Edition, we have installed SQL server 2008 R2 Reporting services and SQL Server 2008 database with Reporting services.  Both have different instances.

Now, we can work with Report manager of SQL server 2008 R2 without any issue. i.e. assignment of new user role etc. is working fine, but when we try to do same thing with report manager of sql server 2008 then its not working. No error message is being shown by the report manager when we try to assign new user a role and press OK button it doesn't show any message.


What could be the problem?





SQL Server 2008 R2 Setup has stopped working


Hi, I have a server with Windows Server 2008 R2 Standard Edition English and when I try to install SQL Server 2008 R2 Standard Spanish the installer give to me:

"SQL Server 2008 R2 Setup has stopped working
A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."

Previously I changed the Current Format in Regional and Language Options to Spanish to solve a problem with OS Local. The mentioned error appears during the step of install the Setup Support Files, the step stop and show me the error with a "Close program" button, after press the button the installation finish. Thanks in advance.

DELL PowerEdge T710
2 Intel Xeon CPU E5502 1.87GHz

Windows Server 2008 R2 Standard 64bit ENU (english)
SQL Server 2008 R2 Standard 64bit ESN (spanish)

Working with unicode (SQL SERVER 2008, ADO, BCB6)


I have a problem inserting Unicode text into sql server database table.

Field type is NVARCHAR, selecting works fine, but not insert

Here is my code:


I use TntMemo1 to ensure the parameter is unicode.

Result is question marks.

Please help



Intellisense not working SQL Server 2008 R2


A swiggly red line shows up, but I cannot get the list members e.g table.____  does not show the list of fields to that table. The intellisense is enabled , I did a refresh for the local cache but this has not helped at all.Is there anything else that I can do to make this work???

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend