Viewing 15 posts - 16 through 30 (of 63 total)
So the ALTER AUTHORIZATION statement made the [Developers] the owners of the schema? Then I don't really need to add the rest of the GRANT statements since they are now...
January 1, 2013 at 3:17 pm
Thank you Jason,
I had the 'opportunity' to be in meetings for about 7 hours yesterday and didn't see your reply until just before time to leave for the day...
But thank...
November 9, 2012 at 12:22 pm
Thank you! That was what I needed and have to say it was, ahem, non-intuitive...
Now, on to loading a few more documents and see how all of this really works.
Again,...
October 22, 2012 at 9:29 am
Thanks Jeff,
I'll see if I can make that work but for now, I'm re-thinking what I wanted to do and see if there is another approach.
Thanks again,
Norman
July 25, 2012 at 12:12 pm
Thanks again Cap'n Hector,
I don't think I can group every login I need into a group but I'll look at this. I just thought it would be a decent way...
July 25, 2012 at 12:11 pm
Thank you Cap'n Hector,
I was sort of afraid that was the answer. I can create a db user and grant permissions. That works, I was just hoping there was another...
July 24, 2012 at 3:55 pm
Thank you Gail,
BOL isn't telling me that but maybe and I don't understand what it is saying exactly. But what you say makes sense. I'll do a shrinkfile with a...
July 9, 2012 at 10:33 am
Just in case anyone else runs across this little bit fo SSIS frustration, what we found was this:
The very last line of the SQL query did not have an ending...
June 14, 2012 at 3:51 pm
Believe it or not, I think I found the answer. It looks like the problem started when I copied the new SQL query into the OLE DB task. When I...
June 13, 2012 at 12:30 pm
Unfortunately, no, I am not using configurations. Just a simple basic extract and write to a file extract. The whole point is ti correctly format the output for the vendor...
June 13, 2012 at 8:58 am
The security isn't all that sophisticated, there is only one schema (this is a database provided by the vendor) so that can't be it. I've used the same credentials to...
June 12, 2012 at 8:45 pm
I use the same OLE DB connection for the other 10 or so steps in he package and they all work. I've tried creating a new data flow and that...
June 12, 2012 at 3:32 pm
Thank you for the response Craig,
Yes, I can repeat this at will in BIDS.
I've never used Data Viewers before, so this may take a bit...
I found a reference and added...
June 12, 2012 at 2:27 pm
good point Micheal,
These are indexes built for specific reports and probably have been modified over time. But a quick look using a couple of different scripts don't show any of...
February 10, 2012 at 11:06 am
Thank you for the pointer Gail! It at least gets me to a better starting position. And makes me feel better that I'm not missing an obvious tool that does...
February 10, 2012 at 10:53 am
Viewing 15 posts - 16 through 30 (of 63 total)