Very nice !

Make sa jobowner.

Your sql-agent-service-account needs to be able to access all needed files, db, ...

You could also open the commandline setting a proxy-account (check BOL), but I don't know if...

Can you open the DTS-package with EM on the server itself ?

If not, MDAC is your problem.

Only create an maintain DTS-packages at the server itself, not using a client...

Check http://support.microsoft.com/default.aspx?scid=kb;en-us;272318 (sql2000)

http://support.microsoft.com/support/kb/articles/q256/6/50.asp?id=256650&SD (SQL7.0)

mdac-components are stored in the dts-package, that is the problem !

ALWAYS (shout is out as loud as you can) edit packages on the server itself ! Not from a client!...

quote:

---

select distinct p.product, c.currency, c.customer

from ...

where ...

...

---

You may even get advantage by...

exec sp_msforeachdb "select '?',

groupname from ?.dbo.sysfilegroups

where FILEGROUPPROPERTY(groupname, 'IsDefault') = 1 "

quote:

---

sp_helpfile will tell you the database file size which have been allocated to your database.

SELECT FILEPROPERTY('yourdatabaselogicalfilename', 'spaceused') will give you space used...

it reads the filelocations from the backup-set, so you'll have to change file-locations to those available on your clustered-sqlserver-instance.

e.g. :

Restore database mydb

from DISK = '\\myserver\drive$\msSQL\BACKUP\mydbFull.BAK'

with MOVE N'mydb_data' TO N'x:\MSSQL$instance\Data\mydb_data.mdf'

,...

check books online (BOL) for "Linked server"

you would create a linked server on server A to server B and then you can use Server B tables like this :

select ......

Maybe this is wat you're looking for to add the remaining 50%

CREATE FUNCTION dbo.udf_convert_date2WeekRange (@RefDate datetime, @FirstLast char(1) = 'F')

RETURNS datetime

AS

BEGIN

DECLARE @return_date as datetime

...

Might be conveniant if you had a dates-table (like in most datawarehouse-env)

Then you would have a materialized week-start and week-end date, so you could join both tables.

table might contain :

[Calender_YEAR]...

"It returns the computer name on which the command runs. Why are you asking?"

to start on the quest for "why isn't this working".

"So basically I'm guessing no environment variables...

- can you define "last" ?

does your table Test_Results contain a column with datetime of registration ?

- can you post both tables DDL ?

Edited by - alzdba on 12/30/2003 ...

- which Recovery-model did you specify on your sql2000 db ?

Maybe switching to bulk-logged may help out.

Edited by - alzdba on 12/30/2003 01:24:52 AM