venp's Q&A profile

• SQL Server Internal Query Processor Error (Server: Msg 8621)

  Hi, I have upgraded my database to SQL Server 2005 9.0.2047 (SP1) from SQL Server 2000 8.00.2039 (SP4). After that, I keep getting the stack overflow error for simple queries with values in IN clause and non-query statement: delete from lookupset where lookupset_id in (20900) delete from lookupset where lookupset_id in (20900, 20901) delete from lookupset where lookupset_id = 20900 Msg 8621, Level 17, State 2, Line 1. The query processor ran out of stack space during query optimization. Please simplify the query. How can the sql statements above fail Any help to find out a root cause and a workaround for this problem is greatly appreciated. This does not happen on existing SQL Server 2000 databases with SP4. Thank you very m ...Show All

• Windows Forms post a problem

  where do i post a problem problem of these are development forums for the Microsoft platform (.NET, SQL Server, Xml, Visual Studio etc...) any dev Q's, post in the appropriate forum.   for Windows issues, or perhaps any other Microsoft product, take a look at www.microsoft.com/communities ...Show All

• Software Development for Windows Vista Persistence Service with Remote SQL Server connection

  Is there anyone out there that is successfully persisting and tracking workflow data on a remote server I've had no problems doing this on my local machine. I'm attempting to point to another database server and am getting this error message: System.InvalidOperationException: Workflow with id "9ff9b8b7-2243-4dfd-b606-a7daa88d9b16" not found in state persistence store. I've checked all of the obvious things, remote connections being allowed, DTC turned on and running, etc. I've even opened port 135 through windows firewall and added dtc as an exception. What am I missing ! You aren't compromising any .NET 2.0 work by installing 3.0. .NET 3.0 is simply a set of librari ...Show All

• SQL Server tempdb log file placement

  Using SQL2000 Is it recommended to put the tempdb data and log files on different drives It all depends. One approach: If you have: One logical drive: Everything Two logical drives: Log Everything else Three logical drives: Log Data Everything else Four logical drives: Log Data tempdb OS Physical Database Storage Design: http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx ...Show All

• SQL Server Your login attempt was not successful. Please try again

  I have a standard Login ASP.NET 2.0 control on a login Page, a LoginName and LoginStatus controls on the member's page. once the user login successfully I am redirecting the user to Member.aspx page. The following is my machine configuration Windows XP Pro Service Pack2 IIS 5.1 SQL Server 2000 visual Studio 2005 DISABLE ANONMYOUS ACCESS IN IIS ENABLE WINDOWS AUTHENTICATION I am Using form authentication, and I am getting following error "Your login attempt was not successful. Please try again". To debug,I am displaying the follwoing properties Membership.ValidateUser(Login1.UserName, Login1.Password) : - True HttpContext.Current.User.Identity.Name : - // is blank FormsAuthentication.FormsCookieName : - SqlAuthCo ...Show All

• Visual C# How to make apps startup faster?

  Hi! Ive written an app in C#. The overall performance is great but the starting up of the app is really laggy. How can I make the apps startup smooth Matt   Practical Tips for Boosting the Performance of Windows Forms Apps Thanks alot ;-) for sharing a great article. Yes, using both these articles will really increase the worth of your application in performance. Cheers ;-) ...Show All

• SQL Server Alias OK, IP not

  Hi all, I was able to get my mirroring setup to work only when I use Alias instead of IP address. Any idea why it is so Thanks, Avi Alias is basically associating a name to an IP address for that you use MS SQL 2005-> Configuration tools ->SQL Server Configuration Manager Once you set up an alias you can use it instead of the IP. However, my problem was that with an alias my scripts works well but with IP it does not. Any ideas Avi ...Show All

• SQL Server Implementing Transaction in SSIS Package - [Execute SQL Task] Error: Failed to acquire connection "<ConnectionName>".

  I have a simple SSIS package with three "Execute SQL Tasks". I am using ADO.Net Connection to execute SPs on a DB server. When I execute this package It works fine. So far so good. Now, I need to implement transation on this package. And problem starts now onwards. When I try to execute package after setting TransationOption = Required for the Sequence container which contains all the tasks, I get following error. [Execute SQL Task] Error: Failed to acquire connection "NYCDB0008.Export". Connection may not be configured correctly or you may not have the right permissions on this connection. "NYCDB0008.Export" is the name of the ADO.Net connection. I have been hunting for any solution but all in vain. I have tried changing all ...Show All

• SQL Server Using UPDATE CUBE for override cells with CustomRollup?

  Hi all, In our task I'm using CustomRollup for define logic for calculate some not leaf members, for example: CoalesceEmpty ( [Accounts].[AccountsTree].[1002G].DataMember, ... It allows to have in FactTable, for not leaf members, the values, those used instead of aggregated from children. Now I'm trying use UPDATE CUBE for assign a Datamember's value for non leaf member: UPDATE CUBE ... SET ([Accounts].[AccountsTree].[1002G].DataMember,... ) = ... It works correct if member hasn't CustomRollup formula and doesn't work if CustomRollup exists. So, the question: Can I use UPDATE CUBE for override Datamember's value for non leaf member with CustomRollup Thank you in advance, Stas Yes - be ...Show All

• Visual C++ How to test gcroot for null

  I have class member in native class: gcroot< ManagedClass^ > ptr; I need to test whether this member is null: if ( ptr == nullptr ) // error C2088: '==' : illegal for struct How can i test it The article states that nullptr can be used on internal pointers in the following manner: value class v{}; interior_ptr<v> ptr; ..... ......... ......... if(ptr == nullptr) { //do something } ......... That is if I have understood your problem correctly! ...Show All

• Windows Forms how to make gridview to change datasource

  i want my gridview to change the datasource when i click on a button. eg. i have button1 and button2 and SqlDataSource1 and SqlDataSource2 ... so when i click on button1 i want the content of the gridview to change to SqlDataSource1 and the same with button2. how can i do that I would have hoped that you had supplied more information on what FRamework version you are using and what kind of tools or IDE you are using(such as VS.net 2003/2005 etc.), But I am going to assume that you are using .NET v2.0 because of "GridView"(thinking of DataGridView) In .NET 2.0 using VS.NET 2005, your problem is such a trivial matter with the introduction of BindingSource object. BindingSource object is a ...Show All

• .NET Development Warning: There are updated custom wrappers available for the following referenved components: Office.

    Hello everyone, I converted a vb.net 2002 project to vb.net 2005 and I continue to get the warning message: There are updated custom wrappers available for the following referenced components: Office . If I dbl-click on the message I get: One or more custom wrappers for COM components have been installed on your machine after you added references to those COM components.  These wrappers may provide additional capabilities not offered by the auto-generated wrappers currently in use. Do you want to replace the auto-generated wrappers with the custom wrappers   If I click YES then I get 102 ERRORS++. If I click NO then the project runs just fine but the warning shows in the IDE. Without turning ...Show All

• .NET Development any VB example for using reflection to build sqlparameters automatically

  any VB example for using reflection to build sqlparameters automatically in the code from the SProc Thanks a lot I found these articles, not sure what they re for: - Object Mapping Using Reflection (OMUR) http://www.codeproject.com/dotnet/OMUR.asp - Using Reflection to Bind Object Data to Data Sources : http://www.codeproject.com/vb/net/ReflectionDataBinding.asp - Using Reflection to Bind Business Objects to ASP.NET Form Controls http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnaspp/html/aspformbinding.asp - in MSDN: Dynamically Bind Your Data Layer to Stored Procedures and SQL Commands Using .NET Metadata and Reflection: Atif Aziz, MSDN Magazine Thanks for explaining to ...Show All

• Visual Studio Team System Nested conditions in WIT definition

  I’m trying to make a field required when a double condition is true. Similar to this http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=402934&SiteID=1 , but instead of setting the allowed values based on a condition I want to make the field required or not. Something like: < FIELD refname = " A " > < WHEN field = " B " value = " 1 " > < WHEN field = " C " value = " 2 " > < REQUIRED /> </ WHEN > </ WHEN > </ FIELD > or < FIELD refname = " A " > ...Show All

• SQL Server Transaction

  i ma new in vb.net and sql server so check this way is true Dim SqlCmd As New SqlCommand OpenConnection() 'this is my function of opening database connection Dim TrnSqlServer As SqlTransaction = SqlConnection.BeginTransaction Try With SqlCmd .Connection = SqlConnection .CommandText = CommandType.Text .Transaction = TrnSqlServer .CommandText = "Insert Into MeterialPurchase " & _ "(Date,Account_ID,No_Of_Items,Gross_Total,Less_Amount,Net_Total)" & _ "Values ('" & TxtDate.Text.ToString & "','" & _ LstAccount.SelectedValue & "','" & 10 & "','" & TxtGTotal.Text.ToString & "','&quo ...Show All