Viewing 15 posts - 31 through 45 (of 352 total)
Hi Lynn
you mean i have to look in each database seperately ?
no view that encompases al the databases ?
Jim
September 17, 2012 at 11:11 am
Thanks very much
Jim
September 13, 2012 at 2:08 pm
Thanks Lynn
it took me a few tries to get the URL straight
Jim
September 6, 2012 at 3:10 pm
How are these two statements different in changing the owner of the database ?
EXEC sp_changedbowner 'Emil';
ALTER AUTHORIZATION ON SCHEMA::Franny TO Emil;
Thanks
Jim
February 10, 2012 at 12:07 pm
Hi Folks
another issue just cropped up with regards to database owners and need some advice
it seems that a majority of my databases were created by lets say Domain1\User1
User1 is now...
February 10, 2012 at 9:24 am
thanks
January 17, 2012 at 3:46 pm
Hi Steve
best i can tell the schema was created by the account logged in at the time. In this case it was "LLADMIN"
DBO does not own any schemas
a majority are...
January 17, 2012 at 2:03 pm
Thanks Sean
not important enough to spend time
just asking
Jim
January 17, 2012 at 12:39 pm
Hi Steve
okay, so i guess i would do an
ALTER AUTHORIZATION ON SCHEMA for the databases then ?
you lost me on P-> V
Thanks
Jim
January 17, 2012 at 12:11 pm
Hi Steve
well when i look at owner_sid in sys.databases it shows this account as the creator (see attachment)
the reason, well... that is my question to the folks at this Air...
January 17, 2012 at 11:02 am
Thanks pieter.botha
sorry for the way late reply :doze:
Jim
November 3, 2011 at 9:09 am
Hi Folks
well I guessing that out of all the MS and SQL Server gurus, no one has ever thought about this question nor dealt with it ? Hmmmmmmmmmmmmmmmmmmmm !
Jim
July 21, 2011 at 6:51 pm
sure do ssismaddy
since i have not seen the error in three days, maybe it cleaned itself up 🙂
Jim
July 15, 2011 at 9:50 am
Viewing 15 posts - 31 through 45 (of 352 total)