Selecting via code or a stored proc?

Andy

How about adding a locking hint to the select?

Andy

There is a trace flag for making it a little easier to read. I think 257. Been mentioned a couple times in the SQL Mag XML column.

Andy

Had some problems in v7 if you selected the repair errors setting, sometimes would get left in single user mode. Only complaint I have with it is the all or...

Different regions meaning different parts of a table?

Andy

Seems like a function would work for that?

Andy

From BOL:

Calling User-Defined Functions

When calling a scalar user-defined function, you must supply at least a two-part name:

SELECT *, MyUser.MyScalarFunction()

FROM MyTable

Table-valued functions can be called by using a one-part name:

SELECT *

FROM...

SQL2K is definitely worthwhile for replication. Doesnt have everything yet, but every lit bit helps. Easiest way is to just run the distribution agent, that will move any pending transactions...

Should work without a problem. BOL is decent, the replication wizard saves a ton of time compared to figuring it out manually! If you haven't worked with replication before I'd...

I hear you!

My only thought on this is that most companies tend to fall into the same trap, adding functionality over time. It makes sense to trickle out changes...

I use underscores some, usually in procs for usp_xxxx. Other than that I mostly use CamelCaseMoreOftenThanNot. Definitely skip the reserved words. And no spaces in object names! I believe in...

It should be a proc in your master db - perhaps deleted somehow?

Andy

Just a little bit. Doing any type of transform adds weight to the process and makes validation harder. Not that its a bad thing, just have to measure it!

Andy

Except that it is an insert and not an update trigger!

Andy

Might also try removing the NOT if you can. Though worth testing to see if it changes anything.

When you run these in QA, whats the response time look like? All...