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.

Pay special attention on the db's logfile(s) when you defrag or rebuild the indexes and you are on sql2k with full-recovery mode.

If you don't...