cool got it fixed, it was "View Definition" thank you for helping and pin pointing the location.

your absolutely right, thank you, so the problem is, and yes its msdb and master, but the following tables the user doesnt have access to read the data, but doesn't...

• This reply was modified 4 years, 11 months ago by Siten0308.

thank you all for your input and yes, I do or should have provided an example, which in the future i will next time. but found the root cause, which...

good call, let me see about setting it and re-write, will let you know.

thank you that fixed it 🙂

no, how do i set that in SSIS? specifically for a Execution SQL Task?

nope, no line break what so ever... thanks, i am right going to create my own backup script. thanks

cool thanks Steve, Also we are on VM, so not sure if putting it on separate Drives would matter, but should i try doing it on configuring to backup separate...

lol I was going to host a counter strike server on our SQL server, but I decided to wait till my movies were downloaded 😛

but if you have any idea,...

Gotya thank you Steve for that info, good security best practice, thanks again for taking the time to answer 🙂

cool thanks Steve, i will try this out, just curious, have you tried creating a few on a database and fully qualified it with a replicated database and able to...

hey SSC Guru, thanks for the info, yes trying to make SQL server D centralized as this will be the datawarehouse, and needs real-time data.

I did find some examples online...

big thank you again sir 🙂

shoot really sorry, i hit report by accident and meant to hit Reply...

hello, so I never got the excel to work properly, however what I did instead was change from xlsx to csv, and it works consistently and fine. work around I...