You can find the creation date of a database by querying the information_schema. DATABASES system view. Here's the SQL query: SELECT database_name, create_time FROM information_schema.
Hi .very nice explanation. what if we dont know password for SSISDB in a standalone server instead of AO.? can we still add another master key to make it work?
Hi Vamsy,
How to know on which node the ssis is first created.
probably by creation date
You can find the creation date of a database by querying the information_schema. DATABASES system view. Here's the SQL query: SELECT database_name, create_time FROM information_schema.
Hi Vamsy kindly let me know how to join training
Bro, I think I shared my WhatsApp Number. You can reach me on +91-9739093905
It is very helpful. If it is standalone server we don’t know the password what we need to do?
This issue won't occur on the same server as SMK remains the same.
Hi .very nice explanation. what if we dont know password for SSISDB in a standalone server instead of AO.? can we still add another master key to make it work?
This issue won't occur on the same server as SMK remains the same. Yes you can create one more password.
@@vamsychiranjeevi9619 thank u.