Set a wait time for DDL Lock 


alter session set ddl_lock_timeout = t;

Comments

Post a Comment

Please leave your comments

Popular posts from this blog

Image
Elements for IS Auditing An information system is not just a computer. Today's information systems are complex and have many components that piece together to make a business solution. Assurances about an information system can be obtained only if all the components are evaluated and secured. The proverbial weakest link is the total strength of the chain. The major elements of IS audit can be broadly classified: Physical and environmental review —This includes physical security, power supply, air conditioning, humidity control and other environmental factors. System administration review —This includes security review of the operating systems, database management systems, all system administration procedures and compliance. Application software review —The business application could be payroll, invoicing, a web-based customer order processing system or an enterprise resource planning system that actually runs the business. Review of such application software includes acce...
Read more

How to Fix ( Failed To Create A Phonebook Entry)

Failed To Create A Phonebook Entry |Fix This Error If you are logged on to your PC or laptop using a Guest account. Try to logon using an account with Administrative rights and then try if you are getting the same error ”Failed to create a phonebook entry". If the answer is yes, then try the following… For Windows XP Operating System: First ensure show hidden Files & Folders is checked under folder options. From  My Computer  select  Tools  followed by  Folder Options  then  View.  Under  Advanced settings  tick  Show Hidden Files and Folders  then select  Apply , then  OK. Browse to  C:\Documents and Settings\All Users\Application Data\Microsoft\Network\Connections\Pbk Right click on  Rasphone  file and click  Properties . If the  Read Only  box is checked, remove this, then select  Apply  then  OK . Rename the folder called  pbk  to...
Read more

Find Last Day of Any Month (SQL Server)

a) Find the last day of the previous month, current month and next month. Last Day of Previous Month SELECT  DATEADD ( s ,- 1 , DATEADD ( mm ,  DATEDIFF ( m , 0 , GETDATE ()), 0 )) Last Day of Current Month SELECT  DATEADD ( s ,- 1 , DATEADD ( mm ,  DATEDIFF ( m , 0 , GETDATE ())+ 1 , 0 )) Last Day of Next Month SELECT  DATEADD ( s ,- 1 , DATEADD ( mm ,  DATEDIFF ( m , 0 , GETDATE ())+ 2 , 0 )) b) . Last day of any day specified. Last Day of Any Month and Year DECLARE  @dtDate  DATETIME SET  @dtDate  =  '8/18/2007' SELECT  DATEADD ( s ,- 1 , DATEADD ( mm ,  DATEDIFF ( m , 0 , @dtDate )+ 1 , 0 ))
Read more