ODBC. Creating File DSN

If you have File DSN  on other Box you can copy *.dsn file and edit it if required.

How to find info about your PC

run from command line systeminfo

http://bshireesh.blogspot.ca/2008/11/know-configuration-of-your-pc.html

Useful links on SQL

Article about Using sp_who2

List of queries useful for troubleshooting SQL slowness (see 'Related Post' section)

How to truncate SQL Log

http://stackoverflow.com/questions/40402/what-is-the-command-to-truncate-a-sql-server-log-file

In management studio:

• Right-click the database, choose properties, then options.
• Make sure "Recovery model" is set to "Simple", not "Full"
• Click Ok
• Right-click the database again, choose tasks -> shrink files
• Change file type to "log"
• Click ok.

Alternatively, the SQL to do it:

 ALTER DATABASE mydatabase SET RECOVERY SIMPLE
 DBCC SHRINKFILE (mydatabase_Log, 1)

Ref: http://msdn.microsoft.com/en-us/library/ms189493.aspx