Programatically determine if user is dbo or not?

[paulray]

Is there a simple sp that can tell me if the currently logged in user has db_owner rights? We run an app that performs DB changes when necessary, but want to ensure only a member of db_owner performs the changes. VB app runs against sql2000, uses windows authentication.
Thanks
Paul

 

[JohnBates]

Paul,

I'm a month late with this but you might experiment with
'Select CURRENT_USER'
will return 'dbo' is user is really dbo

HTH, John

 

[mrdenny]

Paul,
The IS_MEMBER function will do this exactly.

Denny

--Anything is possible. All it takes is a little research. (Me)