That's what I thought but just to be sure ...

Perhaps a parameter when performing backup ? no?

Did you tried to put the 'INIT' parameter in your backup script ?

(Hope you use a script 'cause I do not trust the Entreprise Manager's wizards)

Fine, the MSDB of couse.

Thanks a lot

OK I'm back.

The problem is that for security reasons both SQL services 5server and agent) are running on different accounts. Perhaps that' the point. The Agent is running on a...

Did you tried an OPENROWSET like this one

SET ANSI_NULLS ON

GO

CREATE PROCEDURE usp_Test

AS

SELECT a.*

FROM OPENROWSET('SQLOLEDB','Server';'user';'Password',

'SELECT * FROM Database.dbo.') AS a

GO

The openrowset have better performances than linked servers.

...

The sql account is a DOMAIN user specially created to run the SQL Server service under Windows2000. The version of SQL is 7 sp4.

The SQL Agent runs under a local...

Wow, it does the job!

Thanks.

There is a 'cheap and dirty' walkaround ...

Enclose the package into a job, create a table TOTO with a trigger that fires on insert and that executes the job.

In your...

We also use an Oracle Database synchronized with a SQL2000 Server.

The first thing to know is that ther is a wellknown bug in that context.

The linked Server works but so...

You can use a UNION between several SELECT

ex

SELECT a, b, c, d

from table1

where e='Y' (the validation flag)

UNION

SELECT asd a, grt b, ohsd c, ewh d

from table2

...

I also had the problem. You need to register your entreprise manager with another login (not SA better a login that is used only to run the packages).

When this is...

Did you try the openrowset command for SELECT. I had the same perfomance problems with an Oracle linked server.

LINKED SERVER:

Select * from Oraclesvr..SPAR3.USERS

OPENROWSET:

SELECT MAT_USR, NOM_USR, PRENOM_USR, SIGNET_USR, CC_DEFLT_USR, STATUS_USR

FROM...

There is a trick to do the job but ...

You create a table (ex.: working table) with a datetime field.

You create a trigger that insert the getdate() value into that...

Using Enterprise Manager to design your package, you can create a dynamic properties task.

In there you select the connection, OLEDB properties and datasource and SET.

The you select (ex.) a query...

The end of the stored proc. commit the transaction and clear all temp tables and variables. Perhaps you'd better to use a ##tablename so it is stored in the general...