You can extend the command timeout via a simple property if you're using either ADO or ADO.Net, but as noted it's not a good idea - unless! - its more...

You could also add triggers to the concerned tables. Note that modifying the insert proc or adding a subscriber side trigger are both brittle - could get dropped if you...

I think they have the potential to stop the madness, 10 different email columns all with different sizes. A couple three notes on your notes:

• I much prefer getutcdate over getdate,...

The sql statement run alone always executes fine? I had to look up INSENSITIVE, here's the BOL:

Defines a cursor that makes a temporary copy of the data to be used...

All you have to do is modify the replication delete proc on the subcriber for that table. Replication creates three procs, one each for insert, update, delete, on the subscriber....

I think it actually hurts them a little, as it spread out the attention paid to individual products. Be good for the SQL guys to have their day in the...

Software assurance is something I want to like. Ideally you fight that decision through the budgeting process once and from then on you can upgrade as you want to, not...

How about trying a simpler query, just to prove its ADO? Start with Select top 65000 from table (no where clause), bump up until you get it to break. Potentially...

Carl, I dont doubt you, but maybe worth running the query directly via SSMS or QA to verify that you get the right rowcount there. That would confirm that the...

I've got a small table with about 9k rows, and it has a column that has about 3k of nulls. When I select top 50 where column is a null,...

My two cents; think of a report model as superview that defines all the possible joins in advance, so users just pick fields and RS automatically builds the query with...

I like the idea of changing the loop so that you don't process two indexes against the same table. No guarantee that it will help, but I think its worth...

Are you getting the same query plan on both servers?

Dinesh, I no longer have the power! But I'll forward the link to Steve for you and he will make the correction, but he's headed to the UK this week...

It's not that Steve doesn't like his employer, it's just the worry over the initiation he'll have to go through. Brian & I suspect it involves some type of Red Gate...