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

i would highly recommend you have a permanent Tally table; As you read more here, you'll see how usefull it really is;

on SQL2000, you need a table that is at...

I'm including some code below;

there is a table called "tally" that is required; Using a tally/numbers table to do string manipulations has proven to be the fastest way to manipulate...

just guessing, but one of your columns that you are gathering dynamically might be named INDEX and causes a keyword error in the syntax check;

PRINT your SQL statement just before...

Your ERD program HAS to have the ability to define joins between the tables it queries against....I think the place to fix your issue is in the application itself, rather...

Here's some hints on your questions, as this looks a lot like homework:

first, if EMPID is the primary key for EACH of the 150 tables, are they identity() generated or...

i believe the error is here:

User].FirstName + " " + [User].LastName as FullName

double quotes are treated the same as brackets: [ ]

so it is looking for a column named [emptyspace],...