Viewing 15 posts - 1 through 15 (of 16 total)
Got it! I have to run the whole package for logging to be recorded, even though I can set up logging for just part of it. That was the piece...
February 9, 2012 at 7:36 am
This time when I opened SSMS, sysdtslog90 is there! I really did try Refresh.
If I click on the package and select Execute Package logging works. It doesn't, if I...
February 8, 2012 at 3:11 pm
I've made some progress. 🙂 I ran the package in debug mode and it created the sysdtslog90 table. It does not display in Management Studio, but I can query it....
February 8, 2012 at 2:14 pm
Sorry it takes me so long to get back to this.
There are no tables in the database. I figured out how to run the default trace, and that shows...
February 7, 2012 at 1:39 pm
It's a 32-bit system.
We're going to create a separate development server with just the database the consultant needs, so we can give him admin rights on that. That solves...
October 13, 2011 at 6:38 am
FYI, it is a problem with the Windows group.
Thanks for the help!
Linda
August 21, 2009 at 3:05 pm
Yep, I did that. And the user was an existing member of the group.
I did not assign the group a database role membership. In Securables, I added the Dow schema...
August 21, 2009 at 2:18 pm
2. I like easy answers like that.
1. I'm not sure, it's an account in our WIndows domain, that has access to a specific folder and no one who is not...
August 21, 2009 at 1:41 pm
Thanks for the suggestions. A datapump from a vendor had loaded a lot of temp files under my user id. We deleted those and are trying again.
Linda
January 23, 2009 at 11:16 am
That sounds like what I need. With directions I can understand. 🙂
Thanks!
Linda
July 29, 2008 at 7:37 am
Thanks for your help. I think I'll start with one of our small dbs and monitor it for a bit, then do the others.
Linda
January 28, 2008 at 8:31 am
Thanks, this is starting to make sense now. Just one more question. (I hope 🙂
If the mirror never becomes the principle, will the transaction log just keep growing? Do I...
January 28, 2008 at 8:09 am
OK. Can I have a copy of the job on the mirror server, so that I could just schedule the job and not have to recreate, if the mirror became...
January 23, 2008 at 2:45 pm
Jeff, I agree there should be a better way, but since the people who own the application like their datapump (I've talked to their tech support), I'm stuck with it....
October 9, 2007 at 11:20 am
Thanks for the suggestions. I've changed the db to bulk-load, but don't know if that'll help in the middle of the process. I'll try removing the primary key constraint on...
October 9, 2007 at 8:46 am
Viewing 15 posts - 1 through 15 (of 16 total)