SQLDMO

• brokenrulz

  SSCrazy

  Points: 2261

  More actions

  August 27, 2003 at 12:55 am

  #80869

  I am trying to create an interface for transferring tables from one database to another database.

  When I use the script method of the sqldmo object to get the script for the table it does not concatenate the schema owner name. This creates a problem, as there can be two tables with the same name owned by two different users.

  Any Suggestions how to go about this?

  Pay Respect to People on your way up. For you will meet the same People on your way down.

  
  He who knows others is learned but the wise one is one who knows himself.

• September 2, 2003 at 12:00 pm

  This was removed by the editor as SPAM

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  September 2, 2003 at 12:58 pm

  #472245

  Replace(objTable.Script, "CREATE TABLE [", "CREATE TABLE [" & objTable.Owner & "].[")

  --Jonathan

  
  
  --Jonathan

• mccork

  SSC-Insane

  Points: 22288

  More actions

  September 2, 2003 at 3:38 pm

  #472273

  You need to pass the value 262144 (SQLDMOScript_OwnerQualify) in scripttype. See "Script Method (Table Object)" in BOL.

  A T-SQL example is:

   
  
  DECLARE @ScriptType BIGINT
  
  SET @ScriptType = 2 | 4 | 262144
  
  EXEC sp_OAMethod @table, 'Script', NULL, @ScriptType

  Cheers,

  - Mark

  
  Cheers,
  - Mark