Link Server In SQL Server 2005

Sometimes we would like to create distributed query across different server and database, this circumstance was called "Linked Server" Make sure you have two different server or two different Database Instance, Iam here have SQLSERVER EXPRESS 2005 and SQL SERVER 2005 STANDARD EDITION, the point that you should keep in mind is 'Linked Server was dedicated for distributed query on different Database Instance' whether that is SQLSERVER or other datasource like DB2, ACCESS or EXCEL, on this occasion  I'am going to take SQL SERVER as example. In sql server we can easily make linked server by doing these following steps.

1. You have two instance or more

   

2. Fill the parameter according to this screen cast.
   

   Here detail explanation of the above

   1. Linked Server : Type the linked server that you like to define.
   2. Server Type : specify the server type as Other Data source
   3. Provider Name : Microsoft OLE DB Provider fro SQL Server
   4. Product Name: This was optional, you can fill by empty string
   5. Datasource : This parameter consist of your Server Name and Instance Name, Iam here using ".\SQLEXPRESS"
   6. Provider String: just let it be like that
   7. Catalog : Reflect the database that you would like to access.

Accessing Web Services Using Javascript

I will demonstrate how to acccessing WebMethod(WebServices) using Javascript, this is very simple, and sometimes you will need it when you face the condition to validate the field plus you should check/validate it by sending the data to server, not neccessary when you validate at the server, but when comes up to validate in client side, I meant the trigger was on client script, using javascript as example, then this point can be your solution.

I build DataAccess class with implement with “IDisposable” to manage garbage collection, I named this DataAccess.cs.

Read more »

Create New Sql Server Login / User

Sometimes you would like to create SQL Server account to be able access the specified database than just let it be accessed by computer local admin,  this case comes up when you would like to keep the application just only accessed the specified database only. This approach was the most recommended for better user management. Here are the steps

Read more »