ok, inside a DML trigger, here's what is happening in SQL server:

the values someone changed, are already in the table WHATEVER. if you query the table inside the trigger, the...

you shouldnt' assume the commands start with your expected keyword..comments, whitespace, lots of other things can prevent you from determining it was insert/update.delete.

i would do it like this, using the...

obligatory compatibility nazi post:

sysindexes should be replaced with sys.indexes, as it's going to be dropped in some future version.

@Erin my knee jerk reaction was to check if there was something in the extended events to do what you are asking, but i'm just not seeing anything;

to me it...

they are recovered , sequentially, master database first.; but each database seems to get it's own spid to startup, and some spids finish before others spids created after it.

if one...

also you can simply create a DML trace on the database and capture all that information as part of a couple of events i think;SQL:BatchCompleted and RPC:Completed is what...

Erin Ramsay (8/13/2012)

---

Hey Lowell,

Is there a way to set that DBCC inputbuffer code on the database level so that when ANY trigger fires you can get the schema name, table...

LOL John it's feedback like that, knowing I helped someone, that really makes my day!

inside a DML trigger, it's a differnet technique, but you bet I have examples of that...

it could, yes; the requirements are still a bit vague;

if this is just "how to create a function( not a stored procedure),...

well the error implies you used a four part naming convention to reference a table/stored proc/view.

something like

SELECT * FROM SGEXP01.DatabaseName.dbo.TableName.

if SGEXP01 is a database name, then you have a...

Well lets think it through Josh;

an end user is using some sort of search function, is that the idea?

do you need to search all the columns in your table, or...

just like html, a tag is just a descriptor that describes or names it's contents.

only in a specific context might it...

if you were actually building xml strings, the value inside would be a tagname for the XML.

SELECT

name

FROM sys.columns sc

FOR XML PATH('ParentTag')

One of the neat things...

if you are seeing it in the data values , it could be some process is sending a value for the column with the default; values inserted take precendence over...

i couldn't duplicate the behavior yet; the tables i scripted out get teh default value with all zeros, whether in the constraint definition, the scripting of the table or in...