How to use OPENROWSET command in sql server

Dear all,

Sometimes we need to copy the data from access db to sql server. For transferring data we can use openrowset command.
For using openrowset you need the Ad Hoc Distributed Queries component turned on.
But, by default this component is being turned off for the security of server. But you can turn it on for using the openrowset command.

Create transactional publication in sql server 2008

Hi all,
Today we are going to learn how to create a transactional publication in sql server 2008. You may create it by using gui of sql server management studio. But we learn using sql script. Just copy the following code and enjoy…

Debugging codeigniter with firephp

Hi all,
Today we will explore how to debug the codeigniter application with firephp a extension of firebug. For this you have to install the firebug with your firefox browser.

Than, you have to download the firephp library. You can download from here or here. After downloading the library you have to copy it to your application/libraries directory. And then load the library as..

$this->load->library("firephp");

And finally to debug your code just write the code as follow…

Removing Distribution From Sql Server

Hello all,
Today we learn how to remove distribution database from your sql server.
Dont try to delete the distribution server directly. If you delete the distribution database, its actually not deleted, then you have to reinstall the sql server. So, to avoid this mess up please copy the following script and run in your sql server…

Integrate twig with codeigniter and codeigniter hmvc

Hi all,

Today we learn how to integrate twig template engine with codeigniter and also with codeigniter hmvc. At first, you have to download hmvc third_party for module integration in your latest codeiginter. You can download from here.

After download the file extract the file and you find two folder “third_party” and “core”. You have to copy the “MX” folder to your codeigniter “third_party” folder and copy the files from “core” to your codeigniter “core” folder. After copying this just add the following line to your “autoload.php”

Integrate jqgrid with codeigniter

Today we learn how to integrate jqgrid with codeigniter.

At first, write a model in your application/model directory. The code is ….

class JqgridSample extends CI_Model {
function getAllData($start,$limit,$sidx,$sord,$where){
    $this->db->select('id,name,email,passport,phone,fax,address');
    $this->db->limit($limit);
    if($where != NULL)
        $this->db->where($where,NULL,FALSE);
    $this->db->order_by($sidx,$sord);
    $query = $this->db->get('info',$limit,$start);

    return $query->result();
}

}