clean dbcc checkdb?

My short list, which is probably incomplete as I've never done this. I've gone the other way.

Look in these areas, for dependencies. You should be able to query DMVs for...

Are these databases that were backed up from this instance? If so, then the msdb database has the names.

If not, this is better done from PoSh, though there are scripts...

Quick drive by, but what about using a CASE with the letter to check if there is something returned form the second query, return the letter. Otherwise, return a space?

K, just checking

sqlinterset (6/23/2015)

---

Actually ordering in ssms is being done through this way. But when i am pasting same query in excel pivot tables then this is giving data in normal order...

It did. Kevin Boyles and I broke it, but someone else broke one as well.

I'm...

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.