Yes, I will be writing code. 

Is it possible to set a script up to read our server names from a table in the 'monitor' computer and retrieve the data...

great - that worked for 2000.  In 2005 it shows 'disabled',null respectively.  Other properties, such as edition work though.

anyone?

'About the only thing that will not work is Access, or any database on a Mac.'

I doubted that statement - and it made me curious about filmaker pro's capabilities.

http://www.rhinorecords.com/ is...

You're very welcome!

I'm sure if you give him an ERD created in Visio He will be impressed.  Wikipedia is always good

As far as the access solution goes - all...

You'll need to look into data modeling - you need to make tables to define something like:

CLIENT has 0 or more CONSULTANTS

CONSULTANT has 0 or more CLIENTS

CLIENT has 0 or...

from: http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c04ppcsq.mspx#ECPAC

- which is a great resource for beginners such as you and I!

Expanding Databases and Logs Manually

Sometimes you'll want to increase the size...

see below -

For a quick fix, can you just increase the size in EM?

You do have space on your disk right?

A verify is as good as a test restore?

Thanks everyone for your comments - I appreciate them VERY much.

And after you've done that - how would you compare to be assured everything matches?  Do most people go that far.  I know there are 3rd party tools for comparing,...

Would getting rid of the temp table altogether help things?  Then you could just put the index on the table if it doesn't already exist.

Very cool.  I see it puts all the data in a trace file. I'd still want to get those into a table.

"SELECT * FROM ::fn_trace_gettable('C:\Program Files\Microsoft SQL

SQL authentication is commonly used for client which CANNOT use Windows authentication - they are totally separate and a client uses SQL OR NT. 

I suppose developers use SQL logins for...