Viewing 15 posts - 36,676 through 36,690 (of 39,903 total)
February 24, 2003 at 10:51 am
There isn't really a good tool. You can trap some info from Profiler, but really this is an admin function that you could use VSS/CVS, etc to do.
Steve Jones
February 24, 2003 at 10:26 am
Are these scheduled jobs? Do you need the DTS job to run on the other server or is the package on the other server?
If you need it to run on...
February 21, 2003 at 10:40 am
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
Viewing 15 posts - 36,676 through 36,690 (of 39,903 total)