I think you are trying to insert a value into a identity column. If you are inserting the value into intentionally then you have to set Identity_insert tablename on/off. else ignore this column while inserting, sql server automatically inserts records into this field.

Hi, I am trying to shred values of ModuleTorulemapid,selecteditemid and customvalue from following xml in SQL server 2005. For this purpose, I have written following code, but not able to shred it properly ---------------------------------------------------------------------- EXEC sp_xml_preparedocument @IDoc OUTPUT, @RollForwardRuleXML SELECT DISTINCT ModuleToRuleMapId 'ModuleToRuleMapGUID',SelectedItemId 'SelectedItemGUID',[UniqueIdentifier] 'OperationGUID', CustomValue FROM OPENXML(@IDOC,'/ROOT/RuleBuilderModule/RuleBuilderRule/RuleBuilderOperation /RuleBuilderItem ',2) WITH(ModuleToRuleMapId UNIQUEIDENTIFIER '/ROOT/RuleBuilderModule/RuleBuilderRule/@ModuleToRuleMapId', SelectedItemId UNIQUEIDENTIFIER '../@SelectedItemId', [UniqueIdentifier] UNIQUEIDENTIFIER '../@UniqueIdentifier', CustomValue NVARCHAR(50) '@CustomValue' ) EXEC sp_xml_removedocument @IDOC ----------------------------------------------------------------------- Following is the XML which I am using ----------------------------------------------------------------------- <ROOT> <RuleBuilderModule Name="RollForwardMethod" UniqueIdentifier="6d6800a6-9006-4d65-a579-731872b16004" Timestamp="0"> <RuleBuilderRule Expression="Which method, automatic or manual, do you want to use for roll forward? <38fc8c42-c1ba-4843-81a4-69d8b9b21b98>" LockedStatus="3" ModuleToRuleMapId="93d552ea-5d8b-4cbd-b936-030ea4fca60a" RuleType="Question" IsBubbleHelpRequired="False" UniqueIdentifier="b88e94f3-48dc-4ce8-ae0c-be17c1133486" Timestamp="0"> <RuleBuilderOperation Name="RBuildMthdAutoManual" ValueSource="Internal" DisplayStyle="Multiple" SelectedItemId="45d72595-c7b7-41e4-bea3-1ffefa9bbfae" SelectedItem="Cch.WorkFlow.BusinessEntities.RuleBuilder.RuleBuilderItem" DialogType="ComboStyle" UniqueIdentifier="38fc8c42-c1ba-4843-81a4-69d8b9b21b98" Timestamp="0"> <RuleBuilderItem Name="Automatic" IsDefault="True" CustomValue="" UniqueIdentifier="45d72595-c7b7-41e4-bea3-1ffefa9bbfae" Timestamp="0" /> <RuleBuilderItem Name="Manual" IsDefault="False" CustomValue="" UniqueIdentifier="b0e4538f-8dc0-46d0-925e-f4a52e0ffdc6" Timestamp="0" /> </RuleBuilderOperation> </RuleBuilderRule> <RuleBuilderRule Expression="Rule: Automatically roll the project <363afba8-df04-4af2-a661-dc458bb55f5d>" LockedStatus="3" ModuleToRuleMapId="d5aeeaa7-09d9-4b33-aff9-74cedef43814" RuleType="Rule" IsBubbleHelpRequired="True" UniqueIdentifier="6ee47614-4632-498e-a619-

Hi Dave Thanks Dave. Even i tried to send the keys but problem is when you are using send keys if target exe don't have any shortcut keys then it will not work. Thanks once again.

Hi Christian Thanks for reply. I am using VB6 to do this. The exe what i am using is not developed by me. So i don't have source code of that exe also.

Hi All, Assume that you have an exe. Now you are creating a new application which opens or launches the existing exe. Launching an exe from your application can be done using Shell command. Now my question is with out opening that exe you have to do operations what you are doing in that exe. eg: If are able to create new record in that exe then from your application you should be able to activate the new button in that exe.? Thanks Omprakash

Hi, In MS SQL 2005 the ID column of Sysobjects table is Int. It means that you can create Max of integer. The integer datatype can hold value up to 2^31.

Insert into CreateTask(AssignedTo,AssignedDate,EstimatedEfforts,Priority) values ('ABCD','2007-8-11',30,'Medium' In VB u have format function. U can use this function to format the date. i.e. YYYY-MM-DD format.