you might get a benefit out of it, but it's one of those one half of one percent kind of things, and not a major performance enhancements.

remember what has to...

you choose New Login, and then use the find object to find a windows group....once you are in there, it becomes more clear:

nothing happens automatically, so something is changing the setting.

if you restore a database, the property for autoclose is stored inside it, so that's one possibility....restore it,and since the last setting...

• This reply was modified 6 years, 11 months ago by Lowell.
• This reply was modified 5 years, 8 months ago by Dave Convery.

no.

the case statement stops executing as soon as a match is...

the title of your post "In --> Group By with Multiple columns...> how it will responds " is not enough for us to go by;

can you explain...

this seems to work for me: if it gets interrupted, at least you have intermediate results from the successful looks of the cursor.

CREATE TABLE #RESULTS(SCHEMANAME VARCHAR(100), TBLNAME VARCHAR(100),COLNAME VARCHAR(100),SQL VARCHAR(max))

DECLARE...

sounds like you ran out of memory in SSMS on the client machine that called it; massive database i'm thinking; especially if you thought you needed to run it overnight.

Seans...

i had avoided that part for portability issues;

when i run scripts in my environment, we don't want to say what filegroup an object is on as far as the...

I'm one of those guys that think facebook /twitter /myspace/linked in/etc are either time wasters or non-professional, so i choose not to participate in any...

damn Nikus you've gotten two great improvements I've overlooked in as many days; my personal tunnel vision for the indexes was all scripted indexes were non clustered, so i never...

take a look at this thread, which has three different but basically the same way of finding a value across all tables and columns:

Need help with finding a string in...

depends on what you mean by "stored procedure fail logs"

do you mean when an error occurs in a stored procedure? doesn't exist unless you've created a server side trace capturing...

I've created a pretty decent server side trace script that does a good job of auditing login info;

it definitely captures failed logins, as well as all these events:

--Audit Add DB...

matt this worked 100% for me as an example; the difference here is I used the username parameters for the net use as a user that has permissions on the...

the command for mapping a drive is fairly straightforward:

NET USE G: \\UNCPath\d$\ShareFolder /user:domain\username password

after that is done, i think you might also need to add the trace flag 1807 to...