Tip Bank

DevX - Software Development Resource

Changing Limits on Message Size

Question: How do I change the size limits of messages in a mailbox? Answer: You can’t really set a limit on the individual messages already in a mailbox, but you

DevX - Software Development Resource

Delete Files from SQL Server Local Machine

Ever wanted to delete files from the local machine that your SQL Server database is running? You can do it using the extended stored procedure xp_cmdshell like this: EXEC master..xp_cmdshell

DevX - Software Development Resource

Workaround for SendKeys

Sendkeys “{TAB}” can lockup the keyboard in Windows 2000. Here’s how toexecute a tab in the keydown event using the Win32 API to get around thisWindows 2000 bug: Private Sub

DevX - Software Development Resource

Autoforward Problem

Question: I have given the autoforward rule from Inbox Assistance to an internal ID (Say X) as well as two outside ID’s (Hotmail & usa.net). But the forwarding is not

DevX - Software Development Resource

Selecting Data from Views with Aliases

Question: If I have created a view from two tables that happen to have a similar column name (e.g., name) : CREATE VIEW team AS SELECT p.name, p.age, t.name, t.city

DevX - Software Development Resource

Limit Access to Free/Busy

Question: Our CEO has three Personal Assistants who access his Mail and Calendar Items. He does not anyone else to be able to book a meeting directly. How can he

DevX - Software Development Resource

Forward Declaring Classes

Question: I wrote: class Adjective { Sentence adjective_sentence; }; class Noun { Adjective a; }; class NounPhrase { Noun n; }; class Sentence { NounPhrase np; }; Of course it