Thanks guys, I really appreciate it.

Also, sorry if you get a "side scroller".  I tend to write string concatinations on one line in my code. 

I'll try to watch out for...

This, like many other tools seems to be a great decision support tool.  However the "gotcha" in decision support is not in the tool used...

Thanks. I really enjoyed writing this article. I have a few good ideas on other articles I would like to write, so this may be the first in...

Good article Brian!

One thing I would like to add.  Backing up SQL Server databases using a perl script (or any other type of OS scripting language script) is a very...

Yes. Brian to the rescue.

Its actually quite simple.  I guess I was overcomplicating it in my mind (easy for me to do)

Basically the query above can be rewritten as the...

Correction. The patch does run some SQL Scripts. One of which is replmerg.sql.

So I guess I have a little more work to do.

Well, for simplicity sake, set the delivery point to Mailbox - XXX. Then open Outlook (or excange client) on the server and let it remap your folders and inbox....

Well, worst case scenario, all you will have to do is make database backups of all the databases, uninstall, install the other version, and restore the backups.

Yeah, I know its...

With that being said, be very careful who you give this role to, as these users are able to execute xp_cmdshell under the context of the SQL Server user and...

quote:

---

Thanks for pointing that out Brian. I'm so up to my neck in 7.0 servers I sometimes forget about the 2K release....

Yes, and just to addd to Rodrigo's post, you will always want to execute the DTS package and job at the server its going to run on as the NT...

Heh, well I guess whatever works...

Anyway if you ever get stuck with this again, also check out Books Online for SQL Server 6.5 unter the section titled "Expanding databases".

Also, on a second note, if you are not taking transaction log backups on that particular database, you probably will want to truncate the log on checkpoint, otherwise you'll have...

Right, thats why you need to increase the file size of the log device. Once you do that, you will have enough space to expand the log device into...

Try increasing the file size of the log device, then expand the database.

Gosh, SQL 6.5... Its been so long...