Create scripts with stored procedure
-
Hi, i'm searching for a stored procedure (or other way) to create scripts from objects in a database, given the object as parameter. Reason i do this is : I want to create a script of all objects modfied after a certain date. Those i can retrieve using
select * from sys.all_objects where /*name like 'tbl_%' and*/ modify_date > '2007-10-29'but now i want to create automatically a script of those modified objects. Thx Kurt -
Hi, i'm searching for a stored procedure (or other way) to create scripts from objects in a database, given the object as parameter. Reason i do this is : I want to create a script of all objects modfied after a certain date. Those i can retrieve using
select * from sys.all_objects where /*name like 'tbl_%' and*/ modify_date > '2007-10-29'but now i want to create automatically a script of those modified objects. Thx Kurthi You can use EnterPriseManager to create the script of objects. Then why r u searching for Stored Procedures. Reagrds Joe
-
hi You can use EnterPriseManager to create the script of objects. Then why r u searching for Stored Procedures. Reagrds Joe
hi, i want it to generate automatically, not using the enterprise manager or studio.. a select from systemobjects and use those to generate all new or modified tables, triggers and stored procs... in one action, without selecting them yourself. greetz kurt