FYI - as of SSRS 2017 you cannot install multiple instances of Reporting Services on a single machine.  Instead of trying to figure out how to manage encryption keys for...

Here is requirement

i have directory and i know the path where it creates folder

D:/Employees/

Under this employees folder we will have so many sub folders, and its not constant we...

You would use DATEDIFF with the units difference you would like to see.  I would recommend using a unit one step below the actual requirement unless you only want to...

I tried the account on SQL Agent on a different server, one of the three we set up at this time, and it works fine on the other server.

How...

Unless you are actually having issues where you know that offloading the reads is going to help - then read-only routing is only going to make your system more complex...

Good to know - thank you for the feedback.

@michael-2 - I was not assuming anything.  I provided one example of where moving system databases to the same disk/volume as user databases could cause issues.  The point I was...

I think that depends on what you consider an upgrade.  The schema in the database may or may not be upgraded - that is going to depend on the changes...

Grant the service account full control on the drives that contain the SQL database files.  In my case, that's D, L, H, and T

Grant the service account...

Have you verified...

Grant the service account full control on the drives that contain the SQL database files.  In my case, that's D, L, H, and T

Grant the service account full control...

Hey Sorry,

I got this sorted Thank you.

CASE WHEN WHEN d.CancelDate ='1900-01-01 00:00:00.000' AND d.ClosingDate = '1900-01-01 00:00:00.000' THEN '' --'NO Valid Closing Date' ELSE DATEDIFF(day, d.ClosingDate, d.CancelDate)+1 END AS...

Those would work although those particular dates are a wee bit into the future assuming those are the little-endian count of days since the first of January 1900.  One...

There are a lot of problems with that code - formatting makes it very difficult to read as well as missing alias references and so many places where you are...

This is fairly well documented here: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-distributed-availability-groups?view=sql-server-ver15&tabs=automatic