Drop the indexes and bulk insert and check. It should boost the performance. After bulk insert recreate all the indexes.

Is the both the inputs are standard or varies?

Using SP_configure u can find the options set in 2005 sever.

And it is always recommended to use dbcc checkdb after migration.

Drop the nonclustered located on PRIMARYINDEX acct_id, cont_stub

and check.

select a.query,sum(a.querycnt+b.querycnt) from #jan a ,#feb b

where a.query=b.query

group by a.query

File Stream data type stores the file on a physical folder instead of the database file itself, but we can "insert" or "select" the file just like it was stored...

Yes,Creator's permissions are being impersonated when the user having "EXECUTE" privilege is calling the stored procedure.

Check EXECUTE AS Clause in BOL

Set production database in single user mode

Take full back of production database

Following is example for Detach the Database

EXEC sp_detach_db 'AdventureWorks', 'true';

Following is the example for Attach the Database

EXEC sp_attach_db @dbname...

No need of having IIS. Use BOL for TL restore script, it is defined very well with good examples.

What is criteria for arriving Debit Amount and Credit Amount?

Please post the error message you are getting in System Event log.

Can you change the service start account to Local System and try staring the

SQL Server Agent service. Use SQL Server configuration manager to chnage

the service startup account.

I mean real data and what is maximum rows and column u get??? and is there any delimiter??? and how can u arrive that it is first line in the...

What are the operations you are performing in the scripts?????