wow..i'm leaning towards the opposite of Paul above. I vote for validation in both tiers.

I think check constraints and defaults, FkKs have a minimal impact at the database level, and...

blawrence (9/30/2009)

---

Hi Lowell,

All is perfection!

Thank you again and again, you have been an amazing help through this endeavor. You have been crystal clear in your explanations. Thank you again for...

I had also tripped over the same issue and if the following assumptions are true, this script might help:

the first column of the table is a sinlge column PK, identity...

as you get more familar with SQL, you'ss see that any column can bbe replaced with a hardcoded value, and vice vers in just about any SQL:

this is the enhanced...

instead of using the column name [fphone], simply change it to the static value of '1':

MyLinkedServer.PhoneNumber2 = '1'

your code seems to be doing stuff differently....are you updating the Linkedserver...

AFAIK, you trace flag(s) will remain in place until you stop the service...when you stop and restart, only the flags that are part of the command line for starting the...

this one is specific to the data:

ISNULL(MyLinkedServer.Initial,'A') AS fmi,

your original data source has what i though is the middle initial of the name, right? (if that's wrong, let...

easy enough.

Stripping preceeding zeros, you just convert to int.

for the rest, here's an example:

--results:

exString ...

[ code] --a sql comment [ /code ] <-- with no spaces makes your code become syntax highlighted

--a sql comment

if you are using preceeding zeros, when you...

a huge help, thanks for the layout!

try this query..it has all the defaults you were looking for. if the query works, uncomment the INSERT portion and confirm that that peice...

Greg Charles (9/28/2009)

---

You could also query the log file written by the default trace, a background trace that runs in SQL 2005. See "Default Trace" in BOL or search...

bad form!

do not post the same question multiple times!

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts"...

you cross posted across a few forums...the first being a SQL 2000 forum.

The MERGE keyword is for SQL 2008 only, but all the same process can be duplicated with INSERT...

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

Linked...

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

Linked...