- did you check the Troubleshooting Service Broker (SSB) script ?

- did you check the sqlserver errorlog ?

open an RDC connection using your sqlagent-serviceaccount or sqlserver-serviceaccount.

Then try to run one of the FTP cmds from the cmd-prompt.

This way you're sure it uses the securitycontext of your serviceaccount.

Also...

- did you enable crossdatabase ownership chaining ?

If not db1.dbo <> db2.dbo

select Math.Student_No

from (select Student_No

         from yourtable

        where Subject = 'Math' ) Math

inner join (select Student_No

         from yourtable

        where Subject = 'Science' ) Science

on Math.Student_No   = Science.Student_No

Maybe someone will know the answer, but this is not a mysql site

This site handles Microsoft SQL Server.

Please alow me to refer to the sp2a thread for followup of sp2 :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=112&messageid=349577

Aparently they realised they messed up .... and this is not good for anyone of us !!

Does anybody remember the T-shirts "Nomore underdog" ?

Thank you for the feedback.

I'm still looking for the solution

That should be no problem ...

http://www.sql-server-performance.com/awe_memory.asp

EE can use up to 3Gb without awe

I use this script in a scheduled job to perform online indexrebuilds whenever possible (EE and DevEdtn only !)

set nocount on

declare @OnlineRebuild char(1)

Set @OnlineRebuild = 'Y'

print '-- Begin...

that's a flaw in taskmanager. (it cannot handle AWE stuff) There is more info on it at sqlservercentral.

I think perfmon shows correct figures.

I think you should also include @columnid = 13 in your trace setting to be able to apply a filter on it.

So far, so good

how about disksubsystems ?

number of disks ?

type of disks ?

cache ?

rpm ?

write performance ? (ms)

... Hardware is nearly the same ...

- What are the HW differences ? (ram, disk,..)

- how about filefragmentation (disk level) ?

- If you just create empty objects and load with data,...

I/O ? Disks,..

How about the filesizes for the databases, are they the same, do they extend the same.

Has the new db been allocate at least the same size as the...