I believe that the general consensus in the group is that the best practice is to store the images in a file system and the paths to the images, along with...

Does it think the stuff in the double quotes is a column name?  If so, the database options may be set to QUOTED_IDENTIFER ON, and that can be turned off...

The proc it's complaining about is the one you're explicitly executing and not a proc called by the one you're calling?

Are you sure the database context actually points to the correct...

Is the procedure owned by dbo?  If not, you'll have to qualify the ownere when you call it, or change the owner to dbo. 

My guess is that the data on the two systems is different.  If you remove the sub-query and run it by itself, do you get one result on the production...

What sort of performance improvement were they expecting to get from a smaller log?  Do they know where the performance bottleneck is, or is just a guess?

If by 'I don't have the database on my computer' you mean you don't have any version of the SQL Server engine installed on your computer, you won't be able to...

Could you also post the code that calls the function and the code that checks the return?

Tough to know what to do without knowing what symptoms the problems you are experiencing exhibited.  The numbers above don't necessarily point to anything without a better context.  If you were...

It's not unusual for queries to run faster the second time.  The data is probably still in memory during the second execution and therefore all the physical IO is avoided.

There...

CREATE Procedure select_Proc1

@Key3 varchar(10)

As

BEGIN

IF (@key3 IS NULL)

BEGIN

Select key3

From Or_Table 

END

ELSE

BEGIN

Select key3

From Or_Table

Where

(key3 = @key3)

END

END

Could you post the table DDL and the XML file (or a sample of it)?  I might have some time to play with this tomorrow.  It's been a while since...

You can't have the 'END' after the OPENXML.  It breaks up the insert in an unacceptable manner.

 How about this?  I moved the 'END' from the middle of the insert.

ALTER PROCEDURE [dbo].[Users_Update_Phones_2]

@UserName nvarchar(256) = null

,@SqldocPhone

varchar

It's hard to tell without knowing what the primary key actually is (phone?  phoneid?) but here's a rough guess.

IF (x.PhonesID = 0 OR...