Viewing 13 posts - 1 through 13 (of 13 total)
The script above should help, but why would that date impact whether or not something was being decommissioned? I'd think it was being used or not.
I am not sure...
August 31, 2009 at 7:34 pm
The spid does not exit when I kill it.
KILL 63
Does nothing.
July 9, 2009 at 11:00 pm
Does anyone know where xp_delete_file is documented?
March 23, 2009 at 1:20 am
Appologies if that is unclear.
The link between A and B is slow. The link between B and C is 8 times faster.
I do not want C pulling data via...
March 19, 2009 at 5:53 pm
This did the task:
select ' ',@@servername,b.name,a.name,
email_address,
case a.[enabled]
when '1' then 'Enabled'
when '0' then 'Disabled *****'
end, ' '
from msdb.dbo.sysoperators a inner join msdb..sysjobs b
on a.[id] = b.[notify_email_operator_id]
where email_address not...
January 26, 2009 at 10:51 pm
Is that using DIR ? How would you get that to work over different install paths?
November 30, 2008 at 10:59 pm
I think that the ability create virtual servers can mean less thought is going into their design. Therefore they need to be removed. I want to know how long they...
November 30, 2008 at 10:51 pm
Mainly because I am decommissioning SQL servers and building some SQL servers concurrently. I want to let people requesting them know that the life of the servers is too short,...
November 30, 2008 at 9:34 pm
I would like to know when several SQL Servers were created.
Could it be the date the earliest non system database was created?
select @@servername + ' '+ convert(varchar(20),crdate,111) +...
November 30, 2008 at 6:57 pm
Is there any Cluster check I can run before releasing the cluster to developers?
It is a UAT cluster. (User acceptance test)
November 24, 2008 at 6:53 pm
So I should install reporting services on the passive node then?
November 24, 2008 at 4:58 pm
Would you expect any node of the cluster to be available during a failover?
Would you expect that it tracks what is happening and processes that data once it is up?
Thanks
Graham...
November 12, 2008 at 5:16 pm
Viewing 13 posts - 1 through 13 (of 13 total)