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


Top 5 Contributors of the Month
ASPEvil
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Post New Web Links

SQL 2008 SP2: adding a "persisted computed column" creates an "Internal Query Processor Error: The q

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server
 
Hi, a simple (and long-existing) stored procedure started throwing this error after adding a persisted computed column on another table that is not used in the stored procedure (but is referenced by a foreign key in the table used in the stored proc.)
Msg 8624, Level 16, State 1, Procedure pSetPersonExtraAnswer, Line 26
Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

I think I have traced the "culprit" to the following update.
ALTER TABLE dbo.Persons ADD fullName AS (firstName + ' ' + lastName) PERSISTED
GO


Here is the very weird thing:

If I restore the DB, immediately add the persisted computed column and run the problematic SP call, I get the error in Management Studio.

If I restore the DB, run the problematic SP call and then add the computed column, I no longer get an error from SSMS when I rerun the SP call. But, I still get it from my ASP.NET (via enterprise library) code!

When the error happens, altering the pro


View Complete Post


More Related Resource Links

Problem adding .NET 3.5.1 feature on Server 2008 R2

  
Having an issue with a 2008 R2 64-bit Server becoming unresponsive/locking up when trying to activate the .NET 3.5.1 feature.  Did not have any previous version of .NET installed but ran the .NET Cleanup utility and completed successfully but still have same issue.  It installed .NET 4 via the Microsoft Updates OK but still hangs part way through the 3.5.1 install via the Server Manager/Add Features.  Any ideas?  Thanks!

Error 15401 when adding AD logins in upper case to a sql 2008 server

  
We are repeatedly getting Error 15401 when adding couple AD logins in upper case(DOMAIN_NM\USR_NM) to a sql 2008 server with the latin1_general, binary sort collation.  Lower case (DOMAIN_NM\usr_nm) works fine.  All the other servers, even the ones with the same collation, it is the opposite, upper case works and not the lower case.  Looked for duplicate SIDs in the domain, on the sql server, did not find any.  Any idea what's going on?. 

studio 2008 adding classes missing assembly

  
Classes were copied into  to the project. The classes had already been written. Studio cannot find them. they are all (now) in the rrot of the project

Adding triggers to a Merge Replicated published article in SQL Server 2008

  

Currently running merge replication on SQL Server 2008 10.0.1600 and I have a few questions around the correct procedures for adding and modifying triggers on published articles.  I've searched through the MSDN site and googled this but have not found any definitive information on correct procecdures.

1) When a new trigger is added to a published table do we just have to rerun the snapshot and then re-syncy the subscribers?  Just adding them does not seem to replicate them to subscribers.

2) When an existing trigger is modified should ALTER TRIGGER be used or should the trigger be dropped and then re-added?

Thanks.


Error Adding Node to SQL 2008 R2 Cluster

  

Windows Server 2008 R2 64bit. SQL 2008 R2 64bit.

The Windows Failover cluster is installed with 2 nodes. SQL Cluster was installed successfully on node 1. Ran SQL setup to add a SQL node 2. Made it to the service accounts screen. The SQL Server Agent service account name box is grayed out and nothing can be entered. If I hit next I get the following error. I can't get past this. I looked for any cumulitive updates for R2, but there aren't any. Does anyone have a work around? If not I will have to scrap the install and go back to the non R2 version of SQL.

[Error Message]
The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service.

[Details]
Microsoft.SqlServer.Configuration.Agent.InputValidationException: The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service.
================================================================================

 


Adding Instance(SQL Server 2008 R2) and Moving Quorum Drive

  

Hi all,

I am Planning to Add new SQl Server 2008R2 Instance to SQL Server 2000 SP4 in Windows 2003 SP2 OS and As of now all the storage in SAN drive

Here problem is my company is going to move SAN drive to iSCSI and they given me iSCSI drives to Install SQL Server 2008R2 and they ask me Create Quorum drive on iSCSI.

1. Is it possible to create one more  Quorum  Drive or I need to move excisting Quorum to new Drive

I have below Groups in SAN Drive and I want Move those groups to iSCSI Drives what is best way ..to do this  with minimum Down time.

Cluster Group
---------------
Cluster Ip Adress
Cluster Name
MSDTC
MSDTC IP Adress
MSDTC NetworkName
Q:Quoram


SQL
----
Disk G:
Disk L
SQL IP IpAdress(SQLCLUSTER)
SQL Network Name(SQLCLUSTER)
SQL Server Name
SQL Server Agent
SQL Server Fulltext

 

 

Thanks in Advance

 


SNIVAS

Adding Certificates for SSL connection for a user account in Windows 2008 Server

  

Hi All, I have a windows service running on Windows 2008 server, when I set the service to log on as Local System account, it works fine and does the ssl certificate authentication.

Where as when I change the service to log on to a different account it fails with the authentication error.

Could some one please help me here.

Regards,
Nandu. 


SSRS 2008 - Excel Export adding unwanted total columns to spreadsheet

  

Hi

I have a SSRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups.  I dont have this displayed in the report and dont want it displayed in teh excel export, is there anyway to turn this off?

I've had a search of this forum but so far i've been unable to find a solution(or someone else having the same problem)

Cheers


MOSS 2007 Services Not Starting After Adding 2008 R2 WFE to 2003 R2 Farm

  

In preperation for our 2010 upgrade we have been migrating our 2003 R2 infrastructure to 2008 R2. Our prior environment was server 2003 R2 DB server running SQL 2005 and one 2003 R2 WFE. We migrated the DB server to 2008 R2 and SQL 2008. The next step was to add a 2008 R2 WFE and then decommision the 2003 R2 WFE.

Setup was successful on the 2008 R2 box. However, in CA the services on the 2008 R2 WFE show "Starting". The CA service is the only service that shows "Started" on the 2008 R2 box. The Document Conversions Launcher Service, Document Conversions Load Balancer Service, Windows SharePoint Services Search and Windows SharePoint Services Web Application show "Starting". The Windows SharePoint Services Administration does not display a status.

What step am I missing to get all of the services running on the new 2008 R2 WFE so I can turn off the 2003 R2 WFE? I don't see anything in the error logs.

 


while adding service reference in .net 2008

  

The document at the url https://hostname/app1/abc.svc was not recognized as a known document type.
The error message from each known type may help you fix the problem:
- Report from 'DISCO Document' is 'There was an error downloading 'https://internalsystemname/app1/abc.svc?disco'.'.
  - The request failed with HTTP status 502: Proxy Error ( No data record is available. For more information about this event, see ISA Server Help.  ).
- Report from 'WSDL Document' is 'The document format is not recognized (the content type is 'text/html; charset=UTF-8').'.
- Report from 'https://hostname/app1/abc.svc' is 'The document format is not recognized (the content type is 'text/html; charset=UTF-8').'.
- Report from 'XML Schema' is 'The document format is not recognized (the content type is 'text/html; charset=UTF-8').'.
The document at the url https://hostname/app1/abc.svc was not recognized as a known document type.
The error message from each known type may help you fix the problem:
- Report from 'DISCO Document' is 'There was an error downloading 'https://internalsystemname/app1/abc.svc?disco'.'.
  - The request failed with HTTP status 502: Proxy Error ( No data record is available. For more informatio

Error #544 and adding SET IDENTITY_INSERT ON/OFF in replication SPs manually (2008 R2)

  

Hi all,

I have created a read-only transactional publication and initialized the subscriber using a backup (all objects are participating in publication). I noticed that error #544 is constantly being raised on two tables those having identity column. Error is:

Cannot insert explicit value for identity column in table 'Security_Log' when IDENTITY_INSERT is set to OFF. (Source: MSSQLServer, Error number: 544)

I manually altered the related Insert SPs for them and added SET IDENTITY_INSERT ON/OFF, the problem solved. I’m wondered that if this is the right way of eliminating such error or I am missing a configuration in replication.

Many thanks in advance,

Leila


create subscription on client creates no entry in Sync Center if there is another SQL Server 2008 R2

  

We created a publication on SQL Server 2008 R2 (Dev. Edition). Then we tried to create a pull-merge subscription on the client which should create an entry in Synchronization Center (Win 7) as well under Windows Explorer – Synchronization (Win XP).

 

This scenario works if there is only our instance of SQL Server installed on the client.

If there is another instance (default or another named instance) installed before we create our instance with subscription there is following strange situation:

 

-       Subscription is created properly within Management Studio, property for showing in sync center set to enabled.

-       No entries created in Synchronization Center or Win Explorer Synch.

-  &nbs

sql server 2008 r2 install does not create database engine, also mmc creates error "Failed to create

  

I am loading sql server 2008 r2 developer edition into Windows Vista Home Basic. Product loads correctly with no error messages; except will not create database engine. And will not create integration services. When I try to open MMC, I will get error "MMC could not initialize the snap-in. Product may not have been installed correctly."

I understand this is a known issue for SQL Server 2008 RD installing on Windows Vista? What is the workaround or fix? Hot fixes available for this issue from support.microsoft.com do not install on my Windows Vista Home Basic machine.

 


Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

  
In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

Adding Rows in GridView without using a Database

  
This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

  
This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

Adding Dynamic Rows in GridView with TextBoxes

  
I decided to write this article because this has been asked so many times before at the forums(http://forums.asp.net) . Basically, this example shows on how to generate a Row in GridView with TextBoxes when clicking a Button that is residing inside a GridView Footer.
Categories: 
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