Is SQL Server running with port 1433. If so try with servername,1433. Else check whats the port being used by sql and login with that port.

Daft(Might not be your right name)

You are in the right forum for asking questions in SQL Server. You will find answers for all ur questions here.

Its better to upgrade all ur servers to SP2. It has fixes for lot many problems. SSIS had many problems with SP1 and many has been fixed in SP2.

Check if the coonection property is given right. Packages fail if the connection are not right or modified wrongly.

If you are using log shipping you have the option to toggle  between standby and recovery mode. hope yoy can try that.

thats in KB. you need to sum up the index, data and reserved columns to get the space used by a table.

use alter database to change the size of tempdb then restart sql services.

There are few ways.

1. Start your profiler and trace the activity

2. Audit the server login and logoff

3. write a job to track all the users activity that happens between 4AM...

Hey you do you want to use your mail XPs when 2005 has database mail with it which does a more powerful job to send mail than the previous mailing...

select * from opendatasource('Microsoft.Jet.OLEDB.4.0',DataSource="PATH OF EXCEL FILE";user id =Admin;password=;Extended properties='Excel 8.0')..[Sheet1$] where your conditio.

Is this query enough for you.

Case senstitive depends on the collation settings that is preferred. You can set collation @ server, database, table and column level.

http://www.sqlservercentral.com/forums/post.aspx?forumid=146&messageid=373676

I have already posted the query there.

You can bring all under the same transaction. So that i you get error at then end the whole transaction is rolled back.

Are you sure you have not taken any backups after dec 6th. If so you can try this. Take a full backup as of now. Then take a transaction log...

If you want you can sum the data,index and reserved columns to find out the exact space used by the tables.