We're running into two problems here. One, nothing from Microsoft is going to imply that you can't share a server with other applications. I searched for a while...

sc.exe comes with the Win32® Software Development Kit (SDK)

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarpic/html/msdn_scmslite.asp

It's just a guess but perhaps a change was made to the user database between the time the master backup was created and the backup was restored.

If you look in...

Well, um YEAH!

After some reading on the multi-server deal it doesn't seem worth it. I was just curious whether the multi-server maintenance plans actually existed on the target server...

http://www.aspenterprisemanager.com Is one of many open source tools striving to meet this goal.

Well, Duh! There it is.

I'm 35, Married for eleven years (dated my wife for five years before that) and have an angel of a three year old daughter. ...

I'm constantly on the search for a better tool. (Probably why I've started thinking about just making my own.)

Mostly EM/QA.

For SQL Scripts I've started using UltraEdit32. It's a...

Before becomeing a fulltime DBA I was a...

*** Post College ***

Manager of an IT department for a software company with < 50 people.

Helpdesk/pc tech.

*** College Years ***

Cashier Supervisor/trainer at a...

Could it be that you have it set up so that the task the job step performs is kicking off the DTS package? If so as long as the...

I tried something similar to coondapoor's approach but it doesn't handle a string of all zeros. i.e. '000' yields '000'

Hence the case statement...

I just found that yesterday. It's also at http://www.aspenterprisemanager.com

It seems like a logical starting point but then too, I'd have to learn ASP.Net...

I suppose though, with Yukon right around...

Sorry, ugly spacing.

I've always thought SQL should have a simple function like this:

TRIMSTRING(<string to be searched>, <pattern to be removed>, <Remove from R or L>)

There's probably a much simpler way to do this...

create table RemLZ (LZ varchar(25))

insert into RemLZ values ('000234')

insert into RemLZ values ('000203040')

insert into RemLZ values ('000')

insert into RemLZ values ('234000')

insert...

Oh yeah, and we need a name. Preferably something that is short or has an acronym.

MAGI - Multiserver Admin Graphic user Interface

DAMIT - Database Admin Manager Interface Tool

It's up in the air really. I'm totally starting from scratch. My preference is something web based and ASP is sort of a minimal effort when it comes...