Something like this?

SELECT Table1ID1.targetInformation AS  target1,Table1ID2.targetInformation AS target2

FROM Table2 LEFT JOIN Table1 Table1ID1 ON table2.ID1=Table1ID1.ID /*fill with NULL if not present in table1*/

LEFT JOIN Table1 Table1ID2 ON table2.ID2=Table1ID2.ID

ORDER BY Table2.ID

At the linked server properties

you can set how your account will be "transferred" across the network to the linked server.

Perhaps you can try with using the current login security context...

some in the role db_securityadmin can assign execute permission.

Welcome

the syntax is

EXECUTE mylinkedserver.myremotedatabase.myremoteobjectowner.USP_MYREMOTESTOREDPROCEDURE @param1=....

CREATE STORED PROCEDURE dbo.USP_CLASSTRACK_PIVOT_QUARTER

AS

SET NOCOUNT ON

SELECT classcode,

    SUM(CASE Quarter WHEN 'winter' THEN Amount ELSE 0 END) AS 'Count Winter',

    SUM(CASE Quarter WHEN 'spring' THEN Amount ELSE 0 END) AS 'Count...

where did you declare  rstStoredProc ?

you can test if rstStoredProc exist with

if not(rstStoredProc is nothing)

*move

' Spit out our data which I pull out of the recordset.

'Response.Write Trim(rstStoredProc("Supervisors"))

'Response.Write " "

'Response.Write...

for update you need to specify the update command also

see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatacommondataadapterclassupdatetopic.asp

for the microsoft help on dataadapter.update

Perhaps to save on the amount of I/O that has to be done to reclaim the unused space.

New records will be probably created using the new size.

what level of severity does the error have?

could be permissions, referential integrity

Are you using a stored proc for the delete command or dynamic sql?

(number of output parameters match?)

have a look at

http://www.davidpenton.com/testsite/scratch/disconnected.command.asp

basically

rs=adocmd.Execute

while not rs.eof '*retrieving all records*

 rs.movenext

wend

Hmm, the image doesn't show up.

Can you post your report sql + table definitions & some sample data?

*calling a stored procedure from asp

http://support.microsoft.com/kb/q164485/

*creating a stored procedure

CREATE PRODECURE dbo.USP_MY_PROCEDURE

(@Param1 as...

server: =mssql10.oneandone.co.uk

login id = dbo152591563

password= dbo152591563's password

Can you verify through the admintool that the user dbo152591563 can login?