Viewing 15 posts - 38,221 through 38,235 (of 38,242 total)
There is no way to do this with Zero downtime unless you can implement a WAN cluster between the sites. Otherwise, however long it takes to move the dbs is...
July 11, 2001 at 4:14 pm
I've used both of these suggestions, though developers usually prefer burthold's suggestion of using the ADO value.
Steve Jones
July 11, 2001 at 4:05 pm
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
Viewing 15 posts - 38,221 through 38,235 (of 38,242 total)