Hmmm...I'm using NT4 and there is no such setting. There is a combo box for small/large but this doesnt affect the EM font. Either way it is still the same....

Right click copy/paste works from the Analysis Manager gui. You can also use the archive/restore add-in.

Holy crap batman! I just now noticed under the "Resources" menu item you do have a FAQ! My bad! And yours too, Steve

I believe it is your dot notation for your tablenames. SQL7 (erroneously I think) supports the single dot, whereas SQL2k does not, it requires a double dot syntax. I...

Nope, still have the same problem. I was able to tune the server and get the times down but basically it is still slower (for this particular query) than before...

What version and service packs are you on? There are a gob of mail related problems with SQL 2000. Best to get on SP2 straight away.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314309

Brian, I agree. For grins, here's the current standings of the previous service packs:

SQL 6.5

SP139

SP286

SP368

SP422

SP5a120

Post5a36

Total371

SQL 7.0

SP174

SP2199

SP3242

Total515

SQL 2000

SP1336

SP2116

Hotfixes 79

Total531

I'd say the trend is definately moving up. And these are only...

I believe this is an MDAC (MS Data Access Components) related problem. Check that you have the correct MDAC version installed for your version of SQL. There is a "component...

I presented this question to 2 SQL instructors recently and both asked me "Why would you want to?" Many times we run a stored proc or activeX script and want...

FYI, I've found "fixes" listed in SP2 that still do not work. In particular:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q308758

Judging by the list of bugs with SQL Mail, I'd say there are probably lots of...

Actually, I dont know how you guys do this and a full time job! You're efforts are amazing and much appreciated. I hope you get rich off it someday and...

Or in my case, a dumba$$ link....

Actually, even better would be to have a link like your "Active Threads" such as "My Posts" which would automatically pull up all your own posts, and filter by dates....

I spot checked our olap tasks and it appears that they are all selected to "run on main thread". But this wouldn't have anything to do with Enterprise Manager also...

Additional info:

I did some testing today, and find that the ETL job is doing something to cuase this error. We have a 3 step jobs which does and ETL...