http://www.sqlmag.com/authors/author/author/5665447/rsscomment/5665447en-USFri, 25 May 2012 08:19:35 GMTFri, 25 May 2012 08:19:35 GMThttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorFri, 25 Mar 2011 14:17:53 GMT
Per your statement, "The SQL Server Agent service runs under a domain Windows account that has sufficient privileges on all the target SQL Server instances." Can you tell me what the minimum sufficient privileges are? Do they need to be SQL Server privileges only or also OS privileges? I don’t want to grant sa.
Thanks!]]>JonesFri, 25 Mar 2011 14:17:53 GMThttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorhttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorWed, 09 Jun 2010 13:58:39 GMT
I have this working for SQL 2008 and SQL 2005 servers & instances included in my XML parm file. Seems to be choking when soliciting info from SQL 2000 servers.. Anyone else have this issue?]]>TurnerWed, 09 Jun 2010 13:58:39 GMThttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorhttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorWed, 09 Jun 2010 09:25:44 GMT
This worked fine for me. Thanks for the solution!]]>TurnerWed, 09 Jun 2010 09:25:44 GMThttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorhttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorTue, 30 Mar 2010 19:16:59 GMT
... I don’t see the download for the .dtsx file]]>LaliberteTue, 30 Mar 2010 19:16:59 GMThttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorhttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorTue, 30 Mar 2010 10:54:14 GMT
would be nice if they fixed the downloads.. ]]>Rob RTue, 30 Mar 2010 10:54:14 GMThttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorhttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorTue, 30 Mar 2010 10:41:32 GMT
When is source download going to be posted? Thanks]]>OcasioTue, 30 Mar 2010 10:41:32 GMThttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorhttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorFri, 26 Mar 2010 18:37:34 GMT
The above comment was true from IE when I tried from Firefox it worked.
]]>kodaksmileFri, 26 Mar 2010 18:37:34 GMThttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorhttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorFri, 26 Mar 2010 18:35:50 GMT
Unfortunately the links to the XML source file and the .dtsx file are not working:

The XML page cannot be displayed

Invalid at the top level of the document. Error processing resource ’http://www.sqlmag.com/Content/UserStorage/3545453/1036...

Web Listing 1: SQLInventory.xsd

and the following for the .dtsx link:

Invalid at the top level of the document. Error processing resource ’http://www.sqlmag.com/Content/UserStorage/3545453/1036...

Web Listing 2: The .dtsx Definition of the SSIS Package
^

]]>kodaksmileFri, 26 Mar 2010 18:35:50 GMThttp://www.sqlmag.com/article/reporting2/building-a-sql-server-inventory-report#commentsAnchorhttp://www.sqlmag.com/article/log-files/automate-sql-server-error-log-checking#commentsAnchorFri, 20 Mar 2009 14:13:22 GMT
Great article and awesome tool. One problem that I found. The SQLErrorLogReportClient SPR was not always finding the valid entries in the errorlog file for my production servers. I found that sp_enumerrorlogs returns the actual last modifiy date for the errorlog files. If your system is doing any buffering, then this file does not always reflect the last time the errorlog was written to. To correct this problem I added an additional condition to the SQLErrorLogList delete: DELETE FROM xxxxx.xxx.SQLErrorLogList WHERE [Date] < @LastRunTime AND ArchiveNo <> 0 This will ensure that I always have an errorlog to scan. If you know of a way to make sure that the errorlog entries are flushed prior to this operation, please forward your ideas. thank you for sharing this tool.]]>EricFri, 20 Mar 2009 14:13:22 GMThttp://www.sqlmag.com/article/log-files/automate-sql-server-error-log-checking#commentsAnchorhttp://www.sqlmag.com/article/log-files/automate-sql-server-error-log-checking#commentsAnchorThu, 02 Oct 2008 14:35:09 GMT
Good article. I’ve been looking for similar functionality for reviewing the Reporting Services trace logs automatically, but haven’t come across anything yet.]]>TimothyThu, 02 Oct 2008 14:35:09 GMThttp://www.sqlmag.com/article/log-files/automate-sql-server-error-log-checking#commentsAnchorhttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorFri, 09 Jun 2006 12:07:45 GMT
I downloaded this some time ago & found it to be a very useful tool. I created a file with various statments using sp_who1 as suggested. This has become an important part of my toolbox of utilities. Thanks!]]>HOWARDFri, 09 Jun 2006 12:07:45 GMThttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorhttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorFri, 01 Apr 2005 09:28:37 GMT
sp_who1 @loginame = [domain\username] won’t work if the user is accessing via an NT group. Comment out the below and all is OK: if (@loginame is not null) begin if not exists (select 1 from master.dbo.syslogins with (nolock) where name = @loginame) begin raiserror(15007, -1, -1, @loginame) return (1) end end]]>TimFri, 01 Apr 2005 09:28:37 GMThttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorhttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorWed, 02 Mar 2005 19:52:54 GMT
Very Nice! If you like sp_who1, you should try sp_who_3: http://www.sqlservercentral.com/scripts/contributions/1232.asp It got like a perfect 5 stars and seems to be more efficient, more powerful, and has even more filtering and even include ad-hoc sorting. Check it out and post back comments. This type of procedure has been desperately needed. I think Microsoft should release something like this in a service pack or in SQL 2005. There are plenty of sp_who_x out there on the web for free download. Microsoft should just pick the best one and include it. ]]>CraigWed, 02 Mar 2005 19:52:54 GMThttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorhttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorTue, 01 Mar 2005 09:08:10 GMT
Excellent article. Thanks for your brains and hard work.]]>PATRICKTue, 01 Mar 2005 09:08:10 GMThttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorhttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorMon, 28 Feb 2005 16:05:52 GMT
Very useful. FYI: The web code download wraps two long comment lines leading to parse errors but these are easily solved by re-joining the long lines. Richard: I thank you very much for creating/sharing this code. Very useful!]]>flexdba Mon, 28 Feb 2005 16:05:52 GMThttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorhttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorMon, 28 Feb 2005 10:41:23 GMT
Hmm. The example above is far worse than reality - ignore the example, the web formatting’s has made it even worse.]]>pyaleMon, 28 Feb 2005 10:41:23 GMThttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorhttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorMon, 28 Feb 2005 10:40:08 GMT
Example of the above: SPID,status,loginame,dbname,command,hostname,memusg,phys_io,login_time,last_batch,SPID,program,cpu,opentran,blkBy,waittime,lastwaittype,waitresource,SPID 56,sleeping ,REACH\philip.yale,master,DELETE ,REA0491L-IBM,8,4,02/28/2005 17:14:42,02/28/2005 17:14:42,56,SQL Query Analyzer ,30,2,55,938159,LCK_M_U,KEY: 9:405576483:1 (ed0175ce1a7b),56 57,sleeping ,REACH\philip.yale,master,SELECT ,REA0491L-IBM,5,0,02/28/2005 17:14:42,02/28/2005 17:14:42,57,SQL Query Analyzer ,631,0,55,910820,LCK_M_S,KEY: 9:405576483:2 (c000178c23b1),57 55,sleeping ,REACH\philip.yale,master,UPDATE ,REA0491L-IBM,14,16,02/28/2005 17:14:41,02/28/2005 17:19:40,55,SQL Query Analyzer ,831,2,53,960241,LCK_M_U,KEY: 9:1977058079:1 (100198c3f985),55]]>pyaleMon, 28 Feb 2005 10:40:08 GMThttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorhttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorMon, 28 Feb 2005 10:25:14 GMT
Very good overall. The only disappointment was that, when I run it at least, I don’t get formatted output in TEXT mode like your example shows - mine’s all strung together so that the columns don’t line up with the headers. I can run it in GRID mode, but then I lose the output messages (like "Head(s) of blocking chain is(are):" )]]>pyaleMon, 28 Feb 2005 10:25:14 GMThttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorhttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchorThu, 24 Feb 2005 11:56:24 GMT
Good article. Will definitely use this proc]]>SRINIVASThu, 24 Feb 2005 11:56:24 GMThttp://www.sqlmag.com/article/permissions/meet-sp_who1#commentsAnchor