Views very slow after SP4

From: Cristian (Cristhm@mi.terra.cl)
Date: 02/19/03 

From: "Cristian" <Cristhm@mi.terra.cl>
Date: Wed, 19 Feb 2003 09:36:43 -0800

Hello Kids:
      IŽd installed the Services pack 4 for SQL Server 7.
The installation was succesfully. But, the problem that
appears is when run wiews inside stored procedures. When i
run the view only it finish in 4 seconds. If I run the
view inside an stored procedure with INNER O LEFT JOIN,
the time to run is 40 seconds o more. This problem appears
after install the services pack 4.
      Does anyboby knows why is the cause of this problem?
      I heard that another users have the same problem.
   Thanks.
       

Relevant Pages

  • No System stored procedures in MSDE install
    ... create PUBS and NWIND. ... "Cannot debug stored procedures because the SQL Server database is not ... I then looked in the System Stored Procedures via the .NET IDE and I ... Or perhaps my installation is corrupt? ...
    (microsoft.public.sqlserver.msde)
  • Re: Configurating the Firewall in both Linux and Xp!
    ... Especially when you have kids in your house smart enough to know ... > the installation instructions for it:) ... Now for my windows I do use Firefox. ... machine, they have no CDrom drives, nor Floppy drives in which to try to ...
    (comp.security.firewalls)
  • Re: Configurating the Firewall in both Linux and Xp!
    ... Especially when you have kids in your house smart enough to know ... |>the installation instructions for it:) ... | machine, they have no CDrom drives, nor Floppy drives in which to try to ... Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org ...
    (comp.security.firewalls)
  • Re: To VPC or multiBoot?
    ... If you install XP a second time in its own partition for the kids, ... something like bootitng as your boot manager. ... *** keep your kids out of the main Windows installation. ...
    (microsoft.public.windowsxp.general)
  • Re: COBOL/DB2 Date edit question
    ... There are benefits to stored procedures - but the RDBMS runtime would ... Play with the kids. ... risk being involuntarily retrained to some combat career field; ...
    (comp.lang.cobol)