for this you don't need "case" but correlated subquery 

select * from dyna.dtaTenant t

where not exists

(

SELECT 1

FROM dyna.dtaTenant

 INNER JOIN dyna.ctlLinks

 ON dyna.dtaTenant.DyKey =...

One of our customers stated he didn't need backups copied to a safe place.

When he tested his backup-power-system there was this litle problem where in stead of 220V the...

only one client ?

The more stupidities they produce, the more they'll need people like us

Make it...

trivial, but overlooked it

Nice...

how about using transactions to get isolation ?

Offcourse everything has a price !

CREATE PROCEDURE GetColor

    @OutRowID INT OUTPUT

AS

BEGIN

-- print statements added for debugging

    SET NOCOUNT ON

declare @trancount int

set @trancount...

firts : ALTER DATABASE yourDB  Set [RESTRICTED_USER , ]

                READ_only  WITH ROLLBACK IMMEDIATE

then perform your restore.

After restore, the db will be in the same state as it was when...

where is your query or error-generation command ?

select ...

from employee E

inner join Rooms R

on E.EmpRoomNum = R.RoomNum

inner join Device D

on D.DeVRoomNum = R.RoomNum

and D.DevSignByEmp = E.EmpID

would be...

.Bak files should be restored

check restore database in books online

I didn't check the forum-group

Now my responce...

Is this a clustered server ?

EnterpriseManagers does not autorefresh.

If you don't trust its results, disconnect and connect again so it refreshes all catalog-data.

Hitting F5 at the tables-tree in the lefthand pain, also may help.

check this site's search : "remove duplicates".

Test it before going live !

Many of us use Query Analyzer to perform this kind of stuff.

(Enterprise...

Thanks for the addition, Frank.

I was to much in a hurry for my lunchbreak.

.... and lost...

select yourkeycolum(s) , count(*) as counter

from your_object

group by yourkeycolum(s)

having count(*) > 1

-- order by yourkeycolum(s)

I hope this helps

I'ts always a nice year if you can look back on it  

Be patient, be strong and shut off your nose

also check this function :

http://www.sqlservercentral.com/scripts/contributions/1199.asp