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

ok my issue was thinking owner=login=schema

this is what i had to do:

[font="Courier New"]

CREATE SCHEMA bob  AUTHORIZATION bob

CREATE SCHEMA jeff AUTHORIZATION jeff

CREATE TABLE bob.mytable(

TID INT IDENTITY(1,1),

mytext VARCHAR(30) )

CREATE TABLE jeff.mytable(

TID INT IDENTITY(1,1)...

in one of our accounting tables, we had a similar requirement where no update should be completed if someone updated the row prior toy you committing...

so if there was 20K...

isnt it true that for a linked server, you have to enumerate the columns you are inserting into?

i thought i tripped over that issue before;

INSERT INTO "Farmers Office Link"...report(col1,col2,col3)

SELECT *...

if the destination table has the eXACT same structure as the SELECt/DBCC, you do not need to mention the columns...since you added some extra fields, you have to explicitlu name...

the x is an alias; when you have a select in parenthesis, you need an alias in order to reference it;if you change the "x" to "mySubQuery" it makes more...

not sure with SSIS, as there's wizards to help you, but from a pure TSQL point of view,

with multiple sheets, you'll need to add the excel as a linked server.

once...

glag we could help; what was your project doing that you needed them in FK order? your answer might help someone else with the same issue.

you know, I've used the same technique to get the date with the time at midnight.... SELECT DATEADD(d, DATEDIFF(d,0,GETDATE()), 0) a million times. I guess i need the...

i hate it when i second guess myself.

the code i posted DOES replace EVERY instance in ALL rows in the text filed in a single pass.

here is code as an...

so couldn't you just repeat say, 5 or 6 times, assuming the most times the link showed up int he article was 6 times max? or releat until nor rows...

i have this in my snippets as Find and Replae for TXT/NTEXT;

see if this works for you:

[font="Courier New"]

-- the table needs to have an ID column. my example has reviewID

--example...