especialy on production boxes, you may want to avoid haven autoclose active !

This way sqlserver will keep the database open and you'll avoid the time consuming open action for your...

IMHO your "quotable" datatype is a user defined datatype

Easyest way to find out is to use Enterprise Manager, connect to the database and...

- can you see anything in the sqlserver errorlog file(s) when you reboot the server ?

- or in the errorlog.1 file if you start it manualy ?

- Are there any...

maybe this may be a valid workaround :

help to tighten use of cmdshell or sp_start_job 

try using underscores (_) in stead of minus signs (-) in your servernames !

and there is off course the IS_SRVROLEMEMBER ('sysadmin')

Indeed, membership of sysadmins-role is tricky !!

It switches context to 'sa' at connect and run-time.

This clarifies the "dbo" !

A sysadmin is Lord and Master for the whole and complete,...

.. Thanks for your help with this by the way! ..

That's the strength of forums like SSC

Like you do, I find your results...

can you also try :

select user_id('malinowm2')

?

another 'why not use a view' :

You cannot alter a view if someone is using it at that moment !

UID    Uname

------ ------

1      dbo

means your current user _is_ the database owner !

(if he were member of db_owner, it would still show the actual username)

can you execute the same script preceded by :

select user_id() as UID

, user_name() as Uname

select SUSER_SID ( )  SUSID

, suser_sname() as SUname

go

keep in mind you need to be connected with that user and to the correct database.

Overhere it works fine (sql2000 sp4 + CU(2187))

Did you also try sp_helprolemember @rolename = 'testrole'

Is there a maintenance plan (with remove free space ? ) ?

- check your sqlserver errorlog file to find out what's going on !

(yourserverdrive:\mssql\log\errorlog = to be opened with notepad)