The cost saving in terms of hardware most probably is not significant enough to be measured in $$$. Total processing time is about 30min/day before and after.

Is there any other...

The easiest answer: use google (search string "DCOM was unable to communicate with the computer").

No, it's not your fault. Be assured, there are others following this thread just waiting for some sample data and expected results. Ready to use SQL code will explain much...

Wow. 45min and 120min... Sounds like an enormous complex query. Or one that calls desperately for a deep analysis. Can you post some rough figures about this monster?

You could get the relevant rows from sys.columns of db_B and db_A and compare those (e.g. using a full outer join on sys.columns.name).

Adding to what Roy already pointed out:

What exactly is the reason for allowing a dev team to access the prod system? What permissions would you like to remove? And why...

Did you try to google it?

Would you please be a little more specific what you're looking for?

SSAS is included in SQL Server Standard, Enterprise and Developer edition at no additional...

What exactly are you trying to tell us?

I've noticed a few of your "loop" posts recently but I can't figure out the intention behind it...

You could try to use FREETEXT search and see if it provides what you're looking for.

http://msdn.microsoft.com/en-us/library/ms187787%28v=SQL.90%29.aspx

duplicate post. no replies please.

original post: http://www.sqlservercentral.com/Forums/FindPost1169697.aspx

You could look into Service Broker and External Activation.

The external application would need to take care of processing the UDP messages (including a possible return message to the calling broker...

Wow!

I hope you can continue using this methodology (from unobfuscated access to the trial system to the concept how to involve the end users). It's the right way to go,...

Depending on the percentage of rows to delete it might be more effcient to copy the remaining rows into a new table and rename it. It depends...

As an alternative you...

The most important part is to know what you expect from an ERP in terms of functionality.

Then try to find the vendor that best fit your requirements with the least...

juan08 (9/2/2011)

---

Thank you for helping ALZDBA.

The guy that came yesterday freed some space and the server is up and running, but the msdb is still 42GB in size. He didn´t...