Viewing 15 posts - 39,211 through 39,225 (of 39,226 total)
One thing that is easy is to set a password for the packages. I set one on all my packages.
The packages are stored in msdb.dbo.sysdtspackages, so you can set permissions...
July 10, 2001 at 11:01 am
I actually have a neat process that I am writing up in an article. It should be done in the next week, but I am not sure when it will...
July 10, 2001 at 12:01 am
You might try trapping using DTS. Enter this command in a T-SQL step and then setting succes and failure steps.
Steve Jones
July 8, 2001 at 11:04 pm
We have both, but part of our system is remote, so I dump to disk, then ftp to LAN and snag it on tape.
My preference is in one of my...
July 8, 2001 at 11:03 pm
Save the packages with a password and you should be ok. For some reason, the password packages are all saved in the same format, but the non-password ones are not.
Steve...
July 6, 2001 at 11:32 am
Brian,
Thanks for the Q article.
I think you will be stuck with RPCs due to the firewalls, but probably do not want to have those open anyways. I'd stick with your...
July 6, 2001 at 11:27 am
July 6, 2001 at 11:17 am
Have you tried checking if there is a default or FK bound? Cascading updates?
Steve Jones
July 5, 2001 at 8:05 pm
Please let us know what you find out. This is an interesting problem that I am sure others have run into.
steve
Steve Jones
July 5, 2001 at 4:00 pm
Be sure your client is only running sockets. Use Client Network Utility.
I setup Tiny Software's personal firewall and it will default to allow nothing, but pops a box for each...
July 5, 2001 at 1:36 pm
This solution from liya_kats is probably the best one. If this is SQL Server 2000, you could convert this to a user-defined function calle to_char and call it anywhere you...
July 5, 2001 at 1:33 pm
Can you run a complete Profiler (everything) and then log in on production and see what is called? You might be able to catch something here.
Also, is there any 3rd...
July 5, 2001 at 12:00 pm
EM will run onn 1433, but also uses 435 or 433 or something like that. I caught this on my personal firewall at home.
The only problem with a web admin...
July 5, 2001 at 11:53 am
No problems here. I get notifications from job failures as well as xp_sendmails that I schedule.
What is your mail setup? Do you have Exchange (version?), Outlook (version). Is this in...
July 5, 2001 at 11:51 am
Try these resources:
http://www.tair.freeservers.com/cpp/xp_Works.html
http://support.microsoft.com/support/kb/articles/Q190/9/87.ASP
http://www.windowsitlibrary.com/Content/77/20/1.html#3
Steve Jones
July 5, 2001 at 11:48 am
Viewing 15 posts - 39,211 through 39,225 (of 39,226 total)