Re: query analyzer table owner

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks but I cant create the scripts dynamically, the scripts are already
generated for me by another application so I get something like:

Select account, email from account where accountid = 'xyz'

and I need to change it to

select account, email from sysdba.account where accountid = 'xyz'

it's not so bad for a simple statement like this but once you get joins and
nested sql it gets cumbersome

<Jens.Suessmeyer@xxxxxxxxxxxxxx> wrote in message
news:1140074651.542770.75340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
You can quickly create scripts by using this command:

SELECT 'sp_changeobjectowner ''' + TABLE_SCHEMA + '.' + Table_name +
''',''newowner'''
FROM INFORMATION_SCHEMA.Tables
WHERE TABLE_SCHEMA = 'oldowner'

(Untested)

HTH, jens Suessmeyer.



.

Relevant Pages

  • Limited/Restricted user can install programs.
    ... 2.user XYZ who is also administrator. ... as per the description in the user settings this user XYZ wont be able to install any programs but just use the system. ... Although spybot search & destroy wont launch setup warning that account is restricted. ...
    (microsoft.public.windowsxp.basics)
  • Restricted user can install programs
    ... 2.user XYZ who is also administrator. ... as per the description in the user settings this user XYZ wont be able to install any programs but just use the system. ... Although spybot search & destroy wont launch setup warning that account is restricted. ...
    (microsoft.public.windowsxp.basics)
  • Client SMTP Issue
    ... receive email all in one account, ... XYZ and send from Outlook here. ... and put the ABC server as POP and our server at ...
    (microsoft.public.exchange.clients)
  • Re: Sendmail aliases, wildcards, and mail header manipulations
    ... given ISP for XYZ, Inc. ... When we receive the email we would like to strip ... where someacct is a local unix account. ... dnl The '-t' option will retry delivery if user is over quota ...
    (comp.mail.sendmail)
  • Re: Cannot execute new programs
    ... >I have to fix a PC w/ NT4 WKS, ... >then logon as XYZ and try to execute these new programs but I fail; ... >I tried to delete the XYZ account and create it again, ...
    (comp.os.ms-windows.nt.admin.security)