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...

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...

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...

Glad we could help.

Steve Jones

steve@dkranch.net

Have you tried checking if there is a default or FK bound? Cascading updates?

Steve Jones

steve@dkranch.net

Please let us know what you find out. This is an interesting problem that I am sure others have run into.

steve

Steve Jones

steve@dkranch.net

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...

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...

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...

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...

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...

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

steve@dkranch.net

Haven't done much work on OLAP, but most logins raise an event. I'd guess there is an alert set on the server.

Steve Jones

steve@dkranch.net