What UDP port does SQL Server listen on?...

RE: Global Replace

Unless you're an expert in Regex MW

RE: Log backups and Trun. Log on Chkpt.

No you won't lose data b/c only active portion of the transaction log is backed up by SQL Server MW Edited by - mworku on 06/12/2003 6:32:19 PM

RE: PINTABLE

tulcanla, I played around with it a bit and found a HUGE difference when adding a where to the query. Normal selects and counts made no differance. Did you use a condition in your select? If so, why is it so much faster for me? Cheers, Crispin

RE: Best Practices for Reboot Schedule

Why reboot SQL Server 2000 on a schedule? Well, I found a reason this week. Luckily I didn't get burned. I have a Win2K Advanced Server 2000 active/passive cluster, it's sole use is for SQL Server 2000 Enterprise Edition. NOTHING ELSE. My sysadmin and I were checking out the passive node and decided to reboot […]

RE: How to corrupt a db

Kill a long running transaction and while it's rolling back out pull the plug on the server. That's what one of my former clients did. (they didn't have a viable backup either) Big name outfit too. John Zacharkan

RE: Anyone ever get this error?

Be sure the sql server is running. Also are you using NT authentication or mixed? Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net

RE: Snapshot replication

Wich column data type in the subscriber and in the publisher?

RE: Snapshot replication

Snapshot repl: I just want to make a column data type change. How?

RE: HTML Email

Honestly part of the reason is also that this is a community. We hope that you visit the site more, not just read things through email. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net