Hello Friends, I have a table that I need to export to a pipe delimited .txt file.please follow the below step to do that things. Steps 1: [https://amitpatriwala.wordpress.com/2010/04/02/save-select-query-result-into-textfile/] Enabled the xp_cmdshell By default disabled in SQL 2005 for security reasons. To enable it, use the Surface Area Configuration tool or sp_configure To enable xp_cmdshell using […]

Here I am explaining how to export query results into text file. Please follow below steps to archive this thing. Step 1: Enabled the xp_cmdshell By default disabled in SQL 2005 for security reasons. To enable it, use the Surface Area Configuration tool or sp_configure To enable xp_cmdshell using sp_configure, use below query : EXEC […]

Hello, I have confused when I entering the right database credentials into the page but page is reload and shows the Database configuration again, without any error. I have start the search and finding that during the installation if you renamed the /sites/default/default.settings.php to  /sites/default/settings.php. Solutions: Copy the Settings File and rename it to default.settings.php. Thnx http://www.ibusiness-management.com/

Hello, This message appear because I use latest wamp software that utilize php 5.3.0 where ereg() function is deprecated. Solutions: step 1: Goto Folder Drupal\includes step 2: Select File “file.inc” step 3: Goto 902 Line elseif ($depth >= $min_depth && ereg($mask, $file)) { Change the function ereg to mb_ereg elseif ($depth >= $min_depth && mb_ereg($mask, […]

Here I Explained the New Data Type in Sqlserver 2008. What is HierarchIyd Data Type?  HierarchyId data type is a variable length System Data Type. What is the use of HierarchyId Data Type? Represent position in a hierarchy manner. HierarchyId does not automatically represent a tree, it is depend on how to application generate and […]

Here I am explaining Sql Server 2008 Key Features. 1) Initializing variable when you declare declare @val as int =0 declare @currentdate as datetime = getdate() print @val print @currentdate 2) Compound assignment operators –operator like +=,-=,/=,*/,%= declare @val as int = 0 set @val += 10; print @val 3) Add multiple row in single […]

what is URL rewriting ? URL rewriting is the process of intercepting an incoming Web request and redirecting the request to a different resource. When performing URL rewriting, typically the URL being requested is checked and, based on its value, the request is redirected to a different URL. http://msdn.microsoft.com/en-us/library/ms972974.aspx  why URL rewriting? 1) Make User […]

Here I am explain the crystal report problem during the development. I want to create Main report which having three sub reports. I create that report and call that report using asp.net but I have phase navigation problem. Problem : When Clicking the “Next” navigation button while on page 1 of Report Page 2 is […]

Here I am explaining how to create PDF Viewer in asp.net. Steps: 1) create Class Library Project Here I am give name OnlinePdfViewer. Here I am using c#.net. Write below code in to file. using System; using System.Collections.Generic; using System.ComponentModel; using System.Text; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace OnlinePdfViewer { public class DisplayPdf : […]

I have used the Flex Application with IE. Now I have change Browser and make it Firefox. There are two steps. 1) First Select Menu—> windows –> Preferences –> General  –> Web Browser… After that you may able to change the browser.   2) Go to Command Prompt and type ––> ftype http=”c:\Program Files\Mozilla Firefox\firefox.exe” […]