Forum Replies Created

Viewing 15 posts - 39,436 through 39,450 (of 39,466 total)

  • RE: MSDE and security

    Encryption is the only possibility. If you are concerned about the security, once you send data on the wire, it is vulnerable, so it must be encrypted at the client.

    Also,...

  • RE: The DBA Dot Com Bust

    Our server setup is:

    1 SQL Server 2000 - Production and live site.

    1 SQL Server 2000 - Demo Site (also hosts web)

    1 SQL Server 2000 - QA, bug db, release db,...

  • RE: The DBA Dot Com Bust

    My guess is there is a combination of a couple factors.

    1. More Oracle physically installed. That accounts for more jobs in general.

    2. Oracle is a more complicated product and...

  • RE: SQL 2000 and Setting up SQL Mail

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

  • RE: moving server locations with NO down time

    Thanks again and tell your friends, DBAs and developers.

    Steve Jones

    steve@dkranch.net

  • RE: MSDE and security

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

  • RE: moving server locations with NO down time

    Glad we can help. Feel free to ask anything, anytime.

    Steve Jones

    steve@dkranch.net

  • RE: Schema Naming Conventions

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

  • RE: moving server locations with NO down time

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

  • RE: @@ROWCOUNT problem

    I've used both of these suggestions, though developers usually prefer burthold's suggestion of using the ADO value.

    Steve Jones

    steve@dkranch.net

  • RE: Taming Strings

    select '(' + substring( phone, 1, 3) + ') ' + substring( phone, 4, 3) + '-' + substring(phone, 7, 4)

    Steve Jones

    steve@dkranch.net

  • RE: sql backup and restore

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

  • RE: Bandwidth issues during restores

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

  • RE: Executing DTS COM

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

  • RE: Securing DTS packages

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

Viewing 15 posts - 39,436 through 39,450 (of 39,466 total)