Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: Backup Job Failed

    I think sys.configuration is mess up something with this shutdown on the sever is it possible ?

  • RE: Backup Job Failed

    Yes server was shutdown not expected 

    Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
        Feb 10 2012 19:39:15
        Copyright (c) Microsoft Corporation
        Enterprise Edition (64-bit) on Windows NT 6.2...

  • RE: Backup Job Failed

    Nothing in error log specifically. I have job with t-sql script to run every moring to backup db, Check script 

    DECLARE @path VARCHAR(500)
    DECLARE @name VARCHAR(500)
    DECLARE...

  • RE: Help with query

    Founded solution

    CREATE TABLE #TempTable(
    UserID int,
    Withdrw int

    )
    INSERT INTO #TempTable(UserID,Withdrw)
    SELECT UID,
       COUNT(AS_TYP) AS AS_tYP    
    FROM AccountStatement
    WHERE AS_TYP = 2
    GROUP BY UID
    HAVING COUNT(AS_TYP) >=...

  • RE: Cursor Update issue

    Yea, Thanks.I'll test now with this script, but why this cursor dont work 🙁

  • RE: Backups

    Thanks Henrico Bekker, i will chek this bcp utillity 🙂

  • RE: Little Discussion about Sql Server Transactional Replication.

    Thanks alot guys !! 🙂

  • RE: Query completed with errors

    Actually i take 50 rows in batch and when i see reference rollback but script dosnt stop move forward take another 50 and again and again, for now from 1.5...

  • RE: Query completed with errors

    I get it man i didnt see it because i hit some rows where have reference to another table.So the statement has been terminated, but the rows is delete it...

  • RE: Query completed with errors

    This script delete data , but when finish message is Query Completed with errors., i think the problem is in this logic 

    The problem is i need to insert...

Viewing 10 posts - 1 through 10 (of 10 total)