May 6, 2024 at 11:40 pm
Thanks! I made the change as well. Hopefully this can be added to the latest version.
May 6, 2024 at 11:42 pm
This change needs to be in the latest version. I see the issue as well.
May 7, 2024 at 10:25 am
spcghst440 / Tim C, thank you very much for pointing out that gap!
I've been using this for literally a decade or more, and so far , in my environment, i had not tripped over a object referencing a table not in it's same schema. great catch.
I have updated the links above to have the latest changes spcghst440 pointed out.
the things that are still technically a gap that i know of are:
i use this proc as a keyboard shortcut literally hundreds of times per week. it's helped me for years. I hope it helps you too.
sp_GetDDLa_Latest.txt (Returns Table)
sp_GetDDL_Latest.txt (Returns varchar(max) )
Lowell
May 7, 2024 at 10:31 am
oh yeah, and stubborn old me only likes varchars..so if you have a table that has a name with nvarchar, like below, you'd have to find and replace all the varchar statements to nvarchars to get it to work:
CREATE TABLE [私のテーブル]
([Id] INT ,
[列名] NVARCHAR(30) )
Lowell
May 7, 2024 at 3:46 pm
Thanks for the quick fix Lowell! I too use this proc as a keyboard shortcut for years on daily basis. It has been very helpful. We do have RedGate to get the definitions for most of the tables but the system versioning table scripting are not added to RedGate yet. So I will keep using this one as it is very convenient.
Xiao
June 19, 2024 at 6:06 pm
Azure managed instance ... Could not mark system object... Could not find stored procedure 'sys.sp_MS_marksystemobject'. Is there a work around?
Thanks,
Xiao
June 19, 2024 at 6:47 pm
In Azure, the procedures sp_GetDDL and sp_GetDDLa would have to be installed in each database; so 10 dbs = 10 copies, sorry
we don't have the ability to leverage ability to mark a procedure as a system object at all in Azure SQL databases.
Lowell
June 19, 2024 at 9:16 pm
Thanks Lowell ! Appreciate the quick response.
Viewing 8 posts - 121 through 127 (of 127 total)
You must be logged in to reply to this topic. Login to reply