User Defined Table Types between different databases

3

I created a User Defined Table Type in a DB1 database. If I try to declare a variable of this type in a BD2 database procedure it gives me the following error:

  

The type name 'BLABLA' contains more than the maximum number of prefixes.

As I could not resolve this, I tried to create the same data type in both databases. The statement did not give error, but when trying to send the data type created in the DB2 database to a procedure in DB1 it gives the following error:

  

"Operant type clash"

Is there any way I can send a table of data from a procedure in a DB2 database to a procedure in a DB1 database?

    
asked by anonymous 25.08.2014 / 14:02

1 answer

1

The message

  

Operand Type Clash

It means that you have declared both types in different databases and they have some difference between them that causes the database to get lost.

There is an article where Microsoft clarifies how this works, as well as recommends a number of precautions when dealing with User Defined Types.

    
25.08.2014 / 16:24