Bernaridho's Q&A profile

• SQL Server Why does "READ UNCOMMITTED" still seem to block other transactions?

  We heve a lot of sql queries which are real pigs, using DISTINCT and GROUP BY, and lots of views in their joins. They seemed to run forever so some know-it-alls added "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" to the beginning of these queries and declared "Victory!" Well, these same jobs do behave a little better, but they still seem to block other jobs, including Replication Distribution (causing time-outs.) My obervation is that the above Set statement is not the equivalent of "read with no impact upon other transactions." What do you think Has Microsoft published anything on this subject that is useful If so, where is it so I can read it Thanks alot, Michael ...Show All

• SQL Server Looking for sqlrun_tools.msi

  Today my computer started doing something strange when trying to compile a setup&deployment project. This project doesn't contain anything related to sql server whatsoever. When i compile, it pops up a windows installer dialog that starts doing something. Eventually it asks me for my Sql Server 2005 Tools disc, specifically looking for sqlrun_tools.msi. I tried putting in the disc that i'm pretty sure it was installed from (my MSDN disc) but it told me that the sqlrun_tools.msi on that disc wasn't the right one. I have no idea why its asking me for this at this time, nor do i know to do to get it to stop. Thanks in advance for any help. Do you still have the SQL Server 2005 Tools installed ...Show All

• .NET Development SqlDataAdapter: Unable to save data in a SQL database, What's wrong?

  Hi All, I am unable to save data in a SQL database, What's wrong I am coding with VB .NET and I am unable to retrieve data from the database, beside I can read from the database without problems. How can I do, This thing is driving me crazy, it is 4 days that I am tryng to write in the database and I ahve tried everything update, insert. Somebody Know how to manage the SqlDataAdapter, beside the SqlDataReader is working perfectly. I am not used to the SqlDataAdapter. Is there anyone who know how to write in the database or where I am in mistake Thanks in advance. Here is the code: Dim oCmd As SqlClient.SqlCommand Dim oDR As SqlClient.SqlDataReader Dim strSQL, strSQL1, strSQL2 As String Dim adapter As System.Data.SqlClient ...Show All

• Visual Studio Team System Why does Rollback require copying all source files locally?

  Hello, I had to rollback a few incorrectly checked-in changesets, and I discovered that in order to do this I had to fetch the whole version control repository locally. I.e. all branches for all projects had to be copied on my machine before I could run a rollback. Is this necessary Why Think of a large source repository for a company with hundreds of developers. Second issue was that it was not possible to rollback several changesets at a time. And sometimes this is what is needed (several "wrong" check-ins in a row). Isn't it a good idea to support "composite" rollback, i.e. rollback that works on a multiple changesets Vagif Hello, I understand you are using PowerTool tfpt rollback. Tfpt rollback requires your workspace ...Show All

• Visual C++ Add function or variable bug

  I open VS2005. I create a Class Library CLR project. A default class is created called Class1. I go to Class View. I click on Class1. I right click and choose "Add | Add Function..." and receive an Error message box with the message of "A Runtime Error has occurred. Do you wish to debug Line: 842 Error: 'ParameterTypeValueLength' is null or not an object." If I then click No I am taken to another Error message box with the message of ""A Runtime Error has occurred. Do you wish to debug Line: 498 Error: Object doesn't support this property or method." If I then click No I am taken to the "Add Member Function Wizard". Is this a known bug Yes, you are certainly r ...Show All

• Windows Forms Hooking a Event to a button

  I have a Form With a button i need to load it in runtime and associate a click event for another class but in the following code i am not able to add the event to a control.but if i give forms object in addHandler.Invoke() its working fine. How to get the Control's Instance Pls help me private void HookUpDelegate() { // Assembly assem = Assembly .LoadFile( @"D:\C#_Test_App\FormDesign\bin\Debug\FormDesign.dll" ); Type tExForm = assem.GetType( "FormDesign.Form1" ); Object exFormAsObj = Activator .CreateInstance(tExForm); FieldInfo [] fields = tExForm.GetFields( BindingFlags .Instance | BindingFlags .DeclaredOnly | BindingFlags .Public | Bind ...Show All

• SQL Server Replication Trigger Problem (SQL 2005): Assistance Please

  Our company is wanting to replicate a bunch of data down from our central server to tablet PC's. We really do not have anyone on staff with solid experience in replication, and have hit an error that we cannot seem to find any information whatsoever on. Here is the problem: When setting up a publication to replicate certain tables, we stop being able to do any updates on the tables. After some research, we were able to narrow the problem into the msrepl triggers the publication places on the table. In the update trigger of the table, the following line is being placed by SQL Server: execute sp_mapdown_bitmap 0x0000000040, @bm output The sp_mapdown_bitmap call, passes through to a xp_mapdown_bitmap call (limited documentation I ...Show All

• Visual C# Windows Vista

  Hi, I am not able to install SQL Server 2005 and Visual Studio 2005 Beta 2 on Windows Vista RC1 environment. I got a error when the installer trying to install .Net Framework 2.0. Please help me how to rectify the error and also let me know if you want more information. Regards, dotnetsekar You cannot install .NET Framework 2.0 Beta 2 on Vista RC1 because Vista RC1 already contains the final version of the .NET Frameworkd 2.0. So you cannot install SQL Server 2005 Beta 2 and VS 2005 Beta 2 either. You need the RTM versions. ...Show All

• SQL Server How to launch package from client machine, display progress and finally results?

  Please help. I'm completely new to SSIS, and I was hoping someone could point me in the right direction(s). I am developing a winforms client app, and I need to be able to provide the user with the ability to import data in CSV format into our application's database. I'd like to use SSIS if possible, as long as what I am trying to do isn't near impossible. I'm thinking of a UI where the user can specify a flat file (CSV) to upload and be processed by an SSIS package on a remote database server. This package will be responsible for validating the CSV file and inserting data into the database as appropriate. Is there a way I can: launch an SSIS package remotely, from a winforms app on the client machine that is not runni ...Show All

• SQL Server Drives in a cluster environment

  Hi, I have a SAN and configuring a cluster on SQL 2005. I initially created a Quorum drive when setting up the cluster and now added 4 more drives to the physical node but when I try to install SQL that drive cannot be located. Do we need to create all the drives when installing the cluster or what is the way to add the drives later on. Thanks Anup For failover clusters, you always need to think in terms of "units of failover". If you put the MSDTC data on the same drive as the quorum, you would need to tie MSDTC to the cluster service. You then create dependancies between MSDTC and the cluster service that shouldn't be there. In general, you want to think in terms of a service and its associated reso ...Show All

• Visual Studio Express Editions String it together

  Hi, Please let me know if there is away to manipulate a string so that if there is a comma directly after a number [see below] then it is replaced by a space. Before AXA_Data, 39, Trust_Acc, Jersey, T=Y, ********,***,**** AXA_Data, 372, Trust_Acc, Malta, T=Y, ********,***,**** AXA_Data, 03, Trust_Acc, England, T=N, ********,***,**** After AXA_Data39, Trust_Acc, Jersey, T=Y, ********,***,**** AXA_Data372, Trust_Acc, Malta, T=Y, ********,***,**** AXA_Data03, Trust_Acc, England, T=N, ********,***,**** I hope it makes sense, Jason Hi thank you for the prompt response and wonder if you can tell me how to modify the code so the output could look like the following: ...Show All

• Smart Device Development Making forms appear sooner

  I'm developing an application in VB .net and have several forms that call one another. It basically works but it takes too long for the called form to appear sometimes. The desktop appears for a few seconds giving the momentary impression that the program has stopped. I have some lengthy initialization processing that has to occur in the load event of each form now. Is there another event where I can put the initialization processing so the form will appear before the initialization processing starts it depends on the nature of what you're doing in init. can you move the routines to Activated, Load, OnActivated, or something similar Use the IDE's Intellisense to explore the various events available to you. ...Show All

• SQL Server How to list all tables ordered by their size within a SQL Server 2005 database?

  Hi, all, Would please any expert here give me any guidance and advices for how to list all tables sorted by their size within a SQL Server 2005 database Thanks a lot in advance for that. With best regards, Yours sincerely, Hi, A similar kind of query I've seen on a site. In the example given by the author of the query, he used Dynamic Management Views. You can find the original query from here http://www.extremeexperts.com/SQL/Scripts/FindSizeOfTable.aspx As per your requirement, I have made some changes to the query. Here it is WITH table_space_usage ( schema_name , table_name , used , reserved , ind_rows , tbl_rows ) AS ( SELECT s . Name , o . Name , p . used_page_count * 8 , ...Show All

• Smart Device Development Device Emulator and XPe

  I have built Windows XP Embedded and everything is fine, but when I start Device Emulator and try to load saved-state file, I only see the message: "Couldn't read the saved state file". But when I do coldboot and then I try to save it, I see the message "Couldn't save the saved state file". I don't know where is the error, because in Win XP pro it is working normally. I think that I forgot to add some components in target designer. Thank for reply, but all these dlls are in system32 folder. Can you tell me which files depends on these dlls. Sorry for this stupid questions but I'm begginer. ...Show All

• Visual Basic printing a hard copy

  So i have an app that has text boxes, labels, and comboboxes. the program populates a database. What i need to do now is Print a hard copy of the data (from a command button on the form) and send an email to someone (through Outlook).. Can anyone point me in the right direction on how to do this Thanks. Ian. how do i choose for it to only read certain controls and not all of them I.E. only the textboxes and labels, not the buttons... ...Show All