How to use a data type (table) defined in another database in SQL2k8?
Posted
by Victor Rodrigues
on Stack Overflow
See other posts from Stack Overflow
or by Victor Rodrigues
Published on 2010-05-20T18:44:04Z
Indexed on
2010/05/20
18:50 UTC
Read the original article
Hit count: 283
sql-server-2008
|user-defined-data-type
I have a Table Type defined in a database. It is used as a table-valued parameter in a stored procedure. I would like to call this procedure from another database, and in order to pass the parameter, I need to reference this defined type.
But when I do DECLARE @table dbOtherDatabase.dbo.TypeName , it tells me that The type name 'dbOtherDatabase.dbo.TypeName' contains more than the maximum number of prefixes. The maximum is 1.
How could I reference this table type?
© Stack Overflow or respective owner
