Viewing 15 posts - 6,526 through 6,540 (of 13,469 total)
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...
October 18, 2011 at 9:58 am
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...
October 18, 2011 at 9:39 am
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...
October 18, 2011 at 9:22 am
kbleeker (10/18/2011)
October 18, 2011 at 9:13 am
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:
October 18, 2011 at 8:50 am
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...
October 18, 2011 at 8:27 am
shiv-356842 (10/18/2011)
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...
October 18, 2011 at 8:14 am
kbleeker (10/18/2011)
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...
October 18, 2011 at 7:43 am
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...
October 18, 2011 at 7:26 am
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.
October 18, 2011 at 7:08 am
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...
October 18, 2011 at 7:01 am
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...
October 18, 2011 at 6:34 am
there are a few script contributions here on SSC that folks have done, that will do what you are asking:
October 18, 2011 at 6:25 am
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...
October 17, 2011 at 6:25 pm
Viewing 15 posts - 6,526 through 6,540 (of 13,469 total)