If you are using SQL Server 2005 and not able to connect to it remotely, then check out this useful blog post.

Let's create and populate some tables so we have some data to work with. Assume you have a sales effort management (SEM) system that allows you to track the number of sales calls made on a potential client. A sales call is not a phone call, but a get together such as lunch or another type of person-to-person meeting. One of the things the VP of Sales wants to know is how many of his sales personnel participate in a call. The following tables allow you to track this information.

   1: CREATE TABLE Employees

   2: (

   3:     Emp_UniqueID smallint PRIMARY KEY,

   4:     Emp_FName varchar(30) NOT NULL,

   5:     Emp_LName varchar(30) NOT NULL,

   6: )

   7: go

   8:  

   9: CREATE TABLE SalesCalls

  10: (

  11:     SalCal_UniqueID smallint PRIMARY KEY,

  12:     SalCal_Desc varchar(100) NOT NULL,

  13:     SalCal_Date smalldatetime NOT NULL,

  14: )

  15: go

  16:  

  17: CREATE TABLE SalesCallsEmployees

  18: (

  19:     SalCal_UniqueID smallint NOT NULL,

  20:     Emp_UniqueID smallint NOT NULL,

  21: )

  22: go

More...