October 2006 - Posts

If you are having issues connecting to a particular service, you can test using telnet to help isolate the problem. For example, if you are having trouble sending email but you can browse different websites, start by opening a command prompt (Start > Read More...
When using certain SQL tools, some stored procedures like dt_* are created automatically. These are more annoying than harmful. Here is a link to help you clear these SPs out or you can *try* and ignore them :) http://databases.aspfaq.com/database/what-are-all-these-dt-stored-procedures-and-can-i-remove-them.htm Read More...
If your database is acting sluggish, try sp_updatestats: " sp_updatestats effectively executes UPDATE STATISTICS, by specifying the ALL keyword, against all user-defined and internal tables in the database. sp_updatestats displays messages that indicate Read More...