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.
Hello all,
Today we are going to learn how to write a stored procedure in sql server. The following code is a sample one. If you like it you can use this format for all stored procedure…
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO (more…)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…
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…
(more…)
Hi all,
Today we are going to learn how to make a distribution server for replication in sql server 2008.
Many people configure the distribution server using gui(graphical user interface).
But, i am comfortable with the sql server script. So, we learn how to make a sql server applicable for distribution using sql script.
At, first connect to sql server 2008 instances and then create a new query and copy the following code… (more…)
SQL Server Performance Tuning Expert
Small Business is Big Business™
skilled with python
Arnab's Blog 