Recent content by sweth

Thanks much dinger for your pointer. It worked perfectly. It looks like we need to perform this everytime we change port ? Thanks , Siva

I had installed Sharepoint in default port and uploaded few documents under Documents link. Latter I had changed the port number of Sharepoint site. After that whenever I click documnet link it is going to http://sitename/doc/ instead of http://sitename:81/doc. Any idea how to fix this ? Thanks...

You use xml source adapter XML Source adapter - Drag and drop a Data Flow task from the toolbox - Double-click on the added task - Double-click on the XML Source in the data flow toolbox - Double-click added component on the diagram Thanks and Regards, Siva

CHECK MYFUNCTION IS CREATED WITH DBO SCHEMA IN DBTABASE B.

You can insert from a result set returned from a select queries INSERT INTO TABLE_C SELECT USER_ID ,EMP_ID ,.... FROM TABLE_b JOIN TABLE_c ON MATCHINGCOLINTABLE_C = MATCHINGCOLINTABLE_a JOIN ----- Hope this helps. Thanks and Regards, Siva

See this helps DECLARE @ptrval binary(16) SELECT @ptrval = TEXTPTR(item) FROM table WHERE whatever criteria UPDATETEXT table.item @ptrval NULL 0 'new text'; Reference http://www.perlmonks.org/?node_id=578924

You can update a table based on join condition of another table and isssue select queries also. Update A Set A.Field1 = B.Field1 From A Join B on A.Field2= B.Field2 Where .... Thanks and Regards Siva

Hi All, I have two isp connection with Public ip available in both of them, which are connected to two routers. How can we configure DHCP so that if one connection is down, it should automatically switch to second isp connection ? Thanks in Advance, Siva

1. Go to IIS MMC Console by clicking start --> Run -> type inetmgr, 2. once internet service manager mmc opens up, click on web server extension, Go to Active Service pages , click on Allowed button. This will enable ASP server extension in Windows 2003

Hi, I try to simulate your requirement. Assuming you have table like that create table distinctTest ( id int identity , ColA varchar(30), ColB Varchar(40) ) declare @i int set @i = 0 While @i < 100 begin insert into distinctTest (ColA,ColB) values ('A'+ cast(@i as varchar(30)),'B' +...

One way is select Group10 = (select count(*) from person where age between 0 and 10) ,Group20 = (select count(*) from person where age between 10 and 20) ,Group30 = (select count(*) from person where age between 20 and 30) Does it solve your problem. Let me know from group is there any...

Sorry hit the send button before completing the message, As Denny said your connection will get pooled if you use same connection string. May be an encrypted connection string in web.config file will be handy for this. Sweth

Check that you are using same connection string and not changing it in your application, ie

Hi ITheadache, Have you solved this problem ? If not, look wireless router allows outbound or inbound http request. Reroute port 80 request to your IIS Server It is typically Port # InBount/Outbound RedirectIP 80 Both LocalIP of AP

If the questions are populated dynamically , store max question in a variable and name radio button group in such a way that rgQ1,rgQ2 etc., then after submiting for loop substitue radiobutton rgQi with index, collect values and store it db. Let me know wheather others got better logic than this.