Don't worry, must have been a top-secret question

I see a blank message too.

have a nice day

is tcp/ip enabled to be used for sqlserver ?

If I'm correct (local) uses namedpipes

IMO jobs are "posted" into the active sqlagent-memory. This is done at startuptime of sqlagent or at job-modification time when you use the propre sp's.

Allerts with joblaunch are intercepted by...

I don't know if your Grouping is realy needed (all selected columns are involved), but here's me shot :

-- @U_Untagged_T_Tagged_PctSign_All  = '%' for ALL rows

--                                                        'U' for Untagged

--                                                        'T' for Tagged

Alter...

"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...