Viewing 15 posts - 37,696 through 37,710 (of 39,456 total)
Don't really use alerts here. I have messed iwth them in the past, but haven't seen the need. I have a number of checks in place with either jobs or...
March 26, 2002 at 8:13 am
Do you need to? There were some issues in v6.5 that caused triggers set on system tables to sometimes not fire. In v7, I think these either carried over or...
March 26, 2002 at 8:12 am
March 26, 2002 at 8:12 am
I tend to prefer backup/restore, but I've been doing this since v4.2 and attach wasn't an option then. I've done both and no great difference that I can see. The...
March 25, 2002 at 9:51 am
Karen,
I'd try to change the owner of the packages to be safe. DTS can be a little flaky at times. Try sp_reassign_dtspackageowner.
Steve Jones
March 25, 2002 at 9:47 am
Ming has a good explanation above. I also often find there is no good natural key, especially as business rules are constantly changing. Often I need a name for something...
March 25, 2002 at 9:38 am
Thanks, I'm was trying to present some information on a topic that may have stumped some people. I plan on continuing with other items as I find them and I'll...
March 25, 2002 at 9:25 am
Great advice from Andy. One note, if you use a maintenance plan, DO NOT repair problems. It causes issues.
Steve Jones
March 24, 2002 at 4:29 pm
There is also an event that fires (1864?) and you can capture this as an alert.
Steve Jones
March 24, 2002 at 4:27 pm
Tend to agree that you should fix the queries if you have time, or at least test if you can. If it's a critical production box, I'd leave it off...
March 24, 2002 at 4:01 pm
March 21, 2002 at 4:39 pm
Might be some type of issue with the user executing packages. Can they execute some other simple package?
Is this a copy db task?
Steve Jones
March 21, 2002 at 2:15 pm
If you choose a directory, then you do not need an IP. It will do a file copy.
you can schedule the pacakge. Right click the package and choose "Schedule"
Steve Jones
March 21, 2002 at 2:12 pm
It's a security issue in that SQL doesn't "lock" accounts, so someone can constantly be connecting to that server and trying passwords. sa is a well known account. You can...
March 21, 2002 at 2:06 pm
Didn't know that. Is this an instantaneous value? Updated every xx sec/ms?
Steve Jones
March 21, 2002 at 2:03 pm
Viewing 15 posts - 37,696 through 37,710 (of 39,456 total)