That's strange. There's no reason there should be a 2495 in that key. I haven't seen it. Have you tried it more than once?

Possibly. I'm short of developers now, but I'd like to have this set as a default somewhere. We argued about it and people seemed to prefer this as a cookie...

Q1: @@servername contains the name of the instance. Include that in your subject or message.

Q2: doesn't make sense. What do you mean by avoid indexes?

bcp isn't in the path on the server. The server service account (or xp_cmdshell proxy) is calling bcp, but can't find it.

Get the path on the server to bcp.exe and...

It would be helpful to get the output here, and provide a sample table.

create table mydata (month, year, data)

insert mydata select 07, 2015, 3)

...

That makes it easier for us...

jshahan (6/22/2015)

A quick little anecdote: Back in the early 2000s a group of us at work were standing around a PC that was browsing Novell’s website and we were arguing...

For your enjoyment

That's the limit for depth of calls in a stack.

bump

bump

Is this merge replication? I haven't spent a lot of time there, but is there a log you can check to see what's causing the jobs to fail? It sounds...

this makes no sense without years. Are you saying that you'd need Jul '14 through Dec '14 and then Jan '15 through Jun '15?

Or are you saying a rolling year...

What you could do is set up a baseline of how things perform now. Then implement a small replication system, maybe a single table/article that has enough activity to show...

Is this a default instance?

Are the agent jobs running?