Viewing 15 posts - 39,436 through 39,450 (of 39,455 total)
I'd recommend against ASP due to the times involved. The best bet is to use VB or setup a stored procedure in SQL that perfroms the restore. Then use a...
July 10, 2001 at 11:09 am
You should also be able to install the Network Monitor agent in Nt/2000 and monitor bandwidth yourself as well. This way you can see what amount of network traffic is...
July 10, 2001 at 11:07 am
bkelley is correct. When you run this under the ASP page, it runs under the context of the account running personal web server, which is usually iwam_<computername). Set this account...
July 10, 2001 at 11:04 am
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
Viewing 15 posts - 39,436 through 39,450 (of 39,455 total)