Professional Web Applications Themes

SQLSP3 - Microsoft SQL / MS SQL Server

Hello Prof. I am on SQL Server 2000 with VB6 and I made My stored procedure on SQLServer 2000 With no any SP but when i installed SP3--SQLSP3-- All Stored Procedure worked on Good way only the delete Stored Procedure didn't work by the way they where working in greate way befor SP3 and the Table design and table view data is changed from from-left-to-right to from-right-to-left view if any one now any thing about my problems please contanct me and send to me any solustion. Regurds Ismail Awadat...

  1. #1

    Default SQLSP3

    Hello Prof.
    I am on SQL Server 2000 with VB6 and I made My stored
    procedure on SQLServer 2000 With no any SP but when i
    installed SP3--SQLSP3-- All Stored Procedure worked on
    Good way only the delete Stored Procedure didn't work
    by the way they where working in greate way befor SP3
    and the Table design and table view data is changed from
    from-left-to-right to from-right-to-left view if any one
    now any thing about my problems please contanct me and
    send to me any solustion.

    Regurds
    Ismail Awadat
    ismail Guest

  2. #2

    Default Re: SQLSP3

    can you post the codes here so we can see. also, i suggest you take a look
    at sp3 readme file. there are quite a bit of changes relating to sqlserver
    security in sp3.

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net



    "ismail Awadat" <com> wrote in message
    news:03ac01c35980$aa4f5e40$gbl... 


    oj Guest

  3. #3

    Default Re: SQLSP3

    dear prof.
    here is my code that u asked i hope u find the problems
    and if u know how to make the screen Left-toRight Again please tell me
    CREATE PROCEDURE [delete_LOCATION_TABLE]
    (Lo_Num_1 [nvarchar])

    AS DELETE [HelpDB].[dbo].[LOCATION_TABLE]

    WHERE
    ( [Lo_Num] = Lo_Num_1)
    GO




    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    ismail Guest

  4. #4

    Default Re: SQLSP3

    Hi

    This sounds as if it is a language/regional setting that is influencing
    this! Have you checked out if they are consistent?

    John
    "Ismail Awadat" <com> wrote in message
    news:03d401c35997$6f218f70$gbl... 


    John Guest

  5. #5

    Default Re: SQLSP3

    Ismail,

    Try running sp_updatestats in your database to update statistics.

    BTW, choosing NVARCHAR as the parameter's datatype means NVARCHAR(1). Is
    that also the datatype of the column Lo_Num?

    --
    BG, SQL Server MVP
    Solid Quality Learning
    www.solidqualitylearning.com


    "ismail awadat" <com> wrote in message
    news:phx.gbl... 


    Itzik Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139