Activity overview
Latest activity by 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 / comments
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, do...
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 ...