Viewing 15 posts - 39,871 through 39,885 (of 39,898 total)
If you can, log into the production boxes iwth the SQL Agent account and verify you can send and recieve mail. something may have been lost.
Then log out and...
July 12, 2001 at 11:54 am
July 12, 2001 at 11:52 am
Using encryption is really the only way, however, the encryption needs to occur in the client, so the DATA is encrypted when it is stored and decrypted when it is...
July 12, 2001 at 11:41 am
July 11, 2001 at 5:15 pm
I developed a standards document similar to Michael Hoteks, but more in line with my habits. I am a fan of abbreviations and Proper case, but I have seen some...
July 11, 2001 at 5:13 pm
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
Viewing 15 posts - 39,871 through 39,885 (of 39,898 total)