Yes tried that and this is the error I am getting:

User 'RAC-PC\RAC' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC)...

I fixed my WHILE loop. I have 14 databases.

DECLARE @DB_NAME AS sysname, @DB_ID AS INT

SET @DB_NAME = (SELECT name FROM sys.databases

...

Thank you it has been fixed.

I don't understand please show me what you mean

Thanks for your help. I figured it out

Thank you,

SELECT DISTINCT O.empid, HR.firstname, HR.lastname

FROM Sales.Orders AS O

JOIN HR.Employees AS HR

ON O.empid = HR.empid

WHERE NOT EXISTS

(SELECT DISTINCT empid

FROM Sales.Orders

WHERE YEAR (orderdate) = 2007 AND

MONTH (orderdate)...