i tried with joins but it didnt work as price column was ambiguous as i was willing to populate prices for all

how did you recognise that it is set in exchange server??

do you found any error report or log in sql anywhere??

check logon account for sql server agent.

keep it same as that of sql service and then retry.

What does the “I/O request” error below represent?

2008-04-21 13:26:42.480 spid364 Microsoft SQL Server 2005 - 9.00.3177.00 (Intel X86)

2008-04-22 16:30:02.140 spid6s ...

Hi,

Tou may find your solution over here...

Please go through following

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/21/642314.aspx

in error it is showing that 1 logfile is missing for master database.

You need to check startup parameter in sql server configurationmanager

rightclick on SQL server service >> Properties >> advanced.

there...

SP3 has also published for 2005 by microsoft.

try applying it.

Also if you are going again with sp2 then initially uninstall sp2 and client tools and then apply fresh patches

have you checked with ram size??

is sql getting req mem??

you can run performance monitor of windows and check whether at time Query get fired,is ram size greater than 500mb,

it should...

Issue resolved....

There is manage connection tab at Maintenanceplan.

I changed connections and issue resolved.

Hi

you can get this from following script..

go to qury analyser and run following

print '********** Startup Options *********'

exec master..xp_regenumvalues N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters'

go

print ''

print ''

SP2 is present on this server