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?

Right,

Because in sql server 2000 the jobs are "attached" to a servername to allow multiple instances.

You can script out all jobs, or you can adjust originating_server in msdb.dbo.sysjobs

rewrite as

docmd.setwarnings false

docmd.openquery "xxx"

docmd.openquery "xxx"

docmd.setwarnings true

Welcome.

I'm having trouble seeing your pictures.

If the sql server is the default instance, the servername is likely to be your hostname.

What connectionstring are you using?

Is this using the Access upsizing...

Have a look at

*sql 2000

http://msdn2.microsoft.com/en-us/library/6ksc0a82.aspx

*sql 2005

http://msdn2.microsoft.com/en-us/library/s0fk6z6e.aspx