User Profile

Collapse

Profile Sidebar

Collapse
lazydba
lazydba
Last Activity: Dec 20 '07, 09:49 PM
Joined: Jan 26 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • lazydba
    replied to error enabling AWE to access >2GB of memory
    in SQL Server
    hi,

    anyone who can help?

    thanks
    See more | Go to post

      Leave a comment:

    • lazydba
      started a topic error enabling AWE to access >2GB of memory
      in SQL Server

      error enabling AWE to access >2GB of memory

      hi,

      I am having a problem enabling this, I am getting the error message:

      Alter failed. (Microsoft.SqlS erver.Smo)

      Aditional information:

      An exception occurred while executing a Transact-SQl Statement or batch
      (Microsoft.SqlS erver.Connectio nInfo)

      Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access...
      See more | Go to post
      • lazydba
        started a topic sql2005 eval upgrade to retail version fails...
        in SQL Server

        sql2005 eval upgrade to retail version fails...

        Hi,

        I installed the evaluation copy on a server, the eval license expired, and now I'm trying upgrade to a retail version. I have read the docs http://support.microso ft.com/kb/914158/en-us and http://blogs.msdn.com/sqlblog/archive/2006/09/17/upgrade-eval-edtion-to-full-blow-sql-2005-editions.aspx but I'm still stuck with errors, esp in upgrading the Reporting Services module.

        First question: Can we use either Std or...
        See more | Go to post
        • lazydba
          replied to please help, select with keys problem
          in MySQL
          i agree... however, it actually has a primary key which has links to other tables which I didn't show because they're not related to what I wanted to get.

          going back, if you will look at the three tables, the only other "link" is the "call_type" which should tell us on what table to look for to search for the call_ref. In the first row of table calls, it's call_type is "Opportunit y", and on the corresponding...
          See more | Go to post

            Leave a comment:

          • lazydba
            started a topic please help, select with keys problem
            in MySQL

            please help, select with keys problem

            hi again,

            I do have another problem, i do have a database with a peculiar structure. consider these:

            table 1: calls

            call_type call_ref client_name contact_name

            Opportunity 1000 ABC Co. John Doe
            Task 1000 DEF Co Jane


            table 2: opportunity

            opp_id description

            1000 potential...
            See more | Go to post
            • lazydba
              replied to help in select pls
              in MySQL
              those were wonderful guys!

              however i must admit i have to choose iburyak's solution, which executes faster and doesn't create addl objects. thanks for the responses ronverdonk and iburyak.
              more power!

              lazydba
              See more | Go to post

                Leave a comment:

              • lazydba
                started a topic help in select pls
                in MySQL

                help in select pls

                hi,

                i have this problem and i know the solution should be simple but i simply can't get my mind to it... here goes:

                table1:

                id user location dept

                1 john ca finance
                2 james ny engg
                3 jane wa crm

                table2:

                acctname createdby modifiedby assignedto...
                See more | Go to post
                No activity results to display
                Show More
                Working...