Using sp_attach_db on its own to create the database object from a sinlge mdf file should work. If no ldf is present,sqlserver should realise,and then create a new one for...

The trigger fires within the transaction created by the Insert statement. If you do not want the trigger to rollback the Insert statement, you will have to drop the trigger....

Only in middle-earth.

Does not sound as though any database or log backups had been made. Also not sure it is the best idea to backup the 'server', backup the database files.

Sorry, no can do. Must be able to restore from a FULL db backup before moving on to the log.

Integers are stored using 32 bits.

1000000 stored as a varchar requires (7*8) 56 bits of storage. The larger the column, the more processor cycles required to make a match....

From Microsoft.

SYMPTOMS

A clustered index may be corrupted if all of the following conditions are met:

You try to add a column to an existing table and in the same transaction you...

Either spend a bit of money, or preferably a bit of time, or forget auditing changes to the data. Databases require administration and good design.

Not sure if I have fully understood your question, but the normal way to avoid duplicate rows is to use primary keys. The code is:

alter table <table name>

add constraint <object...

Had a similar error, and so used the following code:

set xact_abort on

this will allow nested trans which the DT requries. After you have performed the DT then:

set xact_abort off

Hope this...

What is the point in an index on a bit data type column. btw i have a background in c/c++ and thought that B-Tree meant Binary Tree. Now MS...

Does he have a sister?

Have a look at the sp_addumpdevice stored proc, it will make you life so much better.

Have found in the past that i cannot use QA as an application in sense of a testing routine, since it acts completely differently from the other routines that we...

Had the same error message on a different topic after i had installed a named instance. Whist i realised that this will not be the case if you are working...