You need to post full script, otherwise it is very difficult to find out the error.

You need to post full script, otherwise it is very difficult to find out the error.

Try the following syntax

declare @string varchar(max)

set @string = 'abcd'

select * from openquery

(TEST_Server, 'select * from Table1 where Field1 = ' + @string + '')

Refer to the following link

http://www.mssqltips.com/sqlservertip/1793/sql-server-indexing-basics/

Check the following link may help u

http://stackoverflow.com/questions/4444169/import-data-from-excel-using-ssis-without-knowing-sheet-name

DATEDIFF ( datepart , startdate , enddate )

Check the following blog:

http://blogs.msdn.com/b/sqlsecurity/archive/2009/03/25/enforce-password-policy-on-sql-server-logins.aspx

This will enforced the login of the Windows password policies of the computer on which SQL Server is running.

Check is there policies enforced?

use distinct clause in select

Check update statistics and fragmentation level of the tables

Need look at the table structure,indexes and SP to know more...

Application Support DBA

Avoid cursor and try use while..loop

What is the server meant for ? Reporting or transactions? What is the budget ?

Delete the two columns in Report file and recreate the same and check