That's a data issue. something is calculating a parameter for substring (liekly) and passing in something like a 0 for a parameter that doesn't accept it.

Are you looking for instance of SQL Server Express or databases?

This is easily answered in Books Online. There is a section for this. This also sounds like a test question....

If you have to ask....

I haven't tried mixing, but I would assume it wouldn't matter. Each publication and subscription should be separate.

There are 3 servers involved. Some actual instance might perform 2 roles, but...

We used local settings, which still caused issues. Users would travel, forget to move settings, and call us.

However if someone moved and used another machine locally, they got the correct...

Nice one, Bob.

We had a similar setup to AJs when I was at JD Edwards. Production instances, almost all 1 instance / physical server, were in the 200-300 range. Two DBAs.

We also...

I think what we're looking for is what would you like? I'm not sure PASS has benefits for you now, but if they could offer something, what would be helpful?

I'd...

Ditto, Bob, looking forward to it.

You can delete the file, and then run a full backup to test, but it should work.

There are plenty of people that create a new file name every day and...

did you create the second publication?

From there, are you looking for a push or pull subscription? I would think that you'd need to use SSMS since you have a 2005...

You might not have the right SQL Servers on your ESX system, or it might not be sized. I know of 4 companies in the Denver area that run it...

It appears that you are making multiple backups to the same file. While you can do this, and you can store multiple backups in one file, if something happens, you...

You can, you need a different name.

You can have multiple subscribers for a single publication, and you can have multiple publications, each with the same subscriber.

That job thing is really getting in the way of this social stuff.

Sorry to hear that, Jeff. Hopefully at some point we'll hoist one together