This will do a lot more than what you have asked, so you can cut it down but this is what I use to learn the maximum about a table. ...

Have you consider using views since you are preparing for reports (i.e., not updating or deleting data)

Views are also known as virtual tables because the result set returned by...

Can you be more descriptive of "haywire".  If for example you are using a numeric value for a part number and the value is 12345678901, it should display correctly but...

How abut this for a starting point:

Dynamic TSQL for extended properties

Select * from ::fn_listextendedproperty(NULL, 'user', 'dbo' ,'table', 'agents','column',Default)

Hopes this helps 

You might be interested in attempting this bit of T-SQL

select name From sysobjects where id not in (select b.id from sysconstraints b, sysobjects c where c.type = 'K' and c.id = b.constid)...

This might be of some use .. to return environmet varialbes

master..xp_cmdshell 'set'

from: http://www.sqlservercentral.com/scripts/contributions/649.asp

Returns:

ALLUSERSPROFILE=C:\Documents and Settings\All Users

CommonProgramFiles=C:\Program Files\Common Files

COMPUTERNAME=John0987

ComSpec=C:\Windows\system32\cmd.exe

INCLUDE=C:\Program Files\Microsoft Visual Studio .NET\FrameworkSDK\include

JSERV=C:\oracle\ora92/Apache/Jserv/conf

LIB=C:\Program Files\Microsoft Visual Studio .NET\FrameworkSDK\Lib

NUMBER_OF_PROCESSORS=1

OS=Windows_NT

Path=C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program...

Tracey - your question is rather vague.  Briefly some things that need to be known to even take a stab at helping you.

1.  Design of the SQL table(s) into which...

Start out with these declarations

Dim ado_cmdx As ADODB.Command

Dim cmdx_Param As ADODB.Parameter

Dim Rs as ADODB.Recordset

Set cmdx_Param = ado_cmdx.CreateParameter("@Name", adVarChar, adParamInput, 30, sTable) 'this sets up an input parameter, variable characterdata type with...

To those of you who want to know what a file extension was used for try the following site   http://www.totallydrivers.com/resources/file_extensions.asp?id=N

there it states that NDX was used as Index file (dBase...

Steve Jones,  Many thanks the info was all I required ..  and besides being a big technical help the articles were an interesting read ... again thank you

Am using the...

Thanks for the quick response will follow up with the MS site and the articles it also suggests for further reading.

Try this SQL will give you ALL tables and what SPs access the table

SELECT so.name, sob.name as 'Stored Procedure name' FROM sysobjects so LEFT OUTER JOIN (sysobjects sob left outer...

First of all I would do the following (Using of course your table and column names)

Update dbo.customers set Region = 'unknown'

where (Region) IS NULL -- repeat for each column...

Have you checked Excels help file?  To verify that you are not exceeding Excels capabilities

Here is an extract from the help file for Excel 2003:

Excel specifications and limits  

Worksheet and...

Frank,

Just out of curosity I went to your links for error handling.  All I can say is post these links often, it was a terrific read and realy, truly informative.

Thanks...