Re: Lock of Object if i create users with a script file
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/27/03
- Next message: Narayana Vyas Kondreddi: "Re: SQL2000"
- Previous message: Andreas Berneaud: "Lock of Object if i create users with a script file"
- In reply to: Andreas Berneaud: "Lock of Object if i create users with a script file"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 27 Jul 2003 12:16:48 +0100
You should be able to change the owner of a view while it is being used,
provided it is not being queried continuously without a break. But on a
heavily used system, your sp_changeobjectowner call could be blocked by
schema stability locks.
It is better to take a brief outage when deploying database changes.
-- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ What hardware is your SQL Server running on? http://vyaskn.tripod.com/poll.htm "Andreas Berneaud" <aberneaud@web.de> wrote in message news:eZjLK5CVDHA.2016@TK2MSFTNGP09.phx.gbl... Hi. My work is to create/add database users on an existing(working) sql server. Now i want to know if some database objects (table, views etc) are locked in the time in that i create roles, users and logins with a script file. If i chang the owner of a view, is this view executable between that time or should i stop the program which use the view ? Thanks for your help. Ciao Andreas
- Next message: Narayana Vyas Kondreddi: "Re: SQL2000"
- Previous message: Andreas Berneaud: "Lock of Object if i create users with a script file"
- In reply to: Andreas Berneaud: "Lock of Object if i create users with a script file"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
