I've recently been spending a lot of time studying and scripting repsonses to Brent Ozars SQL Blitz! script.

It identifies a great set of things to look for, and has been...

Edit: reread your request: realized you wanted an entire instance, and not a single database.

my advice then is a cursor which runs the alter database command for each database.

EXEC sp_msforeachdb...

just confirming: looks like the disable of a trigger does not count as a DDL event, so it is not tracked int eh default trace; i created both a...

i think you need to just change the order by then;

order by case when isnumeric([first char], then the rest of what i suggested.

besides what I posted, what have you...

which article of Jeffs are you referring to?

how about using the PARSENAME function to chop up the IP address?

--using Stefan's setup:

/*--Results

(No column name)(No column name)

1172.24

322.25

3223.25

*/

SELECT Count(IPAddress),parsename(IPAddress,4) + '.' + parsename(IPAddress,3)

FROM #tempIPTable

Group By parsename(IPAddress,4) + '.' + parsename(IPAddress,3)

there may be a more efficient stripNonNumeric function, but this works:

select *

from Numbers

order by CONVERT(float, dbo.StripNonNumeric(code)),

code

/*--results

1

1a

7a

9ce

12

45

78

x78

100

a458

*/

and the function i used:

CREATE FUNCTION StripNonNumeric(@OriginalText VARCHAR(8000))

RETURNS VARCHAR(8000)

BEGIN

DECLARE...

Brandi I'd hope it would be easy to get a free application on the approved list easily;

I've got to recommend 7zip's command line version, i use it a lot.

here's a...

Jim you could use something like this example, whether you need a string or a full command;

it's just converting to varbinary and pasting the string into the final script;

--obfuscate a...

no. not possible.

if it's not raw text, it...

not enough information kurt; remember we are not in your cube, looking over your shoulder, knowing what you know.

a purchase order is a form with a specific layout. it's...

kurt your going to have to provide a lot more information, i think you need to "think outside of the box" on this one.

you can create a pdf from raw...

man i learn more hear every day; thanks once again to you Gianluca;

yes, your trigger could look for a WHERE statement...you could also limit the trigger to test for specific...

I like that idea, Gianluca;

the only problem with dbcc inputbuffer is it is limited to 256 characters....I'd think offhand that a delete is going to be inside that limit to...

well, this will get you the hours where at least one answer exists i think;

if you need to know that zero answers were answered at 3am, that's why you'd need...