Forum Replies Created

Viewing 15 posts - 16 through 30 (of 72 total)

  • RE: Try Catch doesnt work

    Eirikur Eiriksson (2/20/2016)


    farax_x (2/19/2016)


    Why Try Catch doesnt catch collation exceptions? How can I handle it?

    BEGIN TRY

    IF '1' COLLATE Arabic_CI_AI = '1' COLLATE Arabic_100_CI_AI

    ...

  • RE: Encrypt Stored procedures !

    JustMarie (2/17/2016)


    I have to ask - what's in the stored procedures that you want/need to encrypt them?

    It contains some secret formulas 😎

  • RE: Encrypt Stored procedures !

    There are some third-party apps like sql-shield that can securely encrypt. I'm looking for free solution 😛

  • RE: Difference between Runnable, Running, Conditional

    but I have conditional state !

  • RE: ** Urgent !!! ** Connection Timeout Expired !

    mark.williams 37494 (11/18/2015)


    So you are on the SQL server itself and you are trying to connect to 127.0.0.1 ?

    Yes. It connects when I'm connecting with "." or server name but...

  • RE: ** Urgent !!! ** Connection Timeout Expired !

    anthony.green (11/18/2015)


    1- Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: 192.168.128.76]

    Whats...

  • RE: ** Urgent !!! ** Connection Timeout Expired !

    mark.williams 37494 (11/18/2015)


    Are the SQL services running?

    Yes of course !

  • RE: ** Urgent !!! ** Connection Timeout Expired !

    It occurs in all environments when connecting also "Sql management studio" :

    TITLE: Connect to Server

    ------------------------------

    Cannot connect to 127.0.0.1.

    ------------------------------

    ADDITIONAL INFORMATION:

    Connection Timeout Expired. The timeout period elapsed while attempting to consume...

  • RE: ** Urgent !!! ** Connection Timeout Expired !

    I have problem when using network because I have no problem when connect using "." but I have difficulty when using "127.0.0.1" !

    Event long errors are these :

    1- Length specified...

  • RE: Random number !

    what should I do for comparing ?

  • RE: Get help for Select

    thank you very much Eirikur but it wont work for this :

    declare @tt table

    ( TagId int, TagType int, ReportId int)

    INSERT INTO...

  • RE: Get help for Select

    I want to get reports which have both (tagid=1000 and tagtype = 344 ) AND (tagid=71 and tagtype=300) and dont have any other tagid. so this query wont be...

  • RE: Consultant about like operator

    Sean Lange (3/11/2015)


    farax_x (3/11/2015)


    The point is I cannot determine word ! As I said consider i'm dev,il

    After replace it turns to "imdevil" ! Seprating charachters need artificial intelligence which isnot...

  • RE: Consultant about like operator

    The point is I cannot determine word ! As I said consider i'm dev,il

    After replace it turns to "imdevil" ! Seprating charachters need artificial intelligence which isnot related to my...

  • RE: Consultant about like operator

    I cannot determine individual word because user may manipulate it for example consider this sentence : i'm de,vil

    If devil is bad word you cannot detect it! In this regard I...

Viewing 15 posts - 16 through 30 (of 72 total)