the example i provided actually works; so you will have to provide the specific details of whatever you did.

a user does nto have any more rights...

you must use CAST...

you'll have to make a user for each Windows group or specific login, the rest is the same you would do in any other database: create a role with only...

good god that is like the 200th post where we proposed the same solution with only minor differences between our code example!

you usually beat me to the punch anyway!

inside the trigger, you can capture the first 4000 chars of the command text:

inside a trigger, you can do this, (DBCC INPUTUFFER can be used by users agasint their own...

love to figure this one out!

nice!

i split the data with DelimitedSply8K, then grouped it, and then used FORXML to reassemble a new string:

/*

AcctNumFuelTypes

0000000500444Biodiesel,Gas

00000026104Diesel,Gas,Other - Non Fuel

*/

With MyGroupedData

AS

(

--split it up and...

yeah, but there's another version that supports varchar(max), which is the datatype for sys.sql_modules.definition;

it's effectively the exact same code but varchar(max) instead of varchar(8000)

good for massive strings you need to...

check the same database in SSMS: is it set as offline? a lot of processes don't see offline databases, i know i've tripped over that a few times.

another way is to use dbo.Delimitedsplit on sys.sql_modules.defintion, so every word in the code is separate, then simply join it to the name in sys.procedures.

Sean Lange (4/12/2013)

---

Why not just search the website directories for the name of the stored proc? Unless you have done something to the connection string, or pass a value to...

your issue is this part:

SELECT @CAPTUREDSTRING = [DeletedItems]

FROM (

SELECT TOP 1 GETDATE()As TheDate,stuff(( SELECT ',' + Name

FROM INSERTED s2

--WHERE s2.WHATEVERID= s1.WHATEVERID --- must match GROUP BY below

WHERE 1 = 1

ORDER...

well you alreayd got the advice that this is a bad idea, but...

i installed both tools mentioned in this post the http://poorsql.com and http://www.dpriver.com, and between them both probably use them two dozen times a day.

there are subtle style differences...

No you can't with the...

now that i had a sip of coffee, it's even easier:

create the new table on the fly:

--script out the constraints and indexes from the original table

--create the new table instantly...