Since the old server is the onlyone having SQL_Latin1_General_CP1_CI_AS , and the others use Latin1_general_CI_AS , maybe this is _the_ occasion to migrate !

This way, when all servers...

at collation level : yes.

We have a mix of 7.0 and sql2000 and are implementing sql2005, still using SQL_Latin1_General_CP1_CI_AS because of the # of servers and databases that have to...

Maybe this helps to figure it out ...

Keep in mind it uses systemtables, which is no a best practise

-- Select  'DBCC UPDATEUSAGE  ('''...

When you use "restore db" to put your db on SQL2005, then it will still have and use it's own collation. That could already be done in SQL2000.

I have this query running every 15 Minutes with sqlagent.

It writes a message to winnt-eventlog which is captured by HPOVow

Primitive, but it works.

declare @DB_Criterium    int

/* ** criterium % must be...

we us HP ovow to monitor the physical disks, not the sqlserver infrastructure.

Here's Freud again

Aha-erlebness

there are some pittfalls with alerts

first of all, an alert only responds when it is enabled

You can check if sqlserver finds the group using Query ananlyser.

connect to the server position in the database

and execute :

use yourdb

go

EXEC master..xp_logininfo @acctname = 'yourdomain\yourgroup',@option = 'members'     -- who belongs...

this would be like pulling a cat insideout   (in a matter of speaking )

If you don't...

Can you try running the dts in the job with its proper name in stead of the guid ?

dtsrun /Npackage_name

Yes it has.

In fact, you can prepare and save your package (if you used the wizard, you must have seen the panel where it asks "run immediate , save as...

Is this package password protected ?

it's _the_ way for importing / exporting data.

Even the wizard is intuitive

EM (enterprise manager) \ databases \tables got to the righthand side, right-click...

did you put the jobowner to SA (and not a windows account) ?