Yes, I would need to see 'Part Y' and...

I think I've found the problem. The index on Table A did not have the "Automatically Recompute Statistics" option ticked. I ticked this and now it seems to return the...

Jack Corbett (3/30/2011)

---

Is it the exact same query with the same parameters?

Are you getting the same execution plan each time?

What are the results of SET STATISTICS IO ON? Are you...

Just updated the statistics manually but the query still took an age to run, rebuilt the index straight after and it returned within the 10 seconds again.

Thanks Wayne, I didn't know about that IntelliSense cache 🙂

Anybody have any other ideas?

Changing the in-line queries resolved the problem; all is as expected 🙂

Thanks for your help

I checked the principal ids and found that all of the objects are owned by the same schema, however, I also found that the client application that accesses the database...

denglishbi (6/28/2010)

---

What operating system are you running? I would recommend following all of these steps - http://msdn.microsoft.com/en-us/library/bb630430.aspx - to see if that possibly resolves your issue. Assuming you...

Hi Gail,

Two of the stored procs use dynamic SQL but all of them were created by the dbo.

Ok, thanks for the advice, I'm going to try and store the note in a varchar(max) field and see how I get on with that.

When I select Design the interfaces freezes for a couple of seconds and then brings up a dialogue box with the error message and a list of debuggers to use...

Thanks Scott

If I right click and select Edit it is fine, it only crashes when Design is selected. I cannot post the actual syntax but here is roughly what it looks...

I've just run a few tests and found that it doesn't crash on every view.

On one of the views that it did crash on I get the following message:

"An...