After detaching a database in SQL 2005, how do you delete it?  True, you
could reattach it.  But, is there a way to simply delete rather than attach
and then delete?
childofthe1980s

I've got a sql server 2000 cluster running and every morning i see a process
doing an execute command that blocks all other users/processes. All processes
connect from a tomcat server running on a seperate box so it does me no good
to see who's logged in. But i was wondering if i ...

I just setup a few thing on the tables in this database so that no one can
delete records. And I just noticed today that a proc I have does not work
correctly. I just added this trigger (no others exist for this table):
CREATE TRIGGER [DontDeleteATTENDANCE] ON [dbo].[ATTENDANCE]

I have  a fairly simple query
SELECT  * FROM SEVT  WHERE ABS_END >= ' 1211369400' AND ABS_START < '
1211370000'
That always does a clustered index scan, instead of using an index that has

I have reviewed the MSDN page on moving the system databases.  But, I do not
see anywhere on that page where it is explained how to move the model
database to another location of the server (in the same instance) in SQL 2005.
Could someone please post for me here on the board how ...

I get the following error when I try to attach a database in SQL 2005.  In
fact I can't even try to attach because I get this error upon seleting the
file bfore attaching in the UI.  I understand the torn page (1:9) is the
database boot page.  Is there any way to fix this?  ...

Hi db masters,
We are trying to consolidate 2 servers and move databases with sql login
users from one sqlsrv1 to another sqlsrv2. We are using database copy wizard
from management studio. No error messages when moving but the moved users are

We are trying to send a simple message using database mail to a
hotmail account and hotmail never seems to get it.  The code looks
like:
EXEC msdb.dbo.sp_send_dbmail

I need to install developers edition and do not want to buy xp since vista
is out.
Does anybody know if I can install Vista premium edition and sql2005 on it.
Thank you, Gene.

Hi
I have installed sql server 2005 on a windows server 2003 service pack 2,
all components excepy replication and reporting services and no clusters.
Almost all steps went fine, In the end it gave me a error "Microsoft sql

Does anybody know how to change the default number of 6 errorlog files to
let say 15?

We are running SQL2005 SP2 build 3175, soon to be 3239, and have some
conversion jobs that use Backup Log with Truncate_Only. The analyst says
that the checkpoint task blocks the conversion job. Personally I can't wait
for SQL2008 to stop the Truncate_only option, but that's ...

on one table I have this composite clustered index, setup in that
order:
IDF_Item, IDF_reference, Date, Container.
Is that order important like in a non-clustered index? or since it's a

When I log in this error message comes straight after saying:
Error parsing C:WINDOWS\Microsoft.Net\Framework\v2.0.50727\
config\machine.config
Parser returned error0x80070570

I have a SQL Job with 24 independent steps.  I would  like to send out
a notification if any of the steps failed but the job should continue
from the next step.
Our SQL Mail is not setup.  The only way I know how to do it is to