Viewing 8 posts - 16 through 23 (of 23 total)
What does "Redistribution or sale of dba_indexDefrag_sp, in whole or in part, is prohibited." mean?
I don't want to sell the script.
But I cannot share/redistribute this script with another DBA? Should...
February 17, 2016 at 5:59 am
With some of the automated programs using the database, they will see their SPID die and reconnect again...you can go thru all the database users and DENY CONNECT. Then when...
November 8, 2013 at 5:40 am
The code is visible in the Script Manager Format link.
September 27, 2012 at 6:33 am
change the sub-select collation:
...from...
from (
select dp.name as database_principal_name, sl.name server_login_name
...to...
from (
select dp.name COLLATE SQL_Latin1_General_CP1_CI_AS as database_principal_name, sl.name server_login_name
August 4, 2011 at 8:54 am
Added job names:
...
),'') AS BlockingText
,CASE
WHEN LEFT(es.program_name, 31) = 'SQLAgent - TSQL JobStep (Job 0x' THEN 'SQLAgent - ' + sysjobs.[name]
ELSE Coalesce(es.program_name,' - ')
END as ProgramName
,Coalesce(es.client_interface_name,' - ') as ClientInterface
...
On...
May 24, 2011 at 8:32 am
-- some small fixes...
-- Drive Space Usage/Free Monitoring Script
-- By Sriram Ramamoorthy, 2006/10/26
BEGIN
-- 20081125 fix @DBName embedded spaces
-- 20081125 fix LogFileUsed is %, not MB
-- 20081125 fix Arithmetic overflow...
November 26, 2008 at 8:31 am
SQL Server 2000 unfortunately does not help very much with this kind of information, ALTER will change the content but not the creation date, (2005 looks to be much...
June 21, 2008 at 10:16 am
This is the server-side only, but have you thought of "system information" tools?
PCWizard (http://www.cpuid.com/pcwizard.php)
SIW (http://www.gtopala.com/)
WinAudit (http://pxserver.com/WinAudit.htm)
You can even save the information in various formats...
May 2, 2008 at 6:54 am
Viewing 8 posts - 16 through 23 (of 23 total)