did you update statistics?(see BOL "sp_autostats")

As I stated before, long running queries are often a result of bad statistics.

two servers, even with the same data, can have different statistics (and...

yeah this is a common scenario in smaller shops as they get bigger....Jeff's suggestions are right on; you'll upset the apple cart so to speak , as the developers must...

I think the update is a little deeper, you name your views just like I do with "vw_" preceeding it,and that makes me think you need to take look a...

it looks like you are actually updating a view, rather than directly accessing the underlying tables:

UPDATE vw_CostPriceUpdate_Update

SET Cost =[UK Cost]

if you do sp_helptext vw_CostPriceUpdate_Update, i bet the...

this is a prototype example, because your field names, as welll  as other manditory (NOT NULL) columns are not mentioned here.

you want to be able to insert a note from...

the script below will get you started; the core table you are looking for is sysforeignkeys

typical results:

here's how i would do it, there's probably a better way:

[edited after posting: Mike Howell beat me to it...same solution i think]

CREATE TABLE #TEST(

SERVER_NAME VARCHAR(30),

DATABASE_NAME VARCHAR(30),

DBSIZE INT)

INSERT INTO #TEST(SERVER_NAME,     DATABASE_NAME,      ...

speaking form the standpoint of a bit of experience, too many times I've encountered a situation where dates or partial dates were entered into say, a varchar field, It caused...

you have to group by the case statment in this situation..it's wordy, but that's how it works...only in the ORDER BY clause can you reference by alias, so it's like...

glad I could help.

I was wondering if your stored procedure will save your notes correctly  if no notes exist yet...it wasn't obvious to me whether the notes get saved based...

I'm assuming that on this document, it looks something like this based on your original post.

You would want to add something similar in blue; note how i removed the...

I don't think the issue is with Conn.Execute where it is calling that stored proc.

 I think you have a statement after Conn.execute that is referencing a recordset (notes maybe?) that...

here's one of many ideas you'll get:

since you have the SQL, put it in query analyzer and get the estimated execution plan.(control K in QA)

look at the plan and see...

usually select @@SERVERNAME wil return what you are looking for. if it were a n instance, like MYSERVER\SQL2005, it would be the part before the slash.

the status column is used a s a bitfield mask to query whether an index is clustered,unique, etc.

the status of zero is going to mean false for all indexproperties; it...