Forum Replies Created

Viewing 15 posts - 4,081 through 4,095 (of 6,104 total)

  • RE: Yukon - T-SQL changes

    Any Microsoft betas are carried out in this manner if for no other reason than to manage expectations. For instance, let's say Microsoft adds what seems like a cool new...

    K. Brian Kelley
    @kbriankelley

  • RE: ENCRYPTION over the Internet ?????

    IPSec comes to mind. If you don't have a VPN solution, this gives you the option of something close. But it's not exactly going to be easy.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start...

    K. Brian Kelley
    @kbriankelley

  • RE: Trigger on sysdatabase table to track DB renaming

    It also becomes an unsupported configuration should you need to place a service call to Microsoft. Also, triggers on system objects aren't guaranteed to fire.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish...

    K. Brian Kelley
    @kbriankelley

  • RE: DBMS vs File Management System

    FMS and DBMS are moving together. Oracle has already tried it. Microsoft is now doing so as well (note the date is 2002 on the following article):

    http://news.com.com/2009-1017-857509.html

    It's been talked about...

    K. Brian Kelley
    @kbriankelley

  • RE: public role

    The public role includes every user who has access to the database. This cannot be undone. Don't grant the user access to the database and the user won't have access...

    K. Brian Kelley
    @kbriankelley

  • RE: IIS and SQL with Windows Authentication

    hthan, no, if you're not able to use a domain account you'll have to have local accounts on both sides with matching usernames and passwords.

    You can set the anonymous user...

    K. Brian Kelley
    @kbriankelley

  • RE: SQL Server Security: Why Security Is Important

    The old link just recently died. The new link doesn't paste correctly into the forum. 🙁 I'll see about doing some sort of redirect myself from my web site.

    K. Brian...

    K. Brian Kelley
    @kbriankelley

  • RE: CMDEXEC job PRIORITY

    You can't do anything specifically with SQLAgent. What you can do, however, is have SQLAgent call a batch file that calls the VB program. I believe this gets around the...

    K. Brian Kelley
    @kbriankelley

  • RE: Using multiple instances on a cluster.

    We have Active\Active clusters in inventory. The main catch is to plan to hardware to handle the memory requirements should all instances fail to 1 node. Enough processing power, etc....

    K. Brian Kelley
    @kbriankelley

  • RE: Review: EditPlus

    quote:


    sure you have no masochistic addiction?

    vi is certainly a great editor for people who like to work only with the keyboard...

    K. Brian Kelley
    @kbriankelley

  • RE: Does SQL Mail 2000 require Outlook?

    How to create MAPI Profiles without Outlook:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;306962

    This article talks about the procedure. Basically, you'd be installing the Exchange server-side MAPI instead of the client-side MAPI of Outlook. Having not done...

    K. Brian Kelley
    @kbriankelley

  • RE: Using SQL Mail on a Clustered Server

    quote:


    is probably more related to an inability to resolve email names than anything else. We see this on non-clustered environments.


    K. Brian Kelley
    @kbriankelley

  • RE: Does SQL Mail 2000 require Outlook?

    You do not need Outlook. You could use the Exchange client and seperately create the profile. This is covered in a couple of different KB articles. However, the simplest solution...

    K. Brian Kelley
    @kbriankelley

  • RE: Using SQL Mail on a Clustered Server

    I agree with Shas3. It's doable, make sure the profile names are identical, etc. Make sure you set up the profile identically on both sides. But at the end of...

    K. Brian Kelley
    @kbriankelley

  • RE: Review: EditPlus

    This reminds me of the emacs vs. vi debates we used to always get in on the Unix side. I use Textpad heavily because it does...

    K. Brian Kelley
    @kbriankelley

Viewing 15 posts - 4,081 through 4,095 (of 6,104 total)