have a look at the links that I gave to to you in my precious post, they should help you with your query.

You dont want much do you...

You havent mentioned if this is for a single database or for all the user databases on the server.

This is an example of a script...

If I can make a suggestion, next time you have this problem. Take a screenshot of the activity monitor or attach the contents of running sp_who2. So we can try...

Has it...

Cannot give recommendations on what you have said.

depending on what troubleshooting is applied, will mean that the end result could be different.

IF a restore can be used to rollback the...

luckysql.kinda (9/23/2009)

---

I shall use bulk insert or bcp or SSIS tomorrow for huge bulk insert.

For any bulk operation is this sufficient that I change the recovery model to BULK LOGGED?...

Danb7183 (9/23/2009)

---

Ah ok, I see what you mean now.

How am I to run the command within the query using the domain account? Also, using xp_cmdshell will I still be able...

hmm, can you give a bit more details, I dont like downloading attachments without knowing what it is.

Could be interesting, you need to give him SQLAgentoperatorRole...

Danb7183 (9/23/2009)

---

Yes, this is what myself and the network admin have already tried! We can navigate to the folder no problem and create a test text file in the folder...

Business Intelligence, bi 😀

the other option is to impersonate the domain account and check that you can actually read and write to the share on the other server.

thais is exactly right, that is what the role is for. Are you saying that you want...

Glad to hear it,...

rajeshreddydba (9/23/2009)

---

i am getting error profile is not valid and error number is 14607 ,the job fails and it is showing profile is not valid .can u help it out...