Hey everyone,

Thanks to those who poked around.  It looks like this was a clerical error on Microsoft's part.  SQL Server 2005 Standard x64 was simply left off of the July...

Thanks for the link!

We've heard from our CDW contact and our MS partner person that you can place an order, but they don't actually have it and can't sell it. ...

Oh, and this is either a bug, or by design.  Either way, it is a known issue.

Thanks ALZDBA!

This problem was noticed after the cluster flipped to the secondary node.  I was hoping not to have to flip it back until it was necessary, to avoid any...

Brewing a new batch of beer or poking around in the garden.

-Dan B

Hey Elliot,

After you create the database, you could run something similar from a query window in that database's context.

exec

sp_revokedbaccess 'Able'

go

Hello,

These both work fine for me in 2005 standard.  Looks like a handy proc.

Make sure you check "Enable OLE Automation" in SQL Server Surface Area Configuration for Features.

Also, make sure...

Wow... Good answer!

-Dan B

If the jobs were created by Enterprise Manager, the description field in sysjobs should show the DTS package name in the following format: "Execute package: <PackageName>"

select * from msdb.dbo.sysjobs

OR, you could...

Have you considered running profiler to capture an activity trace for 15 minutes or so to see if there is activity that corrolates with the slowdown?

-Dan B

Thanks for the reply!  Here is what I saw in a trace.  Seems to be the same for Mgmt Studio regardless of connecting to a 2000 or 2005 server.

Note the...

Thanks for the link.  A year and a half seems pretty short... but then I still have SQL 7 running!

Actually, not sure if that makes any sense as long as you are connecting to the virtual name...

Are you on the active node?

Thanks Linda.  That option is located under the Components to Install dialog - click the button marked "Advanced".  Expand Database Services, select Data Files and click Browse to change the installation path. ...