WHen you backup the databse the size of the backup file is the size of your used .mdf file.For exapmle if you have afile of size 100 MB and only...

I think all the dll's which got installed during sp3 installation are still existing.If you want to reinstall there is no harm.

How many DTS packages do you have,If not too many,try to create a new job for each of them and compare the encrypted names.

By using the bulk insert we cannot automate the process I think.Since we need to pass the value to variable in the stored procedure

A friend of mine works for a bank which has 500Gb + databases on SQL Server.

Try this,I have assumed you have an ID column.

update #stateSummary

SET leadsTotal = COUNT(Tem.leadsTotal)

, revenueGross = Tem.revenueGross

, leadDistributed = Tem.leadDistributed

, leadCost = Tem.leadCost

FROM #stateSummary INNER JOIN(

select ID = ID

,leadsTotal = stateOrProvince

,...

Insert the records into the temp table from the Sp and than BCP out the data from the temp table to the csv file.I think you can build this functionality...

DO u run this script with an user id who has sysadmin permissions on the server??

you can check the Backup file size to see How much is backed up.

I think you can only copy one object at a time and need to rebuild all the links.

Triggers should help with what you are looking for.

Is this happening on all the machines or only on few.

Double check the userid and password you are tring to register is proper or not.

Which server is this,the local or the remote server.If remote server try to add in the client network utility and try to register.

I have come across this kind of problem when I was using the evaluation version,but later when I have switched it to the full version I have not come across...

Only the top 1000 rows (which are not null)