Hi RBarry Young

are yiou sure

it is still not working

i copied the code from above

Thanks

Jim

Hi RBarry Young

sorry to bug you again, but i came across another issue when running this on another server

seems there's a 256 limit somewhere

Msg 106, Level 15, State 1, Server...

Well at least it was obvious to you and you fixed it quickly

thanks again

jim

Excellent RBarryYoung

it was not obvious to me apparently.. what was it ?

Thanks

Jim

Hi RBarryYoung

still having issues:

E:\SQL_Server_SQL>sqlcmd

1> --http://www.sqlservercentral.com/scripts/Administration/63631/

2> --Find all objects in Server Owned by a Login

3> --By RBarry Young, 2008/08/28

4>

5>

6> CREATE Proc spLogin_OwnedObjects ( @login as SYSNAME ) As

7> /*

8~...

Hi RBarryYoung

i treied to implement and am getting errors on execution:

Msg 102, Level 15, State 1, Server NSAB-SS80-SQL-N, Line 262

Incorrect syntax near '-'.

Msg 102, Level 15, State 1, Server NSAB-SS80-SQL-N,...

Thanks John

will do

Jim

Hi John

forgot to ask

by any chance, do you know what tables that is pulling the info from ?

thanks

jim

Excellent John

thanks very much

jim

Thanks RBarryYoung

wil look at it

Jim

Hi Perry

yep. that was my goal. i am on SQL server 2005

Thanks

Jim

Hi Perry

what I am looking for is a search of all databases and any objects owned by an account, if any, in these databases.

when i run the script, i get...

Hi Perry

does that just give me a llst for the person logged in ?

Thanks

Jim

Hi folks

did anyone every come with a valid script fot sql server 2005 ?

Thanks

Jim

Thanks Grasshopper

that was it

i was trying to add the alias to the line instead of replacing it

Jim