EM detects your user is member of DB-Owner and therefor gives the default objectowner dbo. EM does that kind of stuff

I think what you need is just to add the NOLOCK hint in stead of "transaction isolation level read uncommitted" which may influence your results because you can read uncommitted...

FYI MS has confirmed this to be a problem.

Because the are a number of workarounds (which we described) and we appeared to be the first to report this, no...

test this :

use pubs

go

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE FUNCTION dbo.udf_convert_date2WeekRange (@RefDate datetime, @FirstLast char(1) = 'F')

RETURNS datetime

AS

BEGIN

    DECLARE @return_date as datetime

    declare @firstdate datetime

    declare @WrkDate datetime

    declare...

- you might consider bulk-copy-recovery model, but you 'll always have some logging.

- can you use @-table-datatype ? (sql2k) this one has less logging then # or @@-temp-tables.

- You might...

if that is what you need .... create a parameter table in which you keep your last or next value per keytype (r/c/...)

Isn't it the same for you application/user if...

Found it back.

Take a look at http://www.dbbest.com/

When using SMSnetworksniffer, I can see that all sql2k servers return the FQDN, but my cluster-instances do not !

Now I have added our...

"set transaction isolation level read uncommitted" is used to avoid waits for locked resources.

table hint (NOLOCK) can be used to avoid read locks on resources.

IMO you should contact your 3rd...

Put indexes on the FK-columns of your dependant tables (if multi-column, provide exact order and sorting !). (1 index per FK !)

If you have cascading deletes enabled, you can delete...

- 1) the sum of both "Min server memory" ( 5092 *2 ) > (8Gb - 1 Gb)

        (the -1Gb is the space for the OS to run and manage the...

Multiprocessor box ? try adding with MAXDOP  = 1 (ckeck BOL)

(there is an issue with count(*) with sql2ksp3a)

As always the straight way has some curves.

Indeed, ms-office / vbs / ... are often not taken into account when considering security.

IMO...

The advantage of using group-by is that it can use an index if available and suitable. 

distinct is done by adding a sort-step before...

- Which sqlserver version is this being run on ?

- Can you post ddl with some data ?

- Can you post some (small) "correct" and "false" result sets ?

- Does...