I want to put some trace in the a UDF, so I put print in the function. IT gave error. Can anyone please explain why this happen. But this work with SPs.
Cheers
Shimit
Print is not allowed in UDF
Hot Topic
- Can create login but cannot connect (sa doesn't even work also)
- SQL Server Express Security?
- xp_cmdshell and passing data to a web service
- DTS in SQL 2005
- Database is read-only.
- Cube corruption
- Flat File and uneven number of columns
- Programatic Fuzzy Lookup
- VBA IsError function in MDX with SQL Server 2005
- Join XML fragment with real table
SQL Server
- SQL server 2005 Express remote connection problem via SSMSE
- Command Line connect to SQL Server Database
- Linked reports lose original layout
- how to pass XML file path as input string to a Stored Procedure
- Build Question
- How to remove unused columns and eliminate warnings
- Control Flow design question
- Flat File Source, please Help !!
- Target Queue disabled
- How to add/(connect to) database in SQL Server 2005 Express?
Print is not allowed in UDF
AlisonW
this is just simply one of the limitations UDFs take, like not being able to execute something via EXEC or executing a SP in common, or using GETDATE() in functions...
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---