We have this issue almost every month or so on various server. It has turned out to be a DC issue in each case. Withe several hundred instances and numerous...

I'm having problem w/2005 procedure this is executing. Haven't tried your updated code yet!!

Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 73

An INSERT EXEC statement cannot be nested.

We have numerous instances of SQL 2000 & 2005 running under VM; works well if you understand the limitations(memory, cpu, overall performance). We generally are using it for our development...

Works great, thanks again!

I was a bit worried about seeing both folders but doesn't do any harm so all is well!!

-M

Thank you!!:)

Ini should now be attached!:w00t:

Hi Lynn,

I'm not sure what should be updated. Here is a copy of my ini file. With it like this both instances see the same packages!

Thanks - Mike

...

 We have about 1/2 dozen copies of 2005 running including 2 clustered environments. This includes QA&Production. Our "upgrade" path is normaly to just install a new 2005 server (SP2) and re-install the application...

Hi Steve,

I've been a DBA for about 15 years and in my opinion I'd like to do about a 50/50 split between home and the office. Yes the interaction between...

I never had certification and it hasn't hindered me from any DBA positions. Is it really that valuable to have?

Actually the only time I lost out on a job wasn't...

I've worked and lived my entire life in the Boston area. Never worked "in-town"; always on the 128 belt. Came close to moving to...

I remember back in the day when I worked as a Field Service Engineer we had to take apart some removable disk packs that had sensitive data and "bend"...

Just tried it - seems to work like a champ!

Thanks!!

Thanks!! I will check this out on Monday!

Thanks!!

Re: >>Nice idea, except that they can just grant themselves sa.

Supposed to be the honor system for the operations people not granting themslves SA!