SQL Server in SBS2000

From: Torrey Lauer (anonymous_at_discussions.microsoft.com)
Date: 06/02/04 

Date: Tue, 1 Jun 2004 21:56:05 -0700

I would like to setup a database using SQL Server, but I don't even know where to start. My terminology may be off a little since I've never used SQL before.

I would like to have several databases that also use forms. The first database I'd like to create would be used for our outside agents (agents that aren't in our main office). I'd like to have a place for our agents to go within our existing agent's only site in order to search for a vendor by name and/or click on a drop down bar to select the vendor. Once the vendor is chosen, it would display information that I would have already populated (ie: vendor's reservation number, vendor's website address, commission levels that we are at with that particular vendor, and any other notes that I would have listed for that vendor).

Another database I'd like to have is one for call tracking. I don't know if this would work for this type of senario, but what I would use it for is for our agents to create a new "call tracking record" when they take a call. This would tell us how many calls the agent is taking (ie: if we are able to use reports to see how many call tracking records the agent created), who they talked to on that call, what transpired on the call (ie: client wanted a seven day cruise to the caribbean...wants to visit St. Thomas, St. Marteen, etc. Two person are going, wants junior suite with balcony...I quoted $1,500.00 including taxes, without airfare, per person...etc...). That way, if that agent isn't in the office when that client calls back to book the cruise or ask more question about the package the agent quoted, we can pull that record up and read what the agent has already told that client.

So, I hope I got the idea across on what I'd like to do. Now, what I need to know is, will SQL work for these senarios? What program do I use to create the databases? Am I able to work right in SQL to set the databases up, create the fields, populate the fields, etc...?

I was thinking of using Access to do the call tracking, but I was thinking that I'd like to have one place to have all this information.

Can anyone provide me with some answers, some go to places to read about SQL and how to use it, any books that would help me out? I've tried looking at Microsoft's site about SQL and even did a google search for SQL, but before I buy any reference books, etc. I'd like to find out some do's, don't's, be carefuls, this works, that doesn't work, etc. from you guys.

I appreciate any help any and/or direction any of you can provide me!

Thanks!

Torrey Lauer
Modern Travel Services

Relevant Pages

  • VB6 Application Install
    ... ability to upgrade a SQL Server database, if needed, depending on the nature ... Create a Database if it does not already exist ... Continue on with application SETUP... ... ODBC, install MDAC, etc. ...
    (microsoft.public.vb.general.discussion)
  • VB6 Application Install
    ... ability to upgrade a SQL Server database, if needed, depending on the nature ... Create a Database if it does not already exist ... Continue on with application SETUP... ... ODBC, install MDAC, etc. ...
    (microsoft.public.vb.database)
  • VB6 Application Install
    ... ability to upgrade a SQL Server database, if needed, depending on the nature ... Create a Database if it does not already exist ... Continue on with application SETUP... ... ODBC, install MDAC, etc. ...
    (microsoft.public.vb.database.ado)
  • Re: Transactional Replication Large Database
    ... Sql Server 2005 ... I am not a replication expert but have set it up a few times. ... Data will be used for reporting and is an SAP database. ... The current setup is for a test environment, ...
    (microsoft.public.sqlserver.replication)
  • Re: Phantom User or Role
    ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... Issues When a Database Is Moved Between SQL Servers ... SQL Server MVP ... there is a user and/or role setup to> allow code to logon and execute stored procs and queries. ...
    (microsoft.public.sqlserver.security)
Loading