aaarch Wednesday morning syndorme affected my query !

-- if all [account#] have rows...

"I am basically looking for all account #’s that have no systems associated to them"

SELECT [Account#]

From [System_Account_Association]

where [Associated?] ='NO'

group by [Account#] -- in stead of distinct because it...

You'll have to check with your developer(s) to see if they realy need all possible bytes.

Meybe they've worked out a combination so they don't exceed 8060 bytes in a...

In fact, that QOD pushed me to launch this thread.

We don't use CR, so I loose that argument.

- what's the servers load when you try to connect and suffer the problems :

  * cpu

  * memory

  * tempdb-load

  * network

  * numer of connections at the server

 ...

with this supposed to be correct result : please contact pss.

when expantion is done "in process", you may get timeouts to the "expand file" request. SQLServer then says "...file full".

The request itself is not terminated, but is completed after...

from BOL :

WITH <termination>

Specifies when to roll back incomplete transactions when the database is transitioned from one state to another. Only one...

Maybe this udf can be used as a workaround :

if exists (select * from dbo.sysobjects where id = object_id('dbo.udf_Get_Last_DayNr'))

  begin

 Drop Function dbo.udf_Get_Last_DayNr

 print 'Dropped'

  end

go

Create Function dbo.udf_Get_Last_DayNr

(  @Start_DateTime AS datetime ...

Maybe you can read the reg-key from within your application's front-tier (not at the mid-tier or server) and have the timezoneshift delivered by your application.

Frank Kalis pointed me toward a way to find out the local timezone using the registry :

DECLARE @delta INT

EXEC master.dbo.xp_regread

'HKEY_LOCAL_MACHINE'

, 'SYSTEM\CurrentControlSet\Control\TimeZoneInformation'

, 'ActiveTimeBias'

,...

This is without a question a joint venture of DA and DBA.

But if you forget to have your standards supported by you top-level ceo your project...

in sql2k you can also use

alter database yourdb SET OFFLINE  WITH ROLLBACK IMMEDIATE

This way you avoid problems with reattatching the db at the same server and all users...

If you only want the userid - names , you can query against systables using Isql.

These are queries against the systemtables; I do not recommend to make an habit of it.

If...