cannot run object locking script

• 
  Hi dkv,
  
  The setup script just runs:
  

  IF DB_ID(N'RedGate') IS NULL
      CREATE DATABASE RedGate
  

  
  so we don't tell it where to create the RedGate database. This appears to be an SSMS option for default database location, which apparently no longer exists.
  
  I think it must be the database default location:
  
  1. In Object Explorer, right-click on your server and click Properties.
  2. In the left panel on that Properties page, click the Database settings tab.
  3. In Database default locations, view the current default locations for new data files and new log files. To change a default location, enter a new default pathname in the Data or Log field, or click the browse button to find and select a pathname.
  
  NOTE: After changing the default locations, you must stop and start the SQL Server service to complete the change.
  
  Please let me know if this is the case.
  
  Kind regards,
  Alex

  Alex B August 29, 2016 10:39

  - 0 +
• 
  I created the RedGate database in desired location and had my DBA run the script. Where do I check to see if the trigger got created? I dont see the trigger under RedGate, or master databases.

  dkv August 30, 2016 16:46

  - 0 +
• 
  Hi dkv,
  
  The trigger should be created under Server Objects > Triggers and should be called "RG_SQLSourceControl_DDLTrigger".
  
  Hope that helps!
  
  Kind regards,
  Alex

  Alex B August 31, 2016 13:04

  - 0 +

Add comment

Please sign in to leave a comment.