Negative. The only group I'm part of on this instance...

stewartc-708166 (4/23/2010)

---

Check the following:

- there is not a login for your user id, with default to that database

- the domain group you belong to might also be a member of...

You'll need to change the 'X''s appropriately with your information, but this should work for you:

IF (SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb') = 0

BEGIN

ALTER DATABASE msdb

SET ENABLE_BROKER

WITH...

Actually, disregard, found a post on how to fix this.

Simply added the service account to the MSDAINITIALIZE security properties: http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/a525b569-77ca-41da-96e1-2ba1938dd32d

The slip stream install worked this time around for me as well. Wish I would have tried the above ideas, but I already had the server rebuilt.

That I did not. I'm just going to wipe and reload.

andrew, I read the same ... so I did make an SP1 slipstream install. Still doesn't help me get out of this situation though. Being that the install failed to...

Ok, using what I learned off that report … I did my own thing.

Basically, I made a parameter called “Toggle” with two available values – Collapse / Expand. I then...

Jeff,

I actually ended up resolving the performance problems by taking the joins to the tables which did the aggregates and put them into a sub query and it now runs...

This is very very old ... if you're interested in seenig my latest versions along with MANY other helper views/procs/functions/etc. check out http://www.SQLSlayer.com. We should have our first...

Great ... well, good to know that it's hopefully being looked at.

Thanks in advance

Simply wrap another EXEC around the existing EXEC. Just make sure you have all your single quotes setup properly.

Well, I found resolution ...

Somehow, I have no idea why/how, but from scripting these jobs out via SSMS from a 2000 server, I obtained an extra hidden ascii character in...

Thanks again Nice, most appreciated.

I am downloading the ODAC now and will give it a shot.

Thanks Gift, you've been most helpful.

I did test it out on Windows 2008 and it appears to work ok. In regards to moving to SSIS though, I would still need...