How can we help you today? How can we help you today?

Assigning Object Ownership

I ran into a problem last night trying to use Red-Gate to migrate SQL 2005 DEV db stored procs to a new DEV db...Sps were original created under an owner called "stage." (stage.ProcedureName), SQL 2005 MS scripts it as dbo. Almost as if RG were pulling proc owner from a different sys table
mdjones
0

Comments

2 comments

  • richardjm
    Is this a SQL Compare issue?
    richardjm
    0
  • mdjones
    Not certain though do suspect maybe SQL2005. Our process creates SP's as 'dbo' from a staging owner but when we use RG to script it, its output remains STAGE.PROC. Question they're now asking, does RG get the SP text from the information_schema.routines? This might explain the scripting issue
    mdjones
    0

Add comment

Please sign in to leave a comment.