you have the option of creating a query in Excel or use DTS transform that brings the data into Excel. Then you can use any Excel function you want.

NOTE: You...

To keep this from becoming an issue with any scheduled job or process, I never schedule a job to start between 12:55AM. and 2:05 AM.

Go for...

When the db was in "suspect" mode, did you run the "sp_resetstatus" stored procedure?

What is your reasoning for restoring the master database from one server to another, be more specific in what you are trying to accomplish >>> if you are migrating SQL...

When you right click on the package and schedule it that way >>> the system creates a job that runs the package. If you do it again you won't see...

the "best" way depends on what you want to accomplish.

Log Shipping: Any changes made on the production DB including all schema modifications are reflected on your test box. SQL Server...

I'v tried to do that lots of times, receiving different errors (from timeouts to access violations >>> same source/destination servers.) >>> with no luck. Don't waste your time with that option >>>...

Before the e-mail task >> create a task that counts the number of records and create a text file >> then attach the file to the e-mail.

KISS >

Are the stored procedures encrypted ?? they won't come across and you can't script them >> you can only restore from a backup. I have had ~50% success in using...

You can use either "Tranactional"/"Snapshot" replication depending on your connection to the subscribing server. Log shipping maintains the stand-by database in recovery/read-only mode. in read-only mode the users get disconnected...

Do a native SQL Server backup to disk, have tha admins backup that file/directory. DON'T use any 3rd party SW that stopes SQL Server to do a backup, if a...

I don't beleive that replication will allow you to truncate a table.

Why don't you create a transactional/snapshot publication with the tables that you want to archive, and schedule it to...

Have you tried shrinking the log shipping database using the shrink database via enterprise manager ? If a db is in recovery mode, you have very limited access to the...

Create the publication in EM.

Once created, right click on the publication and select "Generate SQL Script".

this will give you a script that you can modify and run using "query analyzer"...