Using SSMS2008 to view Job Activity Monitor on SQL2005 - cw
in [Server Configuration]
|
Prev: Trouble with Cascading Deletes
Next: Failed to pause full-text catalog for backup. Backup was aborted
From: Jubmar on 8 Oct 2009 11:36 I am having the same problem. Have you found a solution for this yet? cw wrote: Using SSMS2008 to view Job Activity Monitor on SQL2005 04-Jun-09 I'm trying to use the SQL2008 SSMS to view the job activities on several SQL2005 servers and get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Unable to execute requested command. ------------------------------ jobs (SqlManagerUI) Is there a setting I missed? When I installed the SQL2008 on my machine, I used the following work around to get my registered SQL2005 servers in the 2008 SSMS: http://blogs.msdn.com/buckwoody/archive/2008/08/18/importing-sql-server-2005-registered-servers-to-sql-server-2008.aspx I'd really like to use the one console (2008 SSMS) for all the servers I manage - any help would be appreciated. EggHeadCafe - Software Developer Portal of Choice C00D11BB - resolve protocol error from Windows Media Player http://www.eggheadcafe.com/tutorials/aspnet/187cb72b-8da5-4dd9-b061-52e6d6304bee/c00d11bb--resolve-protoc.aspx
From: Aaron Bertrand on 8 Oct 2009 12:57
I don't have this problem, and view job activity daily on my 2005 servers. Did you install SP1 on your client machine to get the tools up to date? On 10/8/09 11:36 AM, in article 2009108113617jubdavis(a)verizon.net, "<Jubmar Davis>" <> wrote: > I am having the same problem. Have you found a solution for this yet? > > > > cw wrote: > > Using SSMS2008 to view Job Activity Monitor on SQL2005 > 04-Jun-09 > > I'm trying to use the SQL2008 SSMS to view the job activities on several > SQL2005 servers and get the following error: > > TITLE: Microsoft SQL Server Management Studio > ------------------------------ > Cannot show requested dialog. > ------------------------------ > ADDITIONAL INFORMATION: > Unable to execute requested command. > ------------------------------ > jobs (SqlManagerUI) > > Is there a setting I missed? > When I installed the SQL2008 on my machine, I used the following work around > to get my registered SQL2005 servers in the 2008 SSMS: > http://blogs.msdn.com/buckwoody/archive/2008/08/18/importing-sql-server-2005-r > egistered-servers-to-sql-server-2008.aspx > > I'd really like to use the one console (2008 SSMS) for all the servers I > manage - any help would be appreciated. > > EggHeadCafe - Software Developer Portal of Choice > C00D11BB - resolve protocol error from Windows Media Player > http://www.eggheadcafe.com/tutorials/aspnet/187cb72b-8da5-4dd9-b061-52e6d6304b > ee/c00d11bb--resolve-protoc.aspx |