So, if one of the results is 123 and the other is 456, you want to end up with the number 123456?

Can you multiply the first one by the appropriate...

Is the bit removed always a zero, or will it sometimes be something else?

I've upgraded a few servers (maybe 10). The only problem I've run into was having to re-register the DTS dll in Windows, and I'm not even sure that was...

You're welcome.

Databases that are offline won't display any of the objects under them. That's normal.

Where MyZipColumn like '[0-9][0-9][0-9][0-9][0-9]%'

Will find anything that is five numbers, followed by anything or nothing.

Where MyZipColumn like '[0-9][0-9][0-9][0-9][0-9]'

or MyZipColumn like '[0-9][0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]'

or MyZipColumn like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'

Will find anything that's five numbers and...

Insert, update and delete triggers are placed on specific tables, not on a whole database or server. You have to add them to each table.

First, are the databases still attached to the server, but offline, or have you detached them? Detaching them should fix what you're running into.

Create another database and move some of the data to that.

Check the properties on the primary filegroup. It may be set to have a limit of some sort.

Is rownum a column in one of the tables? If so, what's the range on it?

You can't run a tran log backup at the same time as a full backup. Won't let you.

When you say the tran log isn't being truncated/shrunk, I'm assuming you...

Start by making sure the database is being accessed by logins other than sa. Then make sure the logins being used have the minimum rights necessary in order to...

The idea of a pre-publication spot for article preview is good. I've usually sent my rough drafts around to a few folks for the few articles I've written, and...

Steve Jones - Editor (3/6/2009)

---

Hey, we posted the same time. Thanks for the great complement. I appreciate that.

On the experts exchange, I've resisted that, but I think there might be...