Free Transact SQL Video Tutorial: Creating Your Own System Functions (SQL Server 2000)

Creating Your Own System Functions (SQL Server 2000) - download

Did you know that you are allowed to create your own system functions in SQL Server 2000? It's true, it's true. System functions are, like system stored procedures, callable from any database and are excellent DBA tools for reporting. There are some quirky rules associated with writing your own system functions and, if you don't know the "stricks" it's likely that you'll get stuck trying to figure them out. Check out this video for an interesting approach to writing your own functions in master.

• Category: SQL Server Videobooks
• Skill Level: 500 (Advanced)
• Length: 9:04 (5.02MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video