Viewing 15 posts - 631 through 645 (of 966 total)
Not sure how much replication changed between 6.5 and 2000, but you may want to check this article out:
July 4, 2012 at 3:57 pm
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...
January 19, 2012 at 4:19 pm
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...
January 13, 2012 at 5:56 am
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...
January 13, 2012 at 5:47 am
Object ID 1442104178, index ID 2
Isn't index ID 2 indicate a non-clustered index? When was the last time indexes were rebuilt on the database?
January 13, 2012 at 5:33 am
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...
September 5, 2011 at 3:44 pm
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.
September 4, 2011 at 10:10 am
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...
September 4, 2011 at 1:15 am
A Practical Guide to Migrating SQL Server to mySQL
(registration required)
September 2, 2011 at 12:52 am
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...
September 1, 2011 at 8:23 pm
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...
September 1, 2011 at 8:19 pm
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...
September 1, 2011 at 8:15 pm
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...
August 31, 2011 at 9:01 am
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...
August 30, 2011 at 4:24 pm
Viewing 15 posts - 631 through 645 (of 966 total)