you can use a xp_fileexists function to check whether the file exists or not(EXEC master..xp_fileexist 'c:\boot.ini') , it will return 3 columns , if file exists file exists column returns 1 and...

you supposed to use NO_TRUNCATE , read on the following options

NO_LOG | TRUNCATE_ONLY

Removes the inactive part of the log without making a backup copy of it and truncates the...

use Enterprise Manager

Select database Server

select database whis is required to clean

right click on database

select all tasks

click on Generate SQL Script

create new database using the above script

if you can do manually on Query Analyser, right click on results after executing query and save as csv file...

if you want to do in automation you can use BCP...

It is not legal for the transaction_name parameter of a ROLLBACK TRANSACTION statement to refer to the inner transactions of a set of named nested transactions. transaction_name can refer only...

You can write a VBScript which runs back up ( OSQL ) and Delete commands and finally put this script on automation in SQL Agent Job.

I think you could use DISTRIBUTED TRANSACTION

for example

USE pubsGOBEGIN DISTRIBUTED TRANSACTIONUPDATE authors   SET au_lname = 'McDonald' WHERE au_id = '409-56-7008'EXECUTE remote.pubs.dbo.changeauth_lname '409-56-7008','McDonald'COMMIT TRANGO