Thanks Hugo. It makes sense.

we have used it for one of our DWH - they are performing really good when our analysis team runs their daily radon analysis queries.

for small table we will...

Thanks Gail,

I think disabling the login would be quicker and simple, will do...

hi

You can use import/ export wizard to transfer the data if this is one off requirement.

Thanks Welsh for your help.

When I set the job to run package as 32 bit then it started working fine.

this package connecting to remote MYSQL Server to pull the...

thanks for your response John,

Here I am not comparing it with my login and service account.

just to narrow down the issue I logged into the server as service account...

Thanks John,

This package wouldn't use any configurations and everything saved with in the package. Interestingly it works fine when I login as Agent service account then give right click...

Hi Jeff,

Thanks for your valuable explanation.. I have got below question in my mind, i would appreciate if you could explain me

I have a server with two instances and...

Ohh sorry

I forgot to mention Server A points to MSA so I have one storage and Server B is just a physical server and doesn't have any separate storage....

Thanks Perry,

I didn't understand your point here. How can I make a cluster with Server B only( I don't think you can create a windows cluster with one server )

We...

Help please

Unfortunately this has become a big problem for me. Making the SA or any SQL Login as a owner for a job is not always ideal I guess. As a...

I have denied access to public role but still they are visible from SSMS

What you mean by locking here ???????????

Thanks a lot everyone