You can have a look at 'Schema Changes History' Report for that database using SSMS.

from this you should be able to see when the last schema change was for your...

Oracle is a lot better suited to working with cursors, SQL server works best with sets of data.

It is a bit hard to help as it depends on what...

Yes that is the way that usually done, it means you can manage all your servers from your pc, also the less server resources you use the better.

you do need SQL Management Studio to manage SQL Server, it just does not need to be installed on the server.

can you ping the server from your machine?

have you enabled Sql Browser?

Well Generally SQL sever is run on a server with a bare as possible install, this means that unless you need the service then there is no reason to install...

I thought i had a big databse at 1TB 🙂

400TB is huge, I can imagine that there would be plenty of issues invovled in maintaining it..

Management Studio does not install as default when you are installing on a server, you need to click on the option to install Client tools if you...

Restore your database to your test server, but give it another name so it does not over-write what you have, make sure you change the .LDF + .MDF file...

i sure some one can, what is your question?

The SQL 2005 Bible is a really good book which contains a lot of the information that you need to get you started.

http://www.amazon.co.uk/Server-2005-Bible-Paul-Nielsen/dp/0764542567/ref=sr_1_2?ie=UTF8&s=books&qid=1217869687&sr=8-2

Another way to do this rather than using permissons would be to use

system_user

you could put a conditional statement at the begining of your procedure that only runs if...

This means that you have two instances of SQL server running on the same server, it is like having two seperate sql servers running.

So you need to be careful...

It looks like you are out of space on the drive that Temp DB is running from,

Do you have some space free? or do you have another drive to...

A bit hard to tell , they still do work, are you able to post your query and the table with some sample data?