statistics can be identified like this, i believe:

select

OBJECT_NAME(id),*

from sysindexes

where first is null --NULL for statsitics

and indid >0 --avoid HEAP indexes

they typically have a name that starts with...

ahh, i had seen that once before...i'll fix that right now.

I can't thank you enough; another pair of eyes, doing work outside of my typical work load and comfort zone...

an example might be a logon trigger that is supposed to write to an audit table...suppose it said INSERT INTO MyAuditTable

SELECT ....

what's the database context? depending on the user, it...

kbleeker (10/18/2011)

---

Hi Lowell - I made a change which appears to have sorted out the comma, but I'd like to know whether removing the space padding might have som drawback...

by the topic, it sounds like he wants to script out the database mails ettings, not how to send database mail.

my old post here has an awesome script for that:

Script...

I tweaked both procs to quotename the index column names, and also to replace unix style code to end with vbCrLf;

same links as below, cna you retry by downloading the...

shiv-356842 (10/18/2011)

---

Hi Team,

I m Executing the above script

in MASTER DB

but i m getting below Error can you please suggest me.

Msg 2812, Level 16, State 62, Line 1

Could not find...

kbleeker (10/18/2011)

---

Hey again.

I saw in the SP that you insert the data into @Results, so I caught the contents of that - check out the index_name and index_columns_key columns(only 2...

Doesn't the login takes place BEFORE any session is created, and thus before any rows could exist in sys.dm_exec_sessions?

I think you need something testing ORIGINAL_LOGIN() and

APP_NAME() is...

nice Mark! ,because my Tally Table starts at 1 and not Zero, for me it's missing the group that starts with 'A', but it was trivial to change that.

wierd, gotta be an issue i have not seen;

when i scripted your table and index, i get good, clean results.

can you try the latest sp_GetDDLa to be sure, this is...

What i tend to do a lot is to create a view that will allow me to access the trace you created;

then i can simply do something as simple as...

there are a few script contributions here on SSC that folks have done, that will do what you are asking:

http://www.sqlservercentral.com/search/?q=script+jobs&t=s

CREATE INDEX [ CODE ] ...

you'll have to group by the incremental that you want to track.

here's a rough example, where i'm just guessing at your table structure, but assuming all times have millisecodns in...