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

doh! thanks Seth;

I should have seen that, but wanted to let the OP know that he didn't need any fancy regular expressions, because it is supported to a degree in...

rereading, you might want to look at psexec.exe from sysinternals (now from MS):

http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx;

it is an administrative tool that can be used to run executables on other machines, regardless of...

it's kind of difficult, becuase the remote server would need to be able to login to the network in order to get to a UNC path to the batch file...

declare...

also, if you have a table with all allowable postal codes, you could simply join against it where the postalcodes not found, right:

--all invalid postalcodes

select * from yourtable

left outer join...

these are the once which are both alpha and have numbers: you can decide whether to delete or manually edit from this subset, i guess

select postalcode

from yourtable

--alphanumeric ANDALSO numeric

where postalcode...