Comments posted to this topic are about the item Date-based table purge
Thanks for sharing your procedure - very interesting.
One comment I have is that I noticed the parameters for the TableOwner (schema), and TableName are defined as varchar(64). Have you considered using the sysname type for these? This would be equivalent to a non-nullable nvarchar(128) type parameter.
Hi, thank you for the comment.
I'm primarily an Oracle DBA so, there are kind of things like that I don't know. It's a good idea. I'll update it in a moment.
By the way, if you are really interested, you could go and check what I've done of this with dbWarden history purge : I've made a view from which a SQL Job reads its informations to execute.
The view could be transformed to a table ...
Edit : Done 🙂
Thanks for the nice code.
Viewing 4 posts - 1 through 3 (of 3 total)