from BOL :

Usage Considerations

Before enabling AWE, consider the following:

• When awe enabled is set to 1, instances of SQL Server 2000 do not dynamically manage the size of the...

here's a good article :

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

HTH

here's the test result :

Msg 8618, Level 16, State 2, Line 1

The query processor could not produce a query plan because a worktable is required, and its minimum row...

I like the new SET option

there ara SAN systems that have an archiving option, meaning datafiles not used for x time migrate to tape until called for.

I've only seen the concept-picture, but have never seen...

- what kind of transaction are you using ?

- what kind of connection isolation level are you using ?

- what kind of lock-mechanism is active when the sp is being...

just a sidenote :

keep in mind ssc is running out of memory because we are !

so you could get this :

create proc spc_xxx

as

begin

set nocount on

-- first table is CUSTOMER table that have 2 field (id_cust,id_support)

-- second table is SUPPORT table that have 3 field (id_support,...

is this what you are looking for ?

update Customer

set id_support = S.id_support

from Customer C

inner join  (

 Select id_cust, count(*) as counter

 from rc_sortir_intag

 group by id_cust) CC

on C.id_cust = CC.id_cust

inner join Support...

May I emphasize BP id_columns should not be used but for PK/FK perposes, so a count(*) for id_columns should only determine the number of usage, but nothing else ?!

with int datatype you don't have decimals

you could do

select convert(decimal(11,3),yourIntCol) / 100 as youDecCol 

(adjust...

There has been a bug in sql7 where this osql using sa was a workaround.

now I'm out of ammo

May seem a bit strange, but what happens if you make a sqlagent-job and have it execute the sp/dbcc using OSQL with sa-login ?

e.g.

osql -Usa -Pdontleaveitblank -S yourserver -d master -Q...

Using EM you can't view all jobs, unless you are sa

Maybe this proc can help out using QA :

Use master

go

if exists (select * from dbo.sysobjects...