asked on
SQL SERVER - Store Procedure
I have a SP in which i need to add one condition to check multiple databases by using sys.dm_database_encryption
when encryption_state is 2 and percentage_completed is 0 in the results it should print the query i will provide.
when encryption_state is 2 and percentage_completed is 0 in the results it should print the query i will provide.
Microsoft SQL ServerSQL
Last Comment
Vitor Montalvão
ASKER
I tried this
DECLARE @Test varchar(10)
SELECT @Test = Database_ID from
sys.dm_database_encryption
WHERE Encryption_state = 2 and complete_percentage = 0
If (@test not NULL)
Begin
PRINT("ALTER DB NAme")
If i have multiple DB's which meets the about. It should PRINT multiple ALTER statements with DB Names.
DECLARE @Test varchar(10)
SELECT @Test = Database_ID from
sys.dm_database_encryption
WHERE Encryption_state = 2 and complete_percentage = 0
If (@test not NULL)
Begin
PRINT("ALTER DB NAme")
If i have multiple DB's which meets the about. It should PRINT multiple ALTER statements with DB Names.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
John, a feedback will be appreciated.
Recommendation to close this question by accepting the above comments as solutions.
Have you tried something?