e.g.

set nocount on

declare @OnlineRebuild char(1)

Set @OnlineRebuild = 'Y'

print '-- Begin ' + db_name() + '  ' + convert(varchar(25),getdate(),121) ;

Declare @SQLStmt varchar(max);

declare c1 cursor for

--print...

did you read http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=510 by Clinton Herring ?

btw

- Are you using the correct BROKER_INSTANCE when you create the route ?

CREATE

ROUTE ErrorLoggerSendRoute WITH

did you try

GRANT SEND ON SERVICE ::ErrorLoggerReceiverService TO Public

in both db's !!

- 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.