devxlogo

Tip Bank

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

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

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

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

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

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

Leftover Messages

Question: Is it normal for items to remain in my mailbox resource even after I retrieve all my messages from the server on Exchange 5.5? Answer: Your mailbox “items” include