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...

i love that line! thanks for...

ohpenot (2/20/2013)

---

IDTheOutput

1nt service\mssql$sqlexpress

2NULL

3NULL

Indeed! That's what i have. I had checked actually when i first red your post (in services, right-click on the instance name..). The point is that for the...

@@spid is the unique Id SQL server assigned to the connection, which in this case, would be executing your stored procedure.

if you run exec sp_who2 on your server, you'll...

here's one idea: modify the trigger to also use CONTEXT_INFO as the update criteria

ALTER TRIGGER [dbo].[tuReferral_UpdateAudit]

ON [dbo].[tReferral]

FOR UPDATE

AS

-- Select the context information

DECLARE @sess VARBINARY(128), @var NVARCHAR(64)

SET @sess = (SELECT context_info...

yes. both triggers will fire. two triggers same table, even if one is an instead of trigger.

That might be a logical error, having two insert triggers on the same...