October 7, 2008 at 8:31 am
I need to install SQL Management object to run Powershell scripts to report on failed jobs.
Does anyone have any idea how I can install SMO?
Faye
October 7, 2008 at 8:53 am
It's part of the SQL Server 2005 install. I can't remember the exact part you need to install, but it is part of Client Tools and Utilities.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 7, 2008 at 9:00 am
SSMS (Management Studio) uses SMO (SQL Management Objects) directly, so the SMO libraries are installed anywhere that SSMS can run.
If you are doing development, you might need a separate SDK, but I think that the SMO stuff is bundled into the .net Framework SDK now.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 7, 2008 at 7:25 pm
Thanks for the reply.
suppose I don't install anything more than I already have on my SQL server which are SSMS, business Inteligence, and SSRS SSAS. Can I run a script like the following:
-- Create an object that points to the SQL Server
EXEC @hr = sp_OACreate 'SQLDMO.SQLServer', @object OUT
and expect it to work on. In other words do I need to install SMO engine in order for the above code to execute successfully?
Faye
October 7, 2008 at 8:45 pm
I cannot tell you about your specific script. However, if SSMS works, then SMO is already installed.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply