Viewing 15 posts - 36,496 through 36,510 (of 39,720 total)
There is no security on DTS Designer. To open a package from SQL Server, they need access to msdb and the package password.
Steve Jones
February 21, 2003 at 10:34 am
No. If you scheduled this as a job, saving the DTS package, then you could reexmine it. I don't think there is a log saved when you do this.
Steve Jones
February 21, 2003 at 10:29 am
Greg Larsen has the right idea. Use an account in your scheduler and add it as a trusted account
Steve Jones
February 21, 2003 at 10:20 am
Thanks for the note. Might be implementing a cluster soon and it's nice to see some info on gotchas.
Steve Jones
February 21, 2003 at 10:13 am
Ahhh, I think you need your secret decoder ring, SQL Bill.
something appears to be missing. I'll have to check at home when I get back. Gone for 2 days. In...
February 19, 2003 at 7:10 pm
You can run a trace and then back track through the data. There isn't a good way to do this in SQL Server (yet)
Steve Jones
February 18, 2003 at 11:10 am
Thanks for the tips and complement and I am looking forward to Intellisense. Save me some BOL time trying to remember which order parameters are in.
Steve Jones
February 18, 2003 at 10:36 am
Have you specifically set the min memory for SQL Server? With AWE you need to do this.
Steve Jones
February 18, 2003 at 9:05 am
Tend to agree with the last post. Looks like a hardware or build error.
Steve Jones
February 17, 2003 at 10:34 am
Interesting. Is something starting at 00:00? Either SQL or non SQL related?
I run the checks once a week. Rarely see errors, so gotten a little lax in worrying about them.
Steve...
February 17, 2003 at 10:15 am
Call MS. They are really good about working with vendors on your behalf. I had a similar issue with Compaq Fiber Channel cards and MS called HP on it.Eventually HP...
February 17, 2003 at 10:11 am
Good suggestion. We'll take a look at it.
Steve Jones
February 17, 2003 at 10:01 am
Interesting. I'll have to check it out. I use EditPlus (www.editplus.com) for most non SQL editing. I like the color coding and tabbed interface, but Notetab looks nice.
Steve Jones
February 17, 2003 at 9:41 am
Thanks, you are right. My quick query was to just match the day month and year, which caused the bug. If I'd gone with yours, I'd never have had an...
February 17, 2003 at 9:37 am
Full Text is good, but having some other indexing capabilities, plus the ability to move the load to another server is something we're looking at. Full Text isn't as mature...
February 13, 2003 at 2:49 pm
Viewing 15 posts - 36,496 through 36,510 (of 39,720 total)