Viewing 4 posts - 1 through 4 (of 4 total)
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...
March 16, 2009 at 1:18 am
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 =...
March 16, 2009 at 12:58 am
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....
October 4, 2008 at 7:13 am
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...
October 3, 2008 at 12:16 pm
Viewing 4 posts - 1 through 4 (of 4 total)