Generally, you would have issued a CREATE ASSEMBLY for your referenced assembly as well in SQL Server. If you do an auto deploy from VS 2005 it may have...

You can not use SMO inside of SQLCLR. Seems counter intuitive, but it has to do with SMO not supporting partially trusted callers and using special type of connection...

You have pretty much defined your problem correctly, so all you have to do is implement the changes you mention. What problems have you encountered implementing this, and what...

Steve,

I am not sure why that won't work for you, but here is another link:

http://msdn.microsoft.com/en-us/library/ms345124.aspx

If that doesn't work, you can google "SQL Server 2005 Row Versioning-Based Transaction Isolation" and it...

GilaMonster (7/14/2008)

Up until now, I've considered this kind of deadlock theoretically possibel, but not likely to occur in a real system, due to the frequency of queries necessary.

But I did...

Start by checking firewall settings on both ends. Windows firewall blocks SQL by default I believe, so you have to allow it to come through.

I am pretty sure that you can find the cache stores with the following query:

select distinct name from sys.dm_os_memory_clerks

There are alot of them there, but you can run any...

David Griffiths (7/14/2008)

Surely it cannot be necessary to design all indexes to cover their base tables so that no bookmark lookups take place ? What is that going to do...

It is very unfortunate, but I have been locked in a battle with the Microsoft...

David,

Your execution plan shows why you are deadlocking:

1451 | |--Bookmark Lookup(BOOKMARK:([Bmk1000]), OBJECT:([Taxi1].[dbo].[CompletedJob] AS [CJ]))665Bookmark LookupBookmark LookupBOOKMARK:([Bmk1000]), OBJECT:([Taxi1].[dbo].[CompletedJob] AS [CJ])[CJ].[Status], [CJ].[JobID], [CJ].[NeedsVerification]70.5142140.218748267.7565637E-51182.0717533[CJ].[Status],...

3000 records is quite small actually. Have you taken a stab at this already, and do you have any code that you can show that you are having a...

I have had to do hosts file hacks at times where the VPN wasn't provide DNS resolution properly to be able to connect to a remote server once the VPN...

CLR is already getting more interest, but from experience answering questions, most of it is misplaced. If you can do it in TSQL, you shouldn't use CLR. There...

I know this is an old post, but I can see it was never replied to. That book is full of syntax errors, and typos. I know because...

Having a static member variable isn't going to allow you to ever guarantee results. This is because until the appdomain unloads, your variable contains the last values set to...