It is reproducible. I will try your suggestion.

Which tool shall I use to see the deadlock graph?

Maybe you are right that I have to see the other side too.

However, what is your opinion about a Select failing with transaction deadlock error? What might be the possible...

No. It is not part of a transaction. I just log in with Management Studio and I run this SQL command. No. These are not views. They are tables.

Of course,...

Thanks you very much. I didn't know this sql update syntax.

Thanks again.

panayotis matsinopoulos

Thanks for the answer.

For the aside...I want to do the following

I have two tables, table X and table Y, that I want to synchronize. They have the same data structure,...

[font="Comic Sans MS"]

I agree with you. I like new Activity Monitor too. However, still removing a right-click option from an obvious and natural place (Management node of the tree) that...

[font="Comic Sans MS"]

HI,

I just found it. It is on the right-click menu when this is clicked on the server node of the tree and it does not exist anymore on...

Ok. Thanks a lot for your answers.

BR

Panayotis Matsinopoulos

[font="Comic Sans MS"]

Thank you for the answer.

I will try CLR. BTW, what do you have in your mind when saying about other options?

[/font]

[font="Comic Sans MS"]

MANY MANY THANKS to both of you. You have answered my question and now I can go on.

[/font]

[font="Comic Sans MS"]

Thank you for answering.

I tried this one:

select * from sys.sql_modules;

and I suppose that the definition column contains the body of the function.

However, I realized that it does...

[font="Comic Sans MS"]

Thanks a lot guys. All the answers were really helpful to me.

BR

Panayotis Matsinopoulos

(I am wondering now how shall i mark this post as "answered" or "closed" or "resolved"...

[font="Comic Sans MS"]

Hi Jonathan,

Can you please clarify this please? Is the ravithegreat case/question a case of an unapproved .NET BCL (Base Class Library) assembly?

Thanks in advance

Panayotis Matsinopoulos

[/font]

[font="Comic Sans MS"]

Hi,

I have come across this problem myself in the past, and I found the solution here:

http://www.sqljunkies.com/WebLog/ktegels/articles/SigningSQLCLRAssemblies.aspx

Generally, the assembly you are trying to deploy needs to be signed with...