Tip Bank

Question: How do I define a new line character in ASP? Answer: In ASP (VBScript), use the constant vbCrLF to add line breaks in your string variables: strString = “Hello”

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

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

The TreeView control doesn’t expose any property that lets you limit the amount of text users can type when editing a Node’s label. However, you can do the trick with

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

Question: I have Outlook 2000 set up to talk to an Exchange Server, and have added my POP3 email account to Outlook’s profile. How can I compose a new message

Question: Does AutoAttachment work only with certain versions of Outlook?I have Outlook 97 and it doesn’t have Tools/Macro. :-( Answer: Yes, the VBA capabilities were added in Outlook 2000. Sorry.

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

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