I think you'll be stuck with dynamic sql in this situation... unless you want to create one sp per linked server and then dynamic sql in each sp... I...

Maybe the webadmin is not using your login and that this login doesn't have access (I never used it so I'm just guesssing here).

Have you tried dynamic sql?

Is there a good reason why you don't want to hardcode the query?

You could pretty much use the same report.

You have 2 ways of doing this

1 - let access do the work (as it is best pratice)

just put a textbox and put...

Check this out : it lists the relation name along with the table names and columns of the pk and and fks

SELECT TOP 100 PERCENT ORelations.name...

Maybe you could load the data in a staging table. Then you could insert only the valid data in the production table. That would also give you a...

check out

SP_Rename 'OldTableName', 'NewTableName', 'OBJECT'

SP_Rename 'dbo.Table.ColName', 'NewName', 'COLUMN'

I already ran a test with this (don't have it anymore). Was checking to see if doing

IF EXISTS (Select 1 from long query)

would be faster than

IF EXISTS (Select...

There must be a faster way than this to generate the records.. but I don't have time to search for one. I would try to generate 1000 records in...

That's why I should start drinking coffee.. would give me an excuse for those kind of days...

why not use a bulk insert method... row by row is gonna take way more time than necessary... I often see inserts of 250 k lines that take 1-2 seconds......

Recursive algorithm or error in proc?

Check this out.. another user had the very same questions:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=161703

Run this code in query analyser and post any questions you might have in here.

if exists (Select * from dbo.SysObjects where name = 'SUPPLIERS' and XType = 'U')

begin

DROP TABLE SUPPLIERS

end

GO

CREATE...

I think the simplest way would be to use a trigger to make that update. You'd have to do it for inserts and deletes. Msg me if you need...