Viewing 4 posts - 1 through 4 (of 4 total)
Right you are. It works when you don't specify a login, but to specify a login, you'll need this:
Alter Proc spLogin_OwnedObjects ( @login as SYSNAME ) As
/*
...
December 4, 2009 at 11:30 am
Alter Proc spLogin_OwnedObjects ( @login as SYSNAME ) As
/*
Display all objects in all DBs owned by the Login.
2008-07-06 RBarryYoung Created.
2008-08-28 RBarryYoung...
December 4, 2009 at 10:35 am
If you go back in the thread to my earlier reply with code, it has the brackets issue and the 256-table issue fixed. Hope that helps!
December 4, 2009 at 7:03 am
Hope you don't mind, I found the guts of this quite useful but modified it in a couple of ways:
1. First, I've got enough databases on the server in...
June 2, 2009 at 9:57 am
Viewing 4 posts - 1 through 4 (of 4 total)