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

do you have the ability to make the ERD use a specific view for the report, instead of underlying tables?

if that were true, you could cleanup some of the queries,...

i think because he's locked into using the ERP to generate the queries and cannot adjust them, we are a bit limited on suggestions....the executtion plan will help a lot,...

first you said row size, then you said table size...which is it?

there is a difference between the max space that a row can take, and the actual length of any...

you can't substitute a variable for an object name like that directly...you need to use dynamic sql to accomplish what you want:

declare @sql varchar(max)

SET @sql ='SELECT

c.CustomerID,

c.CompanyName,

c.City,

c.ContactName,

o.OrderID,

o.OrderDate,

od.UnitPrice,

od.Quantity,

od.UnitPrice * od.Quantity AS ExtendedPrice

FROM

Customers...

i think i had a similar issue, and it was related to a weak password for my user; i don't remember if it was my sa account or my admin...