I need some help building a query using three tables and I am having
difficulty writing the query.
Here are the tables:
GENERAL:

How do you execute a SQL Server stored procedure or query from an Access mdb?
Thanks.

I remembered there is an option I can use to display just user defined
objects in SQL Server Enterprise Manager, but I can not find it anymore?
Would you like to tell me?  I really appreciate it.
Laurence

What is the best way to use query analyser when you're looking at data in
the grid and changing the SQL queries all the time?
Other SQL systems I've used have some way of going back to the previous
queries, to save typing them in again. Am I missing something in Query

I want to delete the index:
How to run the output of:
select 'alter table ' + b.name + ' drop constraint ' + a.name from
sysobjects a

So I blew it!
I did not follow the important uninstall procedure when i removed SQL Server
2005 Beta.
Now, I am trying to install the CTP for Sep, and I keep getting: "SQL Server

I was wondering whether the performance of a T-SQL query would be improved
by restructuring the expressions in the WHERE clause from the most specific
(first) to the most general (last). Furthermore, would any difference in
performance depend on the construction of the underlying ...

I have two tables  tblLogin and tblTrades
I have 3 fields in each table, for thr purpose of this question
tblLogin Fields are
MemberNo

I have a query that will show results from three tables:
select paciente.num_abs, paciente.num_ref, paciente.registro,
paciente.nome as pac_nome, paciente.nasc, paciente.data,
paciente.data_lancado,

I am facing memory leaking problem and its increasing more and more. I would
appreciate if you can guide me regarding this.
O/s:- Windows 2003 Service Pack 1
Sql Server : SQL Server Service Pack 3a

I've been trying to create a full-text index using Enterprise Manager. If I
right-click on the table, "Full-Text Index Table" is grayed-out. If I try to
start the Full-Text Indexing Wizard it tells me that the "Full-Text Server
service needs to be running." The SQL database is on ...

Situation:  1st time using Oracle for a training class.  1st install
Problem:
I just went through the instructions for " Installing the Oracle9i
Database[1]".  My problem is that I don't remember the passwords I created

I'm having problems with MS SQL 2000, SQLMail service...
I have done everything by the book, created mail accaunt in Exchange 2003, tested it.
Installed Outlook 2003 on server with MSSQL, created mail profile using same accaunt which starts both SQLAgent and MSSQL services....
I've ...

Does anyone know how to change the delimiters on SQL Server 2000 SP4 Client
software?
From " " to [ ]  ?
For example:

I have a SQL server with a single user database. The database is about 1 Gb
in size whereas the Transaction log is about 100 Gb. I've been backing up
the database every day so why is the Transaction log so big? Doesnt the
database backup shrink the log or truncate the log? any ...