How do you set an SQL Server Job Parameter to Null when Required is set to False.
When you first deploy a package and set up a job I can see some parameters are defaulted to NULL and it appears in italics so you know it is NULL value and not a NULL text. However, when you view the data by clicking on the edit button the field is blank. If you change the value to something other than Null to blank say (or simply do nothing other than click the ok button) you can never it get back to NULL. Is there some key combination trick to set it to Null??

I created a server Login and mapped it to a new database user. When the new database user tried to login, error message:

I have the following query which is used to export data in XML format. I was using the same query for years on SQL Server 2008.

I have the following query which is used to export data in XML format. I was using the same query for years on MS SQL Server 2008.

I have the following query which is used to export data in XML format. I was using the same query for years on MS SQL Server 2008.

I have a stored procedure in SQL Server 2019. It truncates a staging table and then inserts data. I have granted User1 EXECUTE permissions for this stored procedure usp_insert_data.

I have a stored procedure in SQL Server 2019. It truncates a staging table and then inserts data. I have granted User1 EXECUTE permissions for this stored procedure usp_insert_data.

I have stored procedure in MSSQL Server 2019. The stored procedure TRUNCATES a staging table and then INSERTS data. I have granted User1 EXECUTE permissions for stored procedure usp_insert_data.

I am using SQL Server 2019. I have a few job steps. The first step is to kick start a few child jobs. For instance, SQL Server agent parent job in which the 1st step is to execute 4 different child jobs 1, 2, 3, 4 and the 2nd step is to execute another job child job 5, after starting the child job 1, how to wait until child job 4 is successfully completed before moving on to the 2nd step which is to execute child jobs 5, 6, 7 which has dependency on the jobs 1, 2, 3, 4, But I want to make sure all the prior jobs 1, 2, 3, 4 completed successfully? How would I check for completion of 1st step until however long it takes and then start the execution of step 2?

I have a SQL Server agent parent job in which the 1st step is to execute 4 different child jobs 1, 2, 3, 4 and the 2nd step is to execute another job child job 5, after starting the child job 1, how to wait until child job 4 is successfully completed before moving on to the 2nd step which is to execute child job 5?