When we where evaluating MOM, the only gotcha we found was the price. Especially when you pay extra to add application level monitoring.

We implemented Servers Alive <http://www.woodstone.nu/salive>

Good all-round monitoring and alerting for all servers/apps. Easy to install and setup.

Price is good as well.

Well to be a fly in the ointment, personally, I disagree with Steve. Running the backups to a single backup device you run the risk of losing all your backups if...

There are three editions of SQLRS, standard, enterprise and developer. The evaluation edition is effectively a time-limited install of the developer edition. You must have the equivalent SQL Server license...

Think about it like this. Your SQL Server license allows you to run SQL Server Database Engine, Analysis Services and Reporting Services.

You'll need to purchase an additional license when you...

For info on how to pass info back to the calling package, take a look at this article on techniques used in SQL Server BI Accelerator. Pay special attention to...

While it is available worldwide, the demand for CD's has outstripped production. We finally got our CD's yesterday after putting in the request the day after release.

The article is a...

I keep parameters like these in a table within my locked down DBA only database. Then in executing the package I pass in necessary global variables (server name, user id,...

In my experience it is best to avoid the "on completion" constraint. It is much better and safer to setup your tasks to avoid failures (as illustrated by rmarda) and...

For what it's worth I've noticed that you can't type in the box until the page has finished loading all the icons and stuff.

Jonathan, interesting use of PARSENAME, I'll have to remember that one. would I be correct in saying that it doesn't work if you have 6 or more data elements to...

For interested parties, if anyone has a nicer solution feel free to squawk.

SELECT 
 Account 
 , Address
 , REPLACE(LEFT([Address], CHARINDEX(';', [Address])
   ), ';', '') as Address1
 , REPLACE(SUBSTRING([Address]
   , CHARINDEX(';', [Address])
   , CHARINDEX(';', [Address],...

mccork, thanks. Now maybe I'll get something to work.

5409045121009, I'll need to do this for 300k+ records so T-SQL is definately a preference...

DTS doesn't have any concept of "global" code. Looking at the function you've provided, why wouldn't you just use the built-in replace function and do away with the extra function...

If you're using the TransferObjects task then you can check the log file created by that task. It's usually in "C:\Program Files\Microsoft SQL Server\80\Tools".

In this directory, you'll find a...