"However, when I schedule a job on SQL1 with the statement 'select * from SQL2.northwind.dbo.categories' the job runs fine; dito for SQL3. And when I execute the package directly, it...

No, when you open the dts-package and run it, it uses your client-stuff.

I didn't notify in your previous post that you ran it OK with...

does the sqlserver-service account or the sqlagent-service-account have network authorities to make the connection ?

When you run it using EM, it also uses the rights you - as a windows...

as long as no one  will use your "hours"-column for timecalculations, all workarounds may be fine.

If you want to perform timecalculations, be more strict...

or use a nested table expression :

SELECT T1.NewColumn, Table2.SelectCol2, count(*) as Counter

from ( select *

CASE WHEN Table1.Name LIKE '%FOO%' THEN 'FOO TOO'

else Table1.Name

END as NewColumn

 FROM Table1) T1

inner JOIN...

my Ying  says its basicaly the same, but with usage-constraints

my Yang says "use the defaults because some...

should work like this :

create table t_muteNULL (col1 int identity (1,1) not null, col2 varchar(128) , col3 varchar(128))

go

alter table t_muteNULL

add constraint chkMuteNULL check (case when col2 is null and...

it converts it into a correlated subquery

problem ? no problem one just has to know and...

based on system catalog info (designed for sql2k sp3)

select  u.name as TbOwner, o.name as TbName ,  x.name as IxName, xc.name as IxColName, xk.keyno...

http://www.sql-server-performance.com/dp_no_cursors.asp

- did you see a popup window at serverside "user32.dll failed to initialise..."  ?  Check KB184802

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q184/8/02.asp&NoWebContent=1 

In that case, sqlagent will wait for a "ok" reply to that...

maybe http://www.sqldts.com has what you're looking for

- _WA** are just statistics, that 's not the same as a regular index.

- However it does give you a hint on which columns are used for searchoperations.

- Use "create...

1) - there is no need to perform detach/attach to make a backup !!

  That way you'll waste backupspace and you'll have downtime.

   -...

Youre welcome, thats what this group is all about

Actualy, there's a little bug because a for delete trigger only has the deleted object...