I have SQL Server 2005 Standard as the database for a web application and
currently use the SQLOLEDB provider (in my connection string). I'm not
really using any of the "new" features in 2005, as the same db worked fine
with SQL 2000.

I have a process that checks all tables for complete data.  It will return a
query result if a table is deficient.  how do I send email based on the
results?
Guessing for the Command Box:

I have the following data:
ORDERDATE     CUSTOMER
==========     ========
20/01/2007         SMITH

I have a stored procedure that return a result set. I need to be able to run
a selection on that result set, something like
SELECT * FROM EXEC...
I know it's a well known problem, but due to my situation I cannot use

Currently we backup our tansaction logs throughout the day.  We do a full Db
backup at night.  We also reindex fragmented indexes (> 25%), update stats
and check the dbs on a regular basis as well.  We are in production but
continue to update the database design as well.  I've ...

All,
Need to compute number of minutes for each row on a char(5) field in the
format "hh:mm".
For example... "04:22".

I have a problem with a stored procedure that checks for the existance
of an entry.  I have copied in the definition of the stored procedure
at the end of the message.  I am using SQL 2005 SP1.  I believe the
problem to be with the @Detail parameter.  My application (MSACCESS

Here is my logon trigger:
USE master;
GO
CREATE LOGIN security_login WITH PASSWORD = 'abc123';

Recently I found a statement on Internet that says...
"A FULL OUTER JOIN collects all matching rows in both tables regardless if
there is a match or not."
When I test this the query only gets rows from the left table if there was

I have to create a stored which has to select on a table filtering a primary
key (int) with a set of values.
These values haev to be given via as a parameter.
I would to pass a parameter like "3,5,22,33" and the select should to sound

I need to take rows of data and make it into columns.  
EXISTING TABLE:
PolicyNbr  DriverNbr  Incident  Date
999999     1             1            20061230

I try to load Excel data to SQL Server 2005 using the following SQL
statement:
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',

I am looking for a way to list all database names on a given server that
contains a certain table name.
I am trying to join sysdatabases with information_schema.tables but without
success.

I'm trying to run a query similar to the following:
Select Field1, Field2
From DatabaseA
Where Field1 IN

If I issue ALTER TABLE statements to change all of the text datatype columns
to varchar(max), it works and it's fast but I see no immediate decrease in
size to the tables.
However, if I create new tables with varchar(max) datatypes replacing the