Cool, I think I understand the logic now. Thanks again for your assistance, keep up the good spirit of extendin your hands.

Thanks all for the prompt responses. I tried Gails solution but the stored proc does not like "Use" statement. I then used exec('Use database') which also failed with the same...

The problem still stands, musch as there's no error on ssms, there is a runtime error: Cannot disable trigger on database.dbo.tableName as the target is not in the current database.

Please...

Sorted, thanks.

Database name can be prefixed on the table name.

Thanks everyone. The problem is sorted. I had two databases and was trying to move data across. I was setting Identity_isert on for the current database instead of the destination...

Thanks for prompt response. The issue here is, the identity_insert is ignored thus the error. Even if I run it on ssms.

Thanks again for prompt responses.

To Brandie: I think the remote connection timeout is used by the SSMS when connecting to other servers not the application. Please verify.

I had all the...

Thanks,

It's 600, big enough for my query.

I have tried to optimize the underlying tables of my view as my stored proc is reading from the vie. One part of the sproc that retrieves few columns does...

Thanks again

I uninstalled SQL Server and reinstalled it but this time I started with Client components then server. Immidiately after installing client components, the management studio was sitting there waiting...

Thanks for a prompt response. The first installation failed. I tried again and it succeeded. I even went to advanced options to make sure that the client tools are include....