anantvemuri's Q&A profile

• SQL Server Getting Column Name on Error Redirect

  In SSIS packages, records which do not get processed successfully can be re-directed to different destination for logging or correcting purposes. With 2 additional fields ERROR_CODE and ERROR_COLUMN appended to the dirty row values. To indicate the specific error that has occurred and on which column the error has occurred, I have certain doubts on this error reporting mechanism in SSIS packages. The ERROR_COLUMN that is reported is not the column name but a number identifying that column uniquely. how can we at run time remap this column number to the exact column name Any help on this will be greatly appreciated. Thanks, S Suresh Try using this: http://sqlblogcas ...Show All

• Visual C# Change default audio output when playing files with MCI

  Hi, I'm trying to build an application that plays files through MCI. Example: [DllImport("winmm.dll")] private static extern long mciSendString(string strCommand, StringBuilder strReturn, int iReturnLength, IntPtr hwndCallback); mciSendString("open filename type waveaudio alias soundfile", _return, 0, _handle); mciSendString("play soundfile wait", _return, 0, _handle); This works fine. BUT, this function use the default sound device (set in control panel), and i need to play files on different devices... So, i can either change the default sound device just before i use the function above, or provide the deviceid( ) to a similar play-function. My questions are as follows, 1 - How can i chan ...Show All

• Visual Studio Express Editions Adding to listveiw on another form?

  I am making an application which has a parent and several children. I have benn using VB6 for years but the higher object coding is getting the best of me. I have a listbox on "form1" form and would like to add to it from another form "form2". I want to add to it when some serial data comes in. I have made a public property on the "form1" to add the value tothe listbox but it does not work. Any help would be awsome.. Here is the property that i call from "form2" to add to the listbox. Public Property Listbx1Add() Get End Get Set ( ByVal value) ListBox1.Items.Add(value ) End Set End Property Curt, My apologies, I don't ...Show All

• Visual Studio Express Editions Ready, Steady, Hang on a minute.

  To give me a break from the program that I'm working on, I've decide to have a go at a simple game, (That's a laugh, my last program was a Simple combobox to show the fonts on my system, it' now about 5000 lines of code and 4Mb, and still going thanks to an extreme beta tester ) Anyway I thought I would do I twist on tetris, still blocks falling etc but before I start and go wandering off into a maze of code, only to come here and ask for you guys to pull me out I thought I would start with your ideas and opinions. Would it be better to have pitureboxes dropping or drawn rectangles or panels or what Is there any help or info out there that I could look at to get the basic idea. Should I stop now and forget it All advice welcome and appreci ...Show All

• Visual Studio Express Editions loading large pictures in picturebox

  Hello. I'm working with large pictures (one of them is 4021x3123) and I want to load them inside o PictureBox so the user interacts with it (draws on it). The problem is after I load the picture, when I use the scroolbar to move around it, it has that flicker effect and also the interaction with my application has a delay (it takes about 1 sec for the other controls to react). I'm guessing my problem appers because of the large picture I'm loading, so is there a way not to load the entire picture inside the PictureBox and only load that portion of the picture that is currently dispayed by the PictureBox Is there a better solution to that Thanks. It appears to me that PictureBox.Mode AutoSize mak ...Show All

• Commerce Server Creating en-GB message manager

  Hi, I am working with the Commerce server 2007 site and need to create a satellite assembly dll containing the messages for the en-uk culture. Having tried copying the en-us folder from the bin folder and renaming it for en-gb and not getting the required results. I am going to follow the instructions contained in the MSDN article at http://msdn2.microsoft.com/en-us/library/ms962736.aspx to build a new dll file. Does anyone know the location copy of the original XML file containing the en-us messages so that I can be sure I enter the correct text for the messages specified in the web.config "resources" section Thanks in advance Paul Lemon ...Show All

• SQL Server Failover Cluster Option Grayed Out

  I have a mystery that I need a little help with.  I am trying to install SQL Server 2005 Std Ed. into a two node failover cluster running on top of Windows Server 2003 Enterprise Ed..   I have the cluster up and running.  It consists of an IP address, cluster name, a shared drive (E:), and an MSDTC resource.   When I run the SQL Server 2005 setup, the failover cluster option is always grayed out.  I have tried installing from the active node and from the cluster virtual server.  The result is always the same, no option to install a failover cluster.   Some suggestions would be appreciated.  I have read all the online docs I could find related to SQL 2005 failover clusters and found no ...Show All

• SQL Server Dimensions within Excel Pivot Table

  Hi I have a cube that has dimensions such as year, company, customer, statustext, employee etc. In the Browse in Analysis Manager - all the dimensions look fine. When I access the same cube from Excel after dragging and dropping the dimensions during analysis the dimensions in the Page section are not what is show when dragged to the row section. For example - i have a display Customer as rows, years as columns. I drag the statustext next to customer and shows customer. The filter in the page section for statustext is correct. I have tried moving the dimension back to the Field List and re-adding, refreshing from the cube makes no difference. The only solution I have been able to come up with is rebuild the Pivot table - not wh ...Show All

• SQL Server How can I stop or continue package execution based on variable value

  Hi, I need to make my package check a variable value at the begining of the execution and depending on the value of that variable it decides either to continue or stop the package execution. How can i do that thanks, Aref Hi Aref, Check out a similar sample @ http://mystutter.blogspot.com/2006/03/sql-server-integration-services.html Thanks, Loonysan ...Show All

• SQL Server Performance issue on SQL 2000

  Queries are performing much slower on production server - configuration 8 GB RAM 4 CPU and database size 500 MB Same database and application works much faster on development server - 4 GB RAM 2 CPU and copy of production. Compared one of the most important query and found - both servers are using different query plans - cleard the cache - Compared all settings of sp_Configure - they are all same. Same version of patches. Same edition. Production it takes 18 seconds and dev/test it takes 1 second. Production has awe enabled - thats only enviorment difference. Can someone tell me what else to look about this slowness Thanks for all help in advance Manoj Statistics are upto date, also rebuilded the index with dbcc ...Show All

• SQL Server total numer of records

  Hi, I have 10 databases created. each data base has arround 100 tables . i need to keep track of the number of records in each table of 10 databases and the last modification date on that table. The solution should be programatically by running a T-sql program or any stored procedures or any other but mechinical. the output should specify the following: Table #number_of_recs Last_date database_name.Table_name ###,###,### DD/MM/YY I will appreciate any assistance in this regard. thanks, use your system tables and some of the system procs, like sp_spaceused. You'll need to use a cursor, but I do this frequently on my databas ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. xnb file shader

  when i have to release my game engine it comes with prebuild shader for win and xbox is there any form i can store copyright info inside the shader or pehaps store some file info in my engine so i prevent people from steel my shaders yes that is true my engine comes in full source code and a full source code of a sample game but the onlye thing that is prebuild is the shaders why i speed 8 month to create the shaders before mdx 2.0 and after and now in xna and it is a god set of shaders that work together thies shaders you cannot find them in a 200 milion games to day , what i have implanted is this please read this paper , mabye you can understand why i just wont just release the shaders http://ati.amd.com/d ...Show All

• SQL Server Intra-query Paralleism caused your query to deadlock . . .

  We often get the above message from our Sql Server 2000 Transactional Replication Distribution service. How do we implement the OPTION (MAXDOP 1) hint as directed It seems I would have to modify the MS procedures. Can't do that. Any suggestions Michael I originally posted this in the Replication forum but was ignored so I thought that perhaps a more "general" forum would attract a different kind of contributor . . . Are you suggesting that the max parallism for the entire server be changed to 1 Is that the solution Will setting this option affect other queries in the system What are other DBA's doing to solve this problem I am concerned about the performance impact on the other q ...Show All

• .NET Development Updating tables in access

  Hi there, I havent worked with VB much so i have a question I have a table (table1), with 5 coloumns in access. & I have a .txt file which is generated as a comma seperated values file, which is to be updated into this table. so i havea txt file heading1,heading2,heading3,heading4 col1,col2,col3,col4 i want to update this file in an access table, using the date/time(or u can say col4), all the records in that txt file later than the date/time of the last record in the access table should be added to the table. is there a way this can be accomplished in VB reguards Saad This will require a couple of steps. First you will need to retrieve the max date in your Access tab ...Show All

• Visual Studio Express Editions Stuck inserting into access

  Hi Guys im stuck updating a selected record in my project :o), i know sql part works(See method 2 for correct statment) as i done it inside access :o) both the pasted methods give me an error Method 1 Dim strTEST As String strTEST = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=N:\Inspectors\Database\Inspectors.mdb" Dim sqlConnection1 As New System.Data.SqlClient.SqlConnection(strTEST) Dim cmd As New System.Data.SqlClient.SqlCommand cmd.CommandType = System.Data.CommandType.Text cmd.CommandText = "UPDATE Region SET RegionID = 1, RegionDescription = 'East' WHERE RegionID = 1" cmd.Connection = sqlConnection1 sqlConnection1.Open() cm ...Show All