Hi, how are you doing?
Can I run a .exe inside a SP? Because before sending emails it needs to
authenticate, so I did a Delphi .exe !
MS SQL 2000

I am having a very difficult problem.
I get the following error:
Microsoft SQL Native Client
Cannot use the OUTPUT option when passing a constant to a Stored Procedure

I have two queries joined with a union, one query by itself takes 34ms to
complete and the other runs by itself  in 340ms but when they are joined by
the union (or a union all) the combined query takes an incredible one minute
and 15 seconds.  Why does the union com with such an ...

Morning.
Im running a FULL BACKUP in overwrite mode daily at 3am.
Im running a DIFFERENTAL BACKUP in overwrite mode hourly.
I cannot lose more than an hours data.

At the beginning, I read Tibor Karaszi article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
I don't use bellow procedure on production but only on test servers.
One of task I'm using in maintenance plans is "shrink database", default sql

I have an issue with full text indexing of some BLOB data (image data
type). We recently moved a SQL 2000 database to a new server with SQL
2005 installed. Everything thing went very smooth. We have full text
indexing enabled on several columns over several tables. We have a

The issue I am having is
we have SQL Server 32 bit installed on Windows 2003 64 bit
server ,that has 8 cpus 2Ghz and 16GB RAM.
Windows 2003 64 bit version can support high

My SQL 2000 server's daily (full) backup started failing due to a lack of
disk space. This daily backup has been running for quite a while so im
surprised.  The file system was full but it seems the old backup are not
being deleted even though the maintenance plan is set to ...

I have a database in Access to keep records for CDs. The tables are as below
Artist
ArtID  -  1,2,3...
ArtistName  -  Michael Jackson, Snoop Dogg, Jamiroquai...

I am unable to restore a differential backup. I get the following
error:
"This differential backup cannot be restored because the database has
not been restored to the correct earlier state"

I currently have a table which holds the following:
Team         Amount        Date    
------          ---------        -----
Blue            100             01/01/08

I have disc 1 and 2 for sqlserver 2005 enterprise edition
which pulls up browser contents when I run autoplay.
All I think I want is to add query analyzer to my local client installation.
How can I install query analyzer to an sqlserver2005 client installation?

I have been searching for the answer to this one for awhile with no success.
In the past applications were written so that only one user could edit a
record at a time.    This was done through record locks.   The record would
be locked until the user either cancelled the "edit ...

Hi group
hope that you can help me...
Created a backup of a database from our Production server (x64 bit) and
moved the backup file to our develop (32 bit) server and restored it as the

Currently piloting SQL 2005 in Windows 2003 R2 which comes locked down. The
SCW (security configuration wizard) has to be used to open things up.
Quick question - does the SCW "know" about SQL 2005? Does the SCW cover the
typically surface area lock down that any SQL 2005 ...