All,
We have a senario where we are joining 3 tables for a query that could have
a many to many relationships, between 2 of the tables.  I want to know what
is the best way to go about it?  also what would be the best way to go about

I'm running into a strange (version / environment dependent) problem with
SQL Server 2005. When executing a selection against the system views (like
information_schema.tables or sys.indexes) in a sp_ procedure (created in
master) connected against a user database, some platform / ...

I'm trying to write a check constraint that uses a UDF to validate whenever
an INSERT or UPDATE occures.  I can write the UDF and configure the
constraint, however when I do an insert I always get an "INSERT statement
conflicted with the CHECK constraint" error, even though if I ...

I am new to SQL server 2008. A standard edition of SQL server 2008 has been
installed on windows server 2003.
While trying to setup audits, the sql server shows "Auditing is not
available in this edition of sql serer. (Micosoft SQL serve,r error:33075)"

We have a job inserting data into table1 every night, then during the day,
we need to run a sp to do a search on table1. This database is set auto
update statitics and auto create statitics, anything else I need to do with
the searching process regarding the performance respect.

Hi
SQL server 2000 SP4 on both servers.
We have two applications on two separate servers with separate sql databases
on each server. One application needs to select data from another application

I would like to use views more in the architecture of application. I am told
by my manager that in some situation they don't use indexes properly. My
manager's away so I can't ask him. Can anyone shed any light on what he
means?

Is there a Developer Edition for 2008 similar to the DE that was made
available for 2005? If not is there an equivalent?

I have a silly question to ask. If there is a single server running sql
2000, then only one database db1 residing on it, compare to multiple
databases residing on single server, the performance is much better, right?
If this is the case, is there a way to improve it on the ...

We have a server running SQL Server 2005. There is a job that one of our
DBA's has set up that fails when manually run. This job is set as himself as
the owner (domain user). When the job runs it fails and gives the following
error:

Lately, I purchased an entry level server HP ML110G5 bundled with internal
HP DAT72 USB internal tape device running SQL server. Under SQL server
management, backup, new backup device, the tape device always greyed out and
unable to backup my DB to tape.

I'm starting to get really confused at the moment...Last week we did an
installation of Windows 2003 SP2 x64 Enterprise with SQL2000 SP4. We
installed everything succesfull and applied the /PAE in the boot.ini and
enabled the AWE function. Then we allocated 26GB min and 28GB max ...

Bellow are may script.
Now I want tho have the result mail to my.
The mail setup are ok to mail a test mail and my mail profile is named
"SQL Mail"

This is entirely SQL related... but has to do with some SQL things
we're doing in a project.
The sponsor says we can't delete data. So, soft deletes all the way.
Now, I'd like to know the right way to handle this: We have a

I was told its possible for SQL Server 2005 table identity values to be
re-used (if they have been deleted) when inserting new rows, rather than
always incrementing the previous maximum value.
Is this correct and, if so, how is it turned on?