<![CDATA[Article Comments for Eli Leiba]]>http://www.windowsitpro.com/authors/author/author/5296126/rsscomment/5296126en-USSun, 27 May 2012 06:12:01 GMTSun, 27 May 2012 06:12:01 GMTAutomated SQL Server Health Check Solution http://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorTue, 27 Sep 2011 08:42:26 GMT
The scripts are located when you download the 135921.zip from above. I didn't get that at first either, but I believe you have to run the config.sql script first then, the preciding scripts and lastly the execute chk_wrapper_mssql_health.sql script. Also I don't know if anyone else came across this with the scripts but I had to chage most of them with two single quotes, to one quote. I tried setting quoted_identifiers off before I changed them but that did'n work. ]]>jwbart06Tue, 27 Sep 2011 08:42:26 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorAutomated SQL Server Health Check Solution http://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorFri, 23 Sep 2011 12:43:04 GMT
I receive the error: When executing sp1.sql, I get the following message: Msg 102, Level 15, State 1, Procedure chk_cpu_busy, Line 7 Incorrect syntax near '*'. Msg 102, Level 15, State 1, Procedure chk_cpu_busy, Line 11 Incorrect syntax near 'CPU_BUSY'.]]>Joseph DunleavyFri, 23 Sep 2011 12:43:04 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorAutomated SQL Server Health Check Solution http://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorSat, 10 Sep 2011 10:24:11 GMT
Rob, I too am getting similar errors when trying to sp1.sql...]]>kevin630Sat, 10 Sep 2011 10:24:11 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorAutomated SQL Server Health Check Solution http://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorTue, 06 Sep 2011 15:14:18 GMT
When executing sp1.sql, I get the following message: Msg 102, Level 15, State 1, Procedure chk_cpu_busy, Line 7 Incorrect syntax near '*'. Msg 102, Level 15, State 1, Procedure chk_cpu_busy, Line 11 Incorrect syntax near 'CPU_BUSY'. ]]>RobTue, 06 Sep 2011 15:14:18 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorAutomated SQL Server Health Check Solution http://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorWed, 31 Aug 2011 08:05:49 GMT
All scripts are attached when you are logon.]]>Matthieu MoffetWed, 31 Aug 2011 08:05:49 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorAutomated SQL Server Health Check Solution http://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorMon, 29 Aug 2011 05:59:23 GMT
whera are the scripts ? pse adv / suprt brgds Dennis Magielse]]>dennisMon, 29 Aug 2011 05:59:23 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorAutomated SQL Server Health Check Solution http://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorFri, 26 Aug 2011 15:14:37 GMT
As above aferentz .. would like to see the scripts]]>Paul KayleyFri, 26 Aug 2011 15:14:37 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorAutomated SQL Server Health Check Solution http://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorFri, 26 Aug 2011 13:52:01 GMT
Where are the script files? This looks useful I would like to implement.]]>aferentzFri, 26 Aug 2011 13:52:01 GMThttp://www.windowsitpro.com/article/database-administration/automated-sql-server-health-139521#commentsAnchorDynamically Obtain a SQL Server’s IP Address in T-SQL Codehttp://www.windowsitpro.com/article/tsql3/dynamically-obtain-a-sql-server-s-ip-address-in-t-sql-code#commentsAnchorTue, 14 Dec 2010 10:29:49 GMT
is there an enhanced version for windows 2008?]]>SaadeTue, 14 Dec 2010 10:29:49 GMThttp://www.windowsitpro.com/article/tsql3/dynamically-obtain-a-sql-server-s-ip-address-in-t-sql-code#commentsAnchorChange Many Server Configuration Options in One Fell Swoophttp://www.windowsitpro.com/article/tsql3/change-many-server-configuration-options-in-one-fell-swoop#commentsAnchorMon, 05 Jan 2009 13:09:06 GMT
Very usefull stored procedure. Thanks.]]>DavidMon, 05 Jan 2009 13:09:06 GMThttp://www.windowsitpro.com/article/tsql3/change-many-server-configuration-options-in-one-fell-swoop#commentsAnchorFind Weak Database Passwordshttp://www.windowsitpro.com/article/tsql3/find-weak-database-passwords#commentsAnchorThu, 02 Oct 2008 16:49:01 GMT
Oh, yeah, I added the following at the end of the select statement to exclude the Certificate logins: and syslogins.name NOT LIKE ’##MS_%##’]]>TIMThu, 02 Oct 2008 16:49:01 GMThttp://www.windowsitpro.com/article/tsql3/find-weak-database-passwords#commentsAnchorFind Weak Database Passwordshttp://www.windowsitpro.com/article/tsql3/find-weak-database-passwords#commentsAnchorThu, 02 Oct 2008 14:54:39 GMT
Thanks for the code. This works good for trivial passwords, but after I created a login with a blank password using Management Studio (on SQL 2000 & 2005 instances), it doesn’t show up on the report when I run this. After creating a login with blank password using Enterprise Manager on a SQL 2000 instance, that login shows up as NULL password on the report. Examining the syslogins table, Management Studio apparently doesn’t store the password as ’NULL’, even though when logging on with that account, a blank password works. Can you modify the code for this? Thanks.]]>TIMThu, 02 Oct 2008 14:54:39 GMThttp://www.windowsitpro.com/article/tsql3/find-weak-database-passwords#commentsAnchorT-SQL UDF Quickly Determines How Often a Substring Appearshttp://www.windowsitpro.com/article/tsql3/t-sql-udf-quickly-determines-how-often-a-substring-appears#commentsAnchorFri, 22 Feb 2008 09:49:31 GMT
I’ve reported this issue to our Web team and we’ll get it resolved ASAP. Thanks for your patience.]]>AnneFri, 22 Feb 2008 09:49:31 GMThttp://www.windowsitpro.com/article/tsql3/t-sql-udf-quickly-determines-how-often-a-substring-appears#commentsAnchorT-SQL UDF Quickly Determines How Often a Substring Appearshttp://www.windowsitpro.com/article/tsql3/t-sql-udf-quickly-determines-how-often-a-substring-appears#commentsAnchorThu, 21 Feb 2008 10:36:13 GMT
Another dead link. http://www.sqlmag.com/files/09/96786.Figure_01.jpg]]>ANTHONYThu, 21 Feb 2008 10:36:13 GMThttp://www.windowsitpro.com/article/tsql3/t-sql-udf-quickly-determines-how-often-a-substring-appears#commentsAnchorEasily Find Rows That Violate Constraintshttp://www.windowsitpro.com/article/tsql3/easily-find-rows-that-violate-constraints#commentsAnchorTue, 29 Jan 2008 11:37:21 GMT
The download link appears to be working now. Let us know if you still can’t download the code.]]>AnneTue, 29 Jan 2008 11:37:21 GMThttp://www.windowsitpro.com/article/tsql3/easily-find-rows-that-violate-constraints#commentsAnchorEasily Find Rows That Violate Constraintshttp://www.windowsitpro.com/article/tsql3/easily-find-rows-that-violate-constraints#commentsAnchorMon, 14 Jan 2008 04:08:14 GMT
Can not download the code, it gives me an error on www.winnetmag.com not being available...]]>FrederiekMon, 14 Jan 2008 04:08:14 GMThttp://www.windowsitpro.com/article/tsql3/easily-find-rows-that-violate-constraints#commentsAnchorT-SQL UDF Quickly Determines How Often a Substring Appearshttp://www.windowsitpro.com/article/tsql3/t-sql-udf-quickly-determines-how-often-a-substring-appears#commentsAnchorTue, 06 Nov 2007 11:36:31 GMT
Maybe it will be faster to instead of using your logic use: len(replace(s,sub,sub + ’*’) - len(s) It should work faster I supposed because you have no division and you do not have to check if you string has any characters inside.]]>JanuszTue, 06 Nov 2007 11:36:31 GMThttp://www.windowsitpro.com/article/tsql3/t-sql-udf-quickly-determines-how-often-a-substring-appears#commentsAnchorEasily Find Rows That Violate Constraintshttp://www.windowsitpro.com/article/tsql3/easily-find-rows-that-violate-constraints#commentsAnchorWed, 13 Jun 2007 06:50:08 GMT
the download comes down empty?]]>helenWed, 13 Jun 2007 06:50:08 GMThttp://www.windowsitpro.com/article/tsql3/easily-find-rows-that-violate-constraints#commentsAnchorProtect Your T-SQL Objects from Deletionhttp://www.windowsitpro.com/article/tsql3/protect-your-t-sql-objects-from-deletion#commentsAnchorFri, 01 Jun 2007 12:58:09 GMT
I hope I never have to resort to something like this. I try to keep users who might tend to drop objects from having such permissions in system databases. That’s the first level of protection. And the objects are all in source control and can be easily redeployed if necessary--the second level of protection. Restoring a backup of the master database is not pleasant in terms of downtime, it would be a third level. I’d prefer to let MS mark its own objects as system objects and leave mine alone. But maybe I’d feel differently if I were in Eli’s shoes.]]>GlennFri, 01 Jun 2007 12:58:09 GMThttp://www.windowsitpro.com/article/tsql3/protect-your-t-sql-objects-from-deletion#commentsAnchorProcedure Helps Pinpoint Problematic Processeshttp://www.windowsitpro.com/article/tsql3/procedure-helps-pinpoint-problematic-processes#commentsAnchorMon, 16 Apr 2007 15:10:08 GMT
Wouldn’t it be easier like this (at least in 2005) select Text from sys.sysprocesses Cross Apply sys.dm_exec_sql_text(sql_Handle) Roger]]>RogerMon, 16 Apr 2007 15:10:08 GMThttp://www.windowsitpro.com/article/tsql3/procedure-helps-pinpoint-problematic-processes#commentsAnchor