Not sure how much replication changed between 6.5 and 2000, but you may want to check this article out:

INF: Handling Subscriber Schema Changes with Replication

Yeah, you don't want the /3G switch set unless you are on a machine with 3GB of memory and you want to reduce the OS to use just 1GB of...

The account with <domain>\<machine>$ is a computer account. You should be able to add that account as a user to the db if need be. Is it causing anything to...

This came up in a quick search on TechNet:

Understanding the error “An operation on a socket could not be performed because the system lacked sufficient buffer space or because a...

Isn't index ID 2 indicate a non-clustered index? When was the last time indexes were rebuilt on the database?

OK, I've used my Windows firewall to block ALL incoming SQL connections (That works). Then, I created another rule to allow certain IP Address. However, the Block rule is overriding...

You would setup your SQL instance to listen on a specified port and then configure your firewall to allow traffic only from specific IPs to connect using that port.

How to:...

I wouldn't use the default trace template then, as it gets much more information than it sounds you are looking for. I would start a new trace and deselect every...

A Practical Guide to Migrating SQL Server to mySQL

(registration required)

Search Engine Q&A #12: Should you create multiple files for a user DB on a multi-core box?

At what size db does it make sense to split into multiple files?

Unless there is a third-party tool available I doubt you will be able to create a mySQL database from a SQL Server backup. They are two different programs with different...

I did ours with one drive letter for data files and one drive letter for log files and then have the mount points for data/log files for each db under...

I would say go with the number of cores is showing up in the VM. I do not think it would do you any good to go by the number...

I am not sure varbinary(max) is an option. The poster needs to be able to input data larger than 2GB. Varbinary(max) has a limit of 2^31 - 1 bytes, which...

I agree that if you are on SQL 2008 R2 go with filestream. It is the only option that should allow you to insert more than 2GB of data in...