Thank you ! Thank you ! Thank you !

Thank you. I read on another forum that if you leave out the '@article ' line it defaults to all.

I ran it like this and it worked!! ...

So here is my code.. This returns

select a.towid,a.update_date,a.update_action,b.towid,b.presentdate

from modify_title.dbo.mat_audit_nbdoc as a left join towerdb.tower.nbdocdeletedrecords as b

on (a.towid = b.towid)

where

a.Update_Date >= '04/07/2009'

and a.Update_Date < '04/08/2009'

and...

awesome! Thnk you!

It's not an interview question.. and I suppose I don't understand joins as well as I should. I thought it would be a left outer join but everytime...

Thanks!!! What I ended up doing was making him a memeber of the TargetServers role in the MSDB database. He can now view jobs and job...

Just to see the jobs and the job history would suffice. Can this be done? I can't figure out how to do it...

Take out the '(' after Create Table ZZDataBaseAdminLog ???

Thank you!!!

How would I modify this script to show the results in MB instead of GB?

oh boy.. I must be half brain dead. Thank you! that worked.

thanks!

Tried this:

DELETE R

FROM [tower].[NBDocUpdatedRecords] R

LEFT JOIN ( select MIN(ReplicationID), {Unique key}

from [tower].[NBDocUpdatedRecords]

...

here is the table:

CREATE TABLE [tower].[NBDocUpdatedRecords] (

[PresentDate] [datetime] NULL ,

[SystemUser] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[npages] [int] NULL ,

[ifnds] [int] NULL ,

[ifnid] [int] NULL ,

[datatype] [int] NULL ,

[win] [varchar]...

thank you. APP\DEV is looking at the code to see if this particular index is named anywhere before I drop it.

both indexes are on only one column - polnum. What - if any - damage could I cause if I dropped the non-unique - non-clusered index and left the clustered/unique...