Hmmm, Ok. It seems to be back now.

Sorry,

I was talking about PromptSQL

I've been trying to get to their site but it keeps coming up unavailable. Are any of you having that same issue??

If you're looking for a way to retrieve everything around your where clause that would be rather difficult since there's no way to know where it would end. You could...

As you can probably tell by the lack of responses, there is no mechanism at least that I'm aware of available for retrieving readable sql server passwords, probably a good...

Yeah, the attachments will always show up as files unless your email system has some way to have them show automatically.

Basically if you want something to show up in...

I have pulled an exerpt from the sp code. Add the lines in blue to your code in the stored procedure

***********************************************

create procedure usp_send_cdosysmail

@from varchar(500) ,

@to varchar(500) ,

@subject varchar(500),

@body varchar(4000)...

We don't have auto close set on any of our databases so not that

Yeah, the inserts are processed by the service serially. The timeout...

Rudy,

Could you elaborate on that? When an index splits, my understanding is that  it only creates 1 additonal page at a time and only moves some of the rows from...

Brenda,

I did a little research, because i typically don't have outputs greater than 8000 characters which does seem to be a limit for the body variable.

I can attach existing...

Brenda,

I use that sp to send html formatted email documents from SQL Server but I don't send them as attached files they come in as html based emails. If that's what...

Kory,

I just wanted to add some info about the other part of your response. The primary key field is an incremented id field and none of our indexes are concerned about...

Kory, we aren't getting any errors being thrown at least none that are being noticed or captured that I am aware of. 

The table is about 350,000 rows

Here's the ddl for the table...

Kory's method should give you what you need. In addition, you could use the diagramming functionality to provide some of this same information in a graphical format which could assist in...

Lowell,

Thanks for the feedback

We do have a couple of indexes on the table and indexes are being rebuilt on a weekly basis and I thought that they might somehow play...