Using a User Defined Function as a constraint within a temporary table.

Try adding dname also in UDF call

ie like

create table #check
(
SportID int
,WinTeamID int
,LoseTeamID int
,check 
(
(<dbname>.dbo.CK_LoseTeamSportExists(LoseTeamID,SportID) = 1)
)
)

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c