Select column names and column data from SQL table

In SQL Management Studio Select the database environment that contains the table that you want to query.
The following command displays all the columns in all the table in thje current database:

select * from information_schema.columns

 You will notice that this result set returns usefull data on the table.
To select this information from a specific table in the  [...]

SQL 2005 SERVER SET UP

I have set up a new server this week to host SQL server 2005 to manage my count engine.
Spec:
 - Antec Sonata 3 Super Case with 500W aPFC PSU
 - Abit AB9 WiFi iP965, S775, PCI-E (x16),
    DDR2 533/667/800, SATA II, SATA RAID, ATX
 - 4GB (2×2GB) Corsair TwinX XMS2, DDR2 PC2-6400 (800),
    240 Pins, Non-ECC Unbuffered, CAS [...]