will give it a try

thanks

jim

Hi Folks

not an upgrade

a fresh install on a new server

Jim

Hi Folks

the info provided is fine for one database or one login, but

what I am trying to accomplish is to pull all the

loginnames from syslogins and join them to whatever...

Thanks

will give it a shot

Jim

Thanks

will try it out

Jim

Thanks elliot

i will see what i can find

Jim

Hi Steve

well I am directly on the server via a remote desktop connection running sms. I am not remote so I am not sure.

Thanks

Jim

Thanks Tim and Elliot

Jim

Hi GSquared

thanks very much, it worked

i did have to take the quotes off the numbers as the value is integer (my fault)

other than that, BEAUTIFUL !

Appreciate it

Jim

Thanks Gail

will take a look see

Jm

whoops..

I meant "not be" used"

Jim

Thanks Gail

are you saying sysprocesses should be used then ?

if so, what is replacement ?

jim

Hi Folks

so if i wanted to pull info from either of these two tables which schema should i be using then; dbo or sys ?

is there always a 1 to...

Well...

it is geting there

at least no errors

but i have names like this: LOSANGELES-2K\cox.jim.adm

EXEC spLogin_OwnedObjects 'LOSANGELES-2K\cox.jim.adm'

it returns nothing and i know there are objects there as i was getting them before...

Sorry

Msg 207, Level 16, State 1, Server NSAB-SS83-SQL-N, Line 7

Invalid column name 'Login'.

Msg 207, Level 16, State 1, Server NSAB-SS83-SQL-N, Line 7

Invalid column name 'Login'.

Jim