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)

indeed:

Index Id 0 = a heap table (table with no clustering index)

Index Id 1 = a clustering index (on index 0 possible )

Index Id 255 = lob container

That's indeed a nice article Peter

Also ginish , this...

maybe this is what you may be looking for:

CREATE FUNCTION ufn_dba_Get_Daterange (@Startdate smalldatetime, @Enddate smalldatetime )

RETURNS @RangeDates TABLE (DateValue smalldatetime not null)

AS

BEGIN

   DECLARE @Number int

   Set @Number = datediff(d,...