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

try this one; i once had some databases that had circular foreignkeys..i had to find a way to really put them in order.

see if this works for you:

SET NOCOUNT ON...

if you have their hostname, and it's on an internal network, you can ping or nslookup the hostname to get the IP address; if it's from the web, you might...

remember connecting TO the SQl server is handled by the operating system...outside of the SQl process...

you can connect via named pipes or TCP/IP.

with some of the info available, you can...

if it has been working without fail for a long time, and suddenly doesn't work, I'd check the basics:

is there basic network connectivity to the DF2\dev server? can you ping...