I don't have SQL 7 with me now but I think the order should be:

DECLARE <cursor name> SCROLL CURSOR FOR SELECT * FROM <table name>

can you test that?

HTH

if you are willing to do that then is just a matter of opening the procedure on query analyzer and add an extra line :

insert into DBA.dbo.Access ( Who, When,...

if you are not planing to use profiler and do not plan to modify the sps the only thing I know will be Entegra

HTH

have you tried:

Select * from Tablename Where Substring(ImageField ,8,4) ='WAVE'

HTH

This is the classic views-of-views problem in SQL Server the best approach is to use as many base tables as posible and you will have effectively solve the problem. Try...

Don't be embarrased it happens to me usually when my cafeine levels are not high enough

One of the main uses of RAISERROR is to prevent client side code from creating EMPTY ADO recordsets which become really expensive objects in the middle tier of a heavily...

run the two queries as batches like:

select * from tbl1 where xx = 'yyyyy'

select * from tbl1 where xx = 'zzzzz'

you should get as many resulsets as batches you send!

HTH

PBirch: That was exactly my same thought

And Even though you have indexes are those defragmented ? -- Try a rebuild

As a Console is used for troubleshooting setup problems, rebuild master and other very rare occations

HTH

>>I guess it is time to add ram! <<

I guess is time for a where clause 

CREATE Procedure dbo.sp_select_image

(

 @iGuid nvarchar(50)

)

AS

SELECT

 iNo,

 iName,

 iSize,

 iType,

 iDescription,

 iUploadDate,

 iUploadPersonGuid,

 iApproved,

 iRating,

 iByteData -- Notice is at the end

FROM

    tblimages

WHERE

    iGuid = @iGuid

GO

I am not sure if you are using ADO or ADO.NET but you can't assign an...

>>Sometimes I think I'm the only one that strugles with obscure problems.  Just don't seem like they happen to other people... <<

For what is worth: A LOT OF US THINK THE SAME...

Edwar,

Like I said no RI with FK will solve your problem with SQL 2000 but here is a proposition

create function dbo.CheckOwner(@id = null int)

returns int

as

begin

 if @id IS NULL or Exists(select...