The path is the path on the SQL Server rather than on your local machine... If you've moved that dll to the server, check the SQL Service Account has permissions...

There's a forum post here about the same topic, looks like you just have to create an assembly for the DLL you'll be referencing:

http://www.eggheadcafe.com/software/aspnet/30462654/can-i-add-a-reference-to-an-external-dll-in-a-managed-clr-c-stored-procedure.aspx

Referencing an external DLL (except the ones...

If the application calls a Stored Procedure that you do have access to, then yes, you can wrap it in a TRY...CATCH block and raise a custom error message.

If it...

Apologies, think I misunderstood the question then. Yes, someone must have restarted the SQL Service while the rollback was still completing, so it has to recover before the database can...

If you know the session ID (SPID) of the process, you can find the percentage complete of the rollback (approximately) by looking at the following DMV:

SELECT percent_complete FROM sys.dm_exec_requests WHERE...

Ok, I think I see what you're after. So, saying you had a table where you'd imported this list called rowstoupdate, you could use MERGE (or the proprietary UPDATE...FROM) to...

LutzM (3/29/2011)

---

Wouldn't it be also an option just to remove the redundant CASE expression?

Something like

CASE

...

Thanks Paul, yep that fixes it.

I'm aware PERSISTED isn't required if it's being indexed - it was one of the things I added in trying to troubleshoot what the...

To give some more information, a functionally equivalent computed column that's calculated from a scalar function produces a seek as expected. Test case updated below to include both:

USE tempdb

GO

IF EXISTS...

Thanks Gail

Lowell (3/29/2011)

---

Howard as an FYI for your testing, when i ran your code on SQL2005 SP2, it consistently did an index seek, but on either of my SQL2008 machines, it...

When adding the following hint:

WITH (INDEX(IDX_Computed_Concatenated_Field), FORCESEEK)

I also get the error:

Msg 8622, Level 16, State 1, Line 1

Query processor could not produce a query plan because of the hints...

GilaMonster (3/29/2011)

---

Odd, when the index is forced, it seeks, but does key lookups.

Try including SystemID and Reference in that index. They should not be necessary, but somehow it appears SQL...

Standard Edition - Other question answered above

Lowell (3/29/2011)

---

Howard as an FYI for your testing, when i ran your code on SQL2005 SP2, it consistently did an index seek, but on either of my SQL2008 machines, it...