Assigning Object Ownership

mdjones

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

richardjm

Is this a SQL Compare issue?

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