Good point JDixon...

You can try the alternate solution...

Insert your procedure data into a table in tempdb in dts package using EXECUTE SQL task and then copy the data from the table to excel...

It is related to parallalism...

Read the following threads...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=183243

http://www.sqlblogs.com/top/ng/group~2/~138495~__CXPACKET-and-max-degree-of-parallelism/index.aspx

http://support.microsoft.com/kb/293232

Make sure you have atleast 3-5 GB free space and make UNRESTRICTED FILEGROWTH is enbaled.

Make sure file growth is 5% or 1000/2000 MB...

And also check if there is any blocking goin...

I did but I used Principal and Witness as one server and Mirror as another server in my test environment...

What do you mean by Pricipa can't bring Witness online?

Witness is...

You don't need to restart the server to release the locks on the files...

Go to computer management and expand Shared Folders tab/Click on Open files and see who is locking...

You can use the following script for backup and you can write a script for ftp ans similar way restore.....

CREATE  PROC Stp_Backup_AllDb

  @DbName sysname = null,

  @BackupLocation Varchar(1000)

AS

/*

EXEC Stp_Backup_AllDb...

Just deny the access to Main Membership table...

Deny select on tablename to username...

Sorry! May be I am missing something here...

I have created a test procedure and exported into an excel without any issue. In excel will append the data if you run...

I don't see any problem doing this.

what error you are getting?

If I am not mistaken we can't schedule the job every three days... there is a option for daily weekly and so on.. but without writing any widow script I...

Sorry wrong posting!

Is AUTO SHRINK is enbaled on the db? If it is disable it.

Make sure you have outlook is default email in your internet properties.

Restart the SQL service... still you can't see the outlook profile...Open the outlook on the server and see you...

If you post schema and explains your question based on the schema... Posters can post exact solution instead of guessing.