Forum Replies Created

Viewing 15 posts - 3,361 through 3,375 (of 6,104 total)

  • RE: DBA techniques

    This question has an incredibly broad answer, more than what can be answered completely in a forum message. Generally, the more you know about the operating system, regardless of RDBMS...

    K. Brian Kelley
    @kbriankelley

  • RE: Weblogic 6.1 or 8.1 connections

    Maybe this will help:

    Introduction to Web Logic JDBC

    K. Brian Kelley
    @kbriankelley

  • RE: "library not registered"

    You said you installed an instance. Try, just for grins, to connect to the server using \.

    K. Brian Kelley
    @kbriankelley

  • RE: xp_cmdshell returns null

    See if you can get a list of what they changed. Verify the account in question has the right to Log on as a batch job. This often gets broken...

    K. Brian Kelley
    @kbriankelley

  • RE: "library not registered"

    SQL Server doesn't start or your Enterprise Manager connection?

    K. Brian Kelley
    @kbriankelley

  • RE: xp_cmdshell returns null

    Typically in order to do this you have to set the SQL Server Agent proxy account. Verify this account still is valid (username/password). You can find out who this is...

    K. Brian Kelley
    @kbriankelley

  • RE: "library not registered"

    Crystal Reports 8.0 modified permissions in the registry. Unfortunately, this broke quite a few other systems, to include ASP web pages, etc. You might try and reset permissions based on...

    K. Brian Kelley
    @kbriankelley

  • RE: Weblogic 6.1 or 8.1 connections

    You will probably need to look for JDBC drivers since Weblogic is a J2EE web engine.

    K. Brian Kelley
    @kbriankelley

  • RE: "library not registered"

    Do you have Crystal Reports 8.0 installed on your system?

    K. Brian Kelley
    @kbriankelley

  • RE: Security Issue

    You've hit the nail on the head. If you are using connection pooling and the login parameters are the same, once you activate an application role, it's active for that...

    K. Brian Kelley
    @kbriankelley

  • RE: "library not registered"

    What was the exact error message?

    K. Brian Kelley
    @kbriankelley

  • RE: WITH ENCRYPTION

    It is very possible to decrypt, especially if you have sysadmin rights. SysAdmin rights:

    dOMNAR's SysComments Decryptor

    If you don't, but you have CREATE PROC rights, you'll need...

    K. Brian Kelley
    @kbriankelley

  • RE: sql active/active clustering without san

    Without a full blown SAN? Yes. Without a dedicated shared storage array? No. You're going to need some sort of hardware to support the shared drives. You'll need at least...

    K. Brian Kelley
    @kbriankelley

  • RE: Security Issue

    There are a couple of issues with application roles. First, the application has to make a stored procedure call in order to activate the application role. Once that application role...

    K. Brian Kelley
    @kbriankelley

  • RE: Trigger that executes for each row deleted

    Piggy-backing on what Andy has said, if you're on SQL Server 2000, take a look at INSTEAD OF TRIGGERS. INSTEAD OF TRIGGERS fire before the data is touched, meaning you...

    K. Brian Kelley
    @kbriankelley

Viewing 15 posts - 3,361 through 3,375 (of 6,104 total)