A condition in a where clause should be :

insert into #spacetemp (DBname,DBcreationDate,DBStatusid,DBStatus)

select [name],crdate, status,case

when status=1 then 'autoclose'

(....)

end

from master..sysdatabases where (status & 512 = 0) and dbid >case when @sysdb=1...

This script crash when a database is offline:

A simple where condition should is missing:

SELECT [NAME] FROM Master.dbo.sysdatabases

WHERE [NAME] NOT IN ('MASTER', 'TEMPDB', 'MSDB', 'MODEL')

AND Status & 512 =...

It could be. It is a nonzero chance for get unable login error, when you have more than one domain controller and sqlserver server use another DC than your computer....

I assume that you work within domain.

In this situation the problem could be caused by duplicated value SPN (ServicePrincipalName) assigned to to two different user accounts or assigned both to...