NipplesAndLicks's Q&A profile

• SQL Server Slow Running Insert After Changing OLE DB Destination Data Access Mode

  Hello, In a Data Flow Task, I have an insert that occurs into a SQL Server 2000 table from a fixed width flat file. The SQL Server table that the data goes into is accessed through an OLE DB connection manager that uses the Native OLE DB\Microsoft OLE DB Provider for SQL Server. In the OLE DB Destination, I changed the access mode from Table or View - fast load to Table or View because I needed to implement OLE DB Destination Error Output. The Error output goes to a SQL Server 2000 table that uses the same connection manager. The OLE DB Destination Editor Error Output 'Error' option is configured to 'Redirect' the row. 'Set this value to selected cells' is set to 'Fail component'. Was changing the access mode the simple reason ...Show All

• SQL Server Filtering In Merg replication

  Dear ... This is one of sql server 2005 's users. I put filter for one of my merge replicate articles .But it dosent work correctly .plaese help me to set my article correctly. Best regards R.Marandi Dear Michael Hotek, Hi, Thanks for your attention ,we are working in a drug distribiution company and have a database of sales and inventory .also we have some centers in other provinces that we should connect them everyday and get their information.That information is special for their center.Each center have special and uniqe code for itself on sale and inventory 's table . we run the sale and inventory 's agents everyday for gathering the information of centers in the centeral offic ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Cylinder between two vectors

  I have tried rotate this thing on every axis and I still can't get it right. what I am trying to do is draw the single bond between two atoms. Does anyone have an example of the math and steps to do this. I have two atoms in my world and I have the cylinder(bond) in between. I just can't get it to rotate 90 degrees into place.If the cylinder is laying on its Z axis that mean my Z axis is pointing straight up. What am I do wrong This depends on how your cylinder is orientated in your world when no transformation is applied to it. Generally, you rotate it then move it around using a transformation matrix that can be built with the D3DXMatrixRotation*() and D3DXMatrixTranslation() functions... Read more on ...Show All

• SQL Server Alternate color on groups.

  How would you alternate the color in a grid based on a grouping. IE. (the 1000 Users should have background color of White and 2000 background would be WhiteSmoke) ColumnUser ColumnNote 1000 Note1 1000 Note2 2000 Note1 2000 Note2 Try using the following expression for the BackgroundColor property. =iif(RunningValue(Fields!ColumnUser.Value,CountDistinct,Nothing) Mod 2, "White", "WhiteSmoke") ...Show All

• Visual Studio SP1 silent install

  How can i install VS2005 SP1 silently (with no prompting) I need this because of the Colossal amount of time it takes for this SP to install. I have to leave it running over night, but in the morning there is another prompt, and it sits there processing again for ages, and i just give up. Running it silently would let it install overnight by itself. Btw, why does it take so long to install (i gave up after like 2 1/2 hours; hit Cancel). Shouldn't it be like: dump the new dll's and content into the install directory using File.Copy :) there is a way to silently install SP1 I believe...but cant locate it! this is the unattended approach, it should be the same thing as the Silent install except this is ...Show All

• SQL Server Normalisation question?Help

  I have an unnormalised data, and i would like to know if im normalizing the data correctly. It my homework, and its my first time doing normalisation as its so hard to understand. Thanks in advance. UNF Course code Course title Student Code Student Name Address DOB Telephone number Module code Module title Tutor code Tutor name 1NF Student Code (Primary key) Student Name Address DOB Telephone number ---------- Student Code( Foreign key) Course code (Primary key) Course title Module code Module title Tutor code Tutor name 2NF Student Code (Primary key) Student Name Address DOB Telephone number ---------------- Course code (Primar ...Show All

• Visual C# How to read the "% Processor Time" counter from a local computer?

  Hi all, I am looking at some sample codes that will show me how I can instanciate the Processor object and then display the _Total instance of the "% Processor Time" counter. I've seen samples that shows you how to create a category/counter but they don't show you how to display the currently value of a specific counter. The idea is to build a web service and pull data counters from remote web servers. Thank you so much Joao Hey OmegaMan, Sorry to come back in this issue again but, is there any chance I am able to retrieve the "Average" value of a counter. For instance, the NextValue() method returns me the "Last" value in Performance Monitor. Bear in mind that Performance Monitor re ...Show All

• Visual Studio Express Editions Ending a Sub

  Hi there, I have these IF statement and after it finds the first one which is true I want it to stop the Whole Sub. Thanks, AliQ Another alternative is: Return or, if it's a function: Return {valueToReturn} ...Show All

• .NET Development How to get the owner of a service?

  It was not immediately obvious how to list the services running on a system using managed code, but I later found out that adding a reference to System.ServiceProcess and using System.ServiceProcess.ServiceController.GetServices() did that. However, now I'd like to get the owner/host of a service. I'm trying to do a helper application for the cases where e.g. svchost or other processes running several services locks up or consumes a lot of memory, so this would be very useful. Something like a Parent or Owner property on the ServiceProcess object returned by the GetServices() call above, but unfortunately I can't find such a property. If I could make this connection, I would be able to graphically associate the various services to their re ...Show All

• Visual Basic Creating Application Settings at Run Time

  Is there a way to create application settings at run time (My.Settings.Add....... etc) Cheers Hiya, I managed to find these articles before but I'm still confused as to how you actually create them within code. Could you provide an example if possible Thanks ...Show All

• Visual Studio Express Editions Debugging: F8, Ctrl-F8

  After installing VB.Net Express first time additional to the menu itme 'single step F8' there was a menu item ^F8 that allowed me to go back an forth in my code when the programm had been stopped on by breakpoint. Since some weeks this item has gone. Reinstalling VB.Net did not help. In the Options I did not find a switch for this feature, so I would like to know whether this feature generally has been taken out or whether there is something wrong in my installation. Is there a means to regain the possibility to go back an forth in a halted programm I believe that the step into and step out of default shortcut keys are F11 and Shift-F11 respectively... However you can setup your own keyboard shortcuts ...Show All

• Visual C# Defining custom functions for code snippets

  Code snippets allow you to use functions to do some processing on the data that gets inserted. AFAIK, currently there are only three functions available for C# (for instance SimpleTypeName). Would it be possible in any way to expand this set of functions For instance, I'm looking for a CamelCase function to be able to create a code sinppet that outputs code such as this: private int _myNumber; public int MyNumber { get { return _myNumber }; } Because of this naming convention, I only want to specify the type and name, and not as in the current propg code snippet, also specify the fieldname. Any ideas You might check here: http://www.devexpress.com/Products/NET/IDETools/CodeRush/ ...Show All

• SQL Server How to remove ALL as a dimension member

  Is there a way to remove the ALL member that Analysis Services adds to each dimension thanks. In Analysis Services 2000 you can change AllLevel property of the dimension from Yes to No. In AS2005 you to navigate to the highest level in the hierarchy in your dimension and for the corresponding attribute you change IsAggregatable property from True to False. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Windows Forms Iterating through the DataSource property via a Foreach Loop

  I've created a custom drop down list control which inherits from DropDownList: public partial class CustomDropDownList : DropDownList I need to add a method to this class which will iterate through the items contained in the DataSource property via some sort of loop (foreach or for) and attempt to match one of the items to a variable value that is set earlier. But I can't figure out to loop through the DataSource property. If anybody can show me how to do that I'd be very grateful. Thank you in advance. Sean. When you create a DataSource for binding, you'll have a DataSet created for you. In the form_load event, you'll probably find something like this.[tableName]Adap ...Show All

• SQL Server CLR procedures for SQL Express with VB Express

  Hello, Does anyone know if is it possible to create CLR procedures for SQL Express with VB Express Regards, Hi, Do you have details how to do that I'm new to SQL 2005 and I can only find information about creating CLR procedures pointing to Visual Studio Database Project, which is not available on the Express version. Thanks ...Show All