September 9, 2011 at 4:46 pm
Maheshsoft1987 (9/9/2011)
I have checked it. Its seems like I have read write permission.
It seems like? That does not sound very convincing.
You said that the package would be using the Service Account. If that is the case it does not matter what permissions you have; the job (assuming you are running as a job) will fail.
Why don't you logo to the server using the Service Account and do what I suggested.
It is a quick simple way to test.
But you are not very articulate as to exactly what you are doing?
Are you logging onto the Server?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy