Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

  • RE: sp_start_job

    I have seen replies posted here which gave the solution of creating an alert which would start the job.   In your SQL code, you would have a RAISEERROR which would trigger...

  • RE: Can Not See Scheduler Log SchedLgU.Txt on Windows 2003

    I should have mentioned. The Win32_scheduledJob object will only work with AT scheduled jobs. 

  • RE: Can Not See Scheduler Log SchedLgU.Txt on Windows 2003

    The file is visible through the command prompt (ie. > dir c:\windows\tasks).  Not sure how to make it visible through windows explorer but it probably has to do with the...

  • RE: SQL Mail on 2000 Cluster (Unsupported)

    I believe the way to do it is create an operator which points to the distribution lists on the Exchange server.  You would then use the name of the operator...

  • RE: IS_Member Always returns dbo and not membership of a role

    In CASE you want another way. 

    CREATE FUNCTION dbo.sfFindUserRoles () 

    RETURNS int AS 

    BEGIN

    set nocount on

    DECLARE @intRetval int

     

    SET @intRetVal = CASE WHEN  IS_MEMBER ('ARMS_Analysts') = 1 THEN 1

                               WHEN  IS_MEMBER...

  • RE: CASE in FROM Clause

    A variation of AM's solution 

    DECLARE @I INT

    SET @I = 1  (OR SET @I = 2 )

    SELECT *

    FROM TABLE_A A,

         (select * from TABLE_B WHERE 1=@I

          union

          select * from...

  • RE: SQL Mail Issue

    You didn't state which version of Outlook you were using.  There are problems with some versions of Outlook (2000+) and the security patches installed when using with SQL Server 7.0. ...

  • RE: NT Authentication with XP and VPN

    Try starting up the application using the RUNAS command.

    One thing you may need to do is an actual domain log on through dial-up first using the check...

  • RE: Problem with "WITH CHECK OPTION"

    Is it possible that another row with middlename equal to 'B' is allowing the check option to be met.

    One suggestion would be to try EXIST rather than IN.

  • RE: INSTEAD-OF Trigger on IDENTITY Column

    CREATE TRIGGER [TR_Testing_I] ON dbo.VIEWTesting_META

    INSTEAD OF INSERT

    AS

    --Perform the insert in code explicitly

    INSERT INTO TBL_Testing

    (testdesc) --- shouldn't this be specified?

    SELECT testdesc

    FROM inserted

    Not sure whether the above fixes the...

  • RE: Slow performance of update statement

    Try moving the variables/parameters to the WHERE clause. Having them as part of the join condition may be causing the stored procedure to recompile each time it is called.

    ...

  • RE: at the breaking point. (in more ways than one)

    joshcsmith13, "could have two records where A=A, B=B, & C<>C, but I don't ever want A and B to be equal."

    An update/insert trigger could reject these.

    lambje :

    "col1c AS REPLACE(IsNull(col1,...

  • RE: Access to SQL Server Conversion Problem

    Just to clarify.

    You state that Access is set to medium date but you give a medium time as an example.

    "Medium Date as the Data (e.g. 9:00 AM). "

    You...

  • RE: "insert exec" much slower than exec alone

    I think the statistics are still there but not being used. I experienced what you are seeing and this is my explanation.

    If you are creating the result...

  • RE: Managing Jobs - Part 2

    We had a problem where imports would hang when importing from Access MDB's on a nightly basis. I ended up looking at some system stored procedures and based upon...

Viewing 15 posts - 1 through 15 (of 16 total)