i believe what you are seeing is the difference in the reserved space of the database....

you can create a new database right now, which is just a copy of the...

there's an XML Workshop article here [/url] on SSC that shows how to get the number of records in xml, and then loops thru the set, but it depends on...

I'm not sure what you want to do yet either;

what is in the xml? is it data ro sql commands or what?

what does your stored procedure do ?

Are you...

Christopher Stobbs (12/12/2008)

---

Looks like the TSQL column is too small you either need to do as Lynn said and disable the triggers or simply alter the table and extend the...

i believe COALESCE requires all parameters to be the same data type, right?

Coalesce(int,varchar) will fail.

this fails:

select(coalesce([Number],' Not Assigned')) from

(SELECT 1 AS [Number] UNION

SELECT 2 UNION

SELECT NULL...

I'm with Chris; I'm hitting refresh every 5 seconds to see what we find out next!

good learning day today!

the issue is the audit table's definition;

can you

sp_help ddlog

one of the columns is too small for the desitnation data, causing the trigger to error and rollback, which prevents...

ok to see the definition, this works fine:

select object_definition(object_id) ,*

from sys.triggers

where parent_class=0

i see the type ="TR" And Type_desc = SQL_TRIGGER

also, i added my audit just now to a clean database,a nd even though i KNOW the table exists, when i try to sp_helptext the trigger on the database, it...

Christopher Stobbs (12/12/2008)

---

HI Lowell

Are you saying that is has flicked a switch to turn on some built in DDL Logging?

Meaning anytime he creates stuff it writes to a table?

mmm very...

Good catch Christopher; i missed that when i read his error;

obviously he's got something in place for DDL auditing, and it's fixed size instead of varchar(max) for the data captured.

i...

yeah i would bet that .FBK is one DBA/ developers naming convention for Full Back Up,

so at a glance he knows which are full or incrementals.....

rename to .BAK if you...

i thought if you create a group, and add this command, then your developers, if they belong to that group, can view the definition of any of the objects int...

while sql server defaults to using brackets for delimiting object names, like

[Accounting Table].dbo.[Field Name],

other systems, like Oracle, use double quotes; i think that is an ANSI requirement...which is...

I'm pretty sure what you are seeing is an actual hardware limitation, i think; you start getting disk contention for the IO at a certain point, and yours is hitting...