THe SQL Server Service Manager which runs in the system tray or in the services applet. Most likely it is running under local system which has no network rights...

I don't think xp_cmdshell runs under your user rights, I think it runs under the rights of the SQL Server service. So, referencing a location using drive letter will...

I'll take any ideas you aren't motivated enough to use!

A couple of things:

1. Autoupdate stats should probably be on, especially since you do not mentioning manually updating stats. If you have a highly transactional system then out...

For all those who have posted that they don't write due to fear of being wrong. The one article I have written did not have anything "wrong", but after...

I have to be honest, I don't really like to write. I have submitted and had 1 article published here on SSC and have a blog, but I really...

All right. Does it matter which one of the records with duplicate ModifiedUTC, you keep? Here's an idea:

[font="Courier New"];WITH cteDuplicateValidRecords AS -- get all the records with more...

You could use top 1 or you could try something like this:

[font="Courier New"]SELECT DISTINCT  

     RT.IndexId,

     ISNULL(dbo.ufn_GetBestIdentifier(RT.IndexId),

     dbo.ufn_GetBestVirtualIdentifier(RT.IndexId)),

     dbo.ufn_GetEntitySystemName(RT.IndexId),

     RT.Status,

     CONVERT(VARCHAR, RT.DateCreated, 106) AS DateCreated,

     RT.CreatedBy,      

     RT.DataTag,

     MH.MergedDate

FROM  

   @resulttable AS...

You need to change the function in the data row of the matrix to AVG() from SUM() if you want the subtotals/totals to be Avg()

I basically agree with Grant. Select -> From->Where->Order By are real easy to understand and comprehend. The key is that good database design requires that you understand joins...

Check the owner of the job.

I don't think you can set it up so they can just see the security section, but you can put them in the fixed server role of securityadmin id you...

As far as I am concerned there is no reason for anyone to be a member of the db_owner role in a production database. The DBA should create roles...

Your where clause looks fine to me now, except that if p21_invoice_amt_remaining_view.amt_remaining_frominv is numeric you do not need the quotes .

When you say it did not like it, did you...

Because your query is within a string you need to use 2 single-quotes in order to have one show in your string. So you need something like this:

@query =...