[ is an escape character. To use it, you'd do LIKE '[ [ ]'. BOL has a list of them. Strangely the left bracket requires special handling while the right...

We experimented some with tweaking Soundex, never really got what we wanted. Our situation was primarily with first names, we ended up building an alias list where Bob mapped to...

Don't think so. I'd recommend either 'dbo' for the owner or explicitly have the object owned by a sql login that would never change.

Andy

Sending email at the end of a task is probably the simplest and easiest way to do it. Another technique would be to insert a row into a table or...

One way would be something like this:

Declare @AA int

Declare @CA int

select @AA=Amount where code='AA'

select @CA=Amount where code='CA'

select @AA+@CA

Andy

I agree with Steve, it's pretty painless.

Andy

Generally no. One thing you have to look at is where the inserts get done. If you're using a sequential primary key then you may end up with some contention...

Can't say that the behavior makes sense. Then again, why would you try to replace a portion of a string with a null? I'd guess that since nulls propagate somehow...

When you send over the initial snapshot a bunch of these type procs get created - they apply the changes shipped from the publisher. If you bypassed the snapshot process...

I think db access is all you need. Use push rather than pull so most of the activity is on your side.

Andy

I'd recommend that your server be the publisher since you'll be doing the administration. Since there is a fair chance of down time you'll want to use either transactional with...

Functions should also save you time in code re-use.

Andy

I'd like to see a real test done on this issue. Im not a big fan of cursors, but they do have their place - usually more in an admin/maint...

I don't think TDS is very well documented, but maybe someone will have an idea. Are you sure it's network traffic and not the query and/or the SQL Server itself?...

Sounds interesting Bill. Being able to reprocess without a problem is a great design.

Andy