Tip Bank

Question: I am trying to back up my server, but there are no freeware products that will save the ACLs off the files on the backup. Tape backup is not

Question: I’m looking for a copy of snip.exe. This program registers/unregisters components/DLLs under a given directory. Answer: I don’t know about SNIP, but how about an even easier method? Copy

Asking how to select into a variable using dynamic SQL is a frequent question on newsgroups because SQL Server will not let you select into a variable using the EXEC()

Question: What file extensions do I need to copy to a NT Workstation in order to install the Exchange Administrator Console? Answer: Let’s not make life any more difficult than

Question: Is there any way to recover e-mails deleted from Exchange through Outlook 2000? Answer: Yes, if you have Deleted Item Recovery enabled. If you do, you should see a

Question: How do I find the top n records within a table for version 7? I have seen some similar SQL queries but cannot adapt them to version 7. Answer:

Question: Does it make a difference in placing an OUTER or simply a JOIN or a WHERE? Using WHERE: select tb01_field01,tbl01_field02 from tb01,tb02 where tb01_field01 = tb02_field01 Using JOIN: SELECT

Question: In Access, I can get the date that was this day of this week a year ago (i.e., if today is Monday, 5/15/00, a year ago was Monday, 5/17/99)

Question: Does Informix have a function that converts datetime chars for numbers? Answer: Datetime is stored internally as an integer that represents the number of seconds from a certain starting