Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2003-08-28 : 11:26:35
|
| Hi,I have been looking into using some udfs in my applications. For scalar return values you need to define the udf with a two part name. (ie. dbo.myUDF). If I create a udf as the dbo and reference it in sprocs as dbo.myUDF, what happens if I later script my db and recreate it on a different server but this time not as the dbo? Maybe as MyUser? If all the sprocs reference dbo.myUDF will the call fail?Hope this question makes sense.Nic |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-08-28 : 11:44:42
|
| Yes, if dbo.myUDF does not exist in sysobject (even it nick.myUDF does), the procs calling dbo.myUDF will fail.Jay White{0} |
 |
|
|
|
|
|
udf question