Mahesh Gaware's Q&A profile

• SQL Server Why I got added rows when using FULL OUTER JOIN?

  I've met a curiouse thing when using full outer join, that I got some rows belong to neither tables @_@ The SQL statement is like this: SELECT     PreviousMonth.InvoiceID, PreviousMonth.CategoryName, PreviousMonth.ProdName, PreviousMonth.Qty, ISNULL(CurrentMonth.SellTotal, 0)                       AS SellTotal, ISNULL(PreviousMonth.SellTotal, 0) AS PriorSellTotal FROM         (SELECT     SellTotal, InvoiceID, CategoryName, ProdName, Qty                 &nb ...Show All

• SQL Server Who knows how to generate a contents page consisting of Sub Reports?

  Is this possible , i hope it is:). Your help is very much appreciated. Hello Kenny, You might want to take a look at this post. Reporting Services does not support a table of contents, but it seems a few have found a work around for it. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=519067&SiteID=1 Hope this helps. Jarret ...Show All

• Windows Forms Form.Close() hangs when invoked from thread

  Hi, I have a windows form that starts another thread. When the thread's work is done, I want the thread to go ahead and close the form. To make it thread safe, what I did was the following: //This is a delegate private delegate void CloseFormSafely (); ... //This is in the thread that's defind in the form this .CloseSafely(); } ... //also in the form private void CloseSafely() { if ( this .InvokeRequired) { CloseFormSafely d = new CloseFormSafely (CloseSafely); this .Invoke(d); } else { this .Close(); } }   While this works all fine in VS.Net 2003, it for some reason doesn't work in VS.Net 2005 when I run in debug mode. The execution stops and ...Show All

• SQL Server RDA with Identity column.

  Hi Everyone: I am new to Mobile programming. I am now working on a mobile project. I encounter an issue when I sync the data: cause I can't modify the schema, so I have to use RDA instead of Merge replication on sql server 2005. However, There is an identiy column on each table I will pull them down to local mobile database. And I will use those identity columns to connect tables. Even worse, the photo's new name will combine the photoID which is an identity column. There would an issue, if i sync data, the photoID would be same on different local mobile databases. And there would be generate same identity value when users sync data. How can I avoid those issues If you have any good ideas, please help me out so that I can meet ...Show All

• Visual Studio Team System Index was outside the bounds of the array using WorkItemStore

  I've got a major problem with VSTS and everything that interacts with the Work Item Store (including creating new projects, running work item queries, creating new work items, etc.) generates a: Index was outside the bounds of the array. message within Visual Studio 2005. This problem isn't restricted to Visual Studio and also occurs if you try and interact directly with the WorkItemStore API. Here are the details from WinDbg if they are of any help: 0:000> !pe Exception object: 01e540b0 Exception type: Microsoft.TeamFoundation.WorkItemTracking.Client.UnexpectedErrorException Message: Cannot complete the operation. An unexpected error occurred. InnerException: Microsoft.TeamFoundation.WorkItemTracking.Client.ClientE ...Show All

• Visual Studio GAT not compatible with W2K?

  The GAT homepage lists " Windows 2000 Service Pack 4" as supported OS. But when I clone the SCSF guidance package (following the SCSF help) I get an error message when I try to register the new package (see below). It seems to me that the current GAT depends on the credui.dll that is not available under W2K. Is this an installation issue or an undocumented limitation Is there any workaround for registering my new Package on W2K Btw: I wonder how the SCSF installation was able to register the SCSF package! Note: the German text means "could not find the specified module". Hi, Are you running as admin when you try to register the package I know that in Windows 2000 registration of packages when running as non-a ...Show All

• Visual Studio Team System domain administrator password lock automatically.

  Dear all, i am system admin of corporate firm .yesterday i have chnage the password of my admin account and after that my account locked out intermediately with 2-3 min. senario of my site. I have exchnage server 2k3,2 ADC with win 2k3 server, 1 ISA 2000 server,1 EPO server(antivirus updation),1 application server .sql server loaded on EO and Application server. i think that due to change in password some of the application running on the server need authentication of old password so theu locked the account so i will restart all the servers and login with new password but the proplem was not solved. now iwill change the account name so that proplem is solved but if i again want to chanage the password of ...Show All

• SQL Server Cannot get CREATE LOGIN from a Windows group to work

  I have created a database fronted by an ASP.Net application. It's all nice and simple, and I only need a very simple level of security (and even that is only as a protection against accidents rather than maliciousness). My intention is that users connect using Windows impersonation (<identity="true">), with the database creator having full access and the public group (I'm talking SQL groups here) having specific premissions granted on specific tables. If I set <identity="false"> on my XP box the application connects to the database as [MACHINE\ASPNET]. This is easy to set up access for - I simply do a CREATE LOGIN [MACHINE\ASPNET] FROM WINDOWS and then within the actual database do a CREATE USER [MACHINE\AS ...Show All

• SQL Server Turning RDA tracking off

  I have a device application that simply needs to upload data to a server. The preferred DB server is Oracle but I've made it work using RDA and SQL Server. The problem I'm having is that it just needs to upload data, whichh I send using the RDA.Push() method. The data arrives just fine, the first time. With every subsequent upload all of the previous data is deleted fromt he server. Apparently RDA is tracking the deletion of the previously uploaded data locally and on the next .Push deleting that data from the server. My question is: Is it possible to prevent RDA from deleting data on SQL Server I attempted to delete the rows from the __sysDeletedRows/__sysRowTrack tables but got a "Data is read only" error. ...Show All

• Visual Basic Panel Opacity?

  Is there any way to make a panel have 50% opacity Panel does not have the Opacity property like forms so I do not believe there is a way. You could try asking this question in the Windows Forms group. If there is a way someone over there will know the answer. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=8&SiteID=1 ...Show All

• SQL Server Getting Column name when processing Error Ouput

  I am working on a SSIS package. I want error records to be redirected to a different table. Natively, the package passes the Error Code and Column Code (don't know what to call it, but it's a number). I found a script to get the error description, but can't find an equivalent to get the Column name. Any ideas Row.ErrorDescription = _ Me .ComponentMetaData.GetErrorDescription(Row.ErrorCode) It's not going to be possible. See: SQL Server Feedback Item 168857 ...Show All

• SQL Server Error 0xC020209C in Flat File Connection Manager in SSIS

  Hi, I got this error in a Flat File connection manager, it was saying that the last column caused the disk I/O Buffer overflow, whereas the last column contains 188 characters at max. Any Idea how to deal with it Thanks, Fahad ...Show All

• SQL Server Finding a Member

  Hi, I try to evaluate a functionality to find a date-Member. Wath we need is, we search the first existing Date in our Time-Dimension, which is, say 11 days before the actual-date. Since such a Member maybe not exits, the function should return the smallest existing Date bigger then the one we are searching for. MEMBER [MEASURES].[date1] AS DATEADD("d", -11, CDate([Zeit].[Zeit].CURRENTMEMBER.MEMBER_CAPTION)) MEMBER [MEASURES].[mydate] AS FILTER([Zeit].[Zeit].[Datum].members, cdate([Zeit].[Zeit].[Datum].value) >= [MEASURES].[date1]).Item(0) It doesn’t work in that way. Can anybody give me some Help. Thank you very much. Bahram. Sorry - I didn't notice that date1 was going against ...Show All

• Visual Studio 2008 (Pre-release) Databinding

  I am trying to build up a stackpanel of lists, with each list in a groupbox. The groupbox header is the name of the group as specified in an xml file. Within each list are photos in a stackpanel, which should be obtained from the same xml file as <Image>. Each photo should also have a caption (<Name>), also found in the xml file. The picture at the link below shows what is currently looks like without proper databinding. Picture here Any help would be hugely appreciated, targeted towards a beginner with not much experience in C# or WPF. Ripped off code below follows: <Grid> <Grid.RowDefinitions> <RowDefinition Height="*"/> </Grid.RowDefinitions> <ScrollViewer Grid.Row=" ...Show All

• .NET Development Connection string betwen vs 2003 and sql 2005 , last 2 yrs with sql 2000 worked and now giving me error

  i am using the folliowing connection string to pint to a server in my network(intranet) we were using sql server 2000 and worked well, and today upgraded to sql server 2005 and started giving the eroor: here is key which is used under web.config file. please help: <add key="QMain" value="Data Source=ServerName;initial catalog=pcsNet;persist security info=False;uid=user;pwd=password;"/> I am getting the error: saying sql server does not exist. Thank you very much for the information. Hello! Did anyone ever find a solution for this issue I'm having the exact same symptoms. I upgraded from MSDE 2000 to Sql Server 2005 (Standard), and now I cannot ...Show All