you can set the pswd for the backup and the pswd needs to be provided while restoring the db...

eg:

select a.* from authors a inner join (select * from titleauthor) as b

on a.au_id=b.au_id

where ..................

transform the data from the query to a file and then use that file as an attachment to send the mail...

whatz the error message you are getting?

SELECT    distinct  u2.EMPLOYID, u1.TRXBEGDT, u1.TRXENDDT FROM .....................................

Ideally the columns TRXBEGDT, TRXENDDT needed to be in UPR30100...normalization

Sure you can..

If you dont want the  user  of appropriate fixed server and database roles to perform the operation the operation then you can set the pswd for the backup...

I haven't seen data being lost due to maintenance jobs..I would be interested to know if it has..

If the table wasn't dropped and recreated then the third party tool should...

Refer to BOl for sp_attach_db syntax..

http://msdn2.microsoft.com/en-us/library/ms179877.aspx

did the row count was zero or there was no data in the table when u queried it?...

Here is the query using the Function from Kevin...

select mycol from

(

SELECT  top 1 mycol,MIN(dbo.fn_StripChars(MyCol)) minvalue

FROM @MyTable

group by mycol

order by minvalue

) as a

Check the permissions on the shared folder for the account on which sql server is running..

When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed...

When u attach the db with no log file, the device activation error occurs and sql server creates a new log file..

After executing the attach statement, exec sp_helpdb 'dbname' should...

EXEC sp_changeobjectowner 'table', 'dbo'

identifiers that fail to comply with these rules must be delimited by double quotation marks or brackets..

If you get the object doesn't exist error for the table used in the...

From BOL...

The transaction log is a serial record of all the transactions that have been performed against the database since the transaction log was last backed up.

When restoring a transaction...