rbarryyoung (10/14/2008)

---

jsheldon (10/14/2008)If I add Grant Execute to DBSBATCH and rerun the procedure again under DBSBATCH I get this

Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1

The xp_cmdshell proxy...

ALZDBA (10/14/2008)

---

I doubt if this is something one should doing "in transaction scope" like within a sproc.

I would convert the sproc into a single sqlagent job, containing of multiple steps.

If...

Read this from BOL and this should explain the theory behind the selection. I do agree it would be nice to have in plain english 'if your database is...

Thanks all for the help

Let me ask a follow-up...

This is our default configuration

C drive - SQL Binaries, System databases

D drive (SAN) - Data

E drive (SAN) - Log

D and E are just partitioned as they...

I am not having performance problems at all. I am just trying see if this is something to be proactive in.

The data files are in the same place as...

i got the done message..it ran as per the blog....

No Windows Internal Database service on this server. the WMI service is automatic and started

Hi Lynn,

Nope we only have one instance of SQL on this server. This is our ERP server and is dedicated only to our ERP software and SQL database installation

I did run the script for the sqlmgmproviderxpsp2up.mof and it ran but I still have the error...

Thanks for the help if you have any other ideas send them my way..

Yes I have that but I do not have the sqlmgmprovider.mof file that is in the blog....

You would think in a perfect world but after doing the command I still have the error..unsure what this blog means by the 'on servers' comment

there is no sqlmgmprovider.mof on...

This is getting enjoyable....I am getting an error on that as well...see attached

Hi David,

This is a default instance NOT on a cluster Standard Edition with SP2 applied

thanks

Jeff

I have the Server Dashboard under Reports on manager studio but not the performance I think I have to download this from MS website...am I correct?

do you have the link?

During the installation it not only asks you for the path of the binaries of the program but where you want to reside your data and log files. Did...