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

replace "slash r" and "slash n" with the command that the forum obviously hates.

--the TSQL equivilent would be this command: note this assumes the table already exists,

and the number...

try this:

look in the registry in this path:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\DataProject

for this value:

SSVDefaultColumnType

change it from "nchar" to "varchar" or something, and see if that works for you.

for SSVDefaultColumnType

change it from 10...

Adding on to what Jack said, your sample data will help us visualize your FK structure...for example, maybe it sounds like OrderNumber is unique at the highest level, right? so...

i have a similar GEO database;

i have separate tables for countrytable ,province/region/state table , and city table.

my address table points only to the citytblkey; i don't bother keeping the statetablekey...