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

CREATE TRIGGER TrU_T_Server ON T_Server

FOR  delete

AS

if  exists (select * from userdb2.dbo.T_ServerDB B

                   inner join inserted I

               on  B.idnrserver = I.idnr )

 begin

    raiserror("There are still dependant rows" ,16,1)

end

go

I think there even are some articles regarding SET and ANSI at this site.