Viewing 15 posts - 39,706 through 39,720 (of 39,726 total)
select '(' + substring( phone, 1, 3) + ') ' + substring( phone, 4, 3) + '-' + substring(phone, 7, 4)
Steve Jones
July 10, 2001 at 3:43 pm
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
Viewing 15 posts - 39,706 through 39,720 (of 39,726 total)