Jayanth_Kurup (7/4/2011)

---

select * from issues i

left outer join attachments a

on i.id = a .id

this is similar to what you what , if your looking for spoon feeding , you...

post your statement so far and I will see if your on the right track or not.

surely this will diminish the learning aspect

use books online and look at the isnull function and outter joins

this is a very simple statement you are after

you will want to use an outer join (depends which way round you reference the tables as to a left or right) with the isnull functionality

you will need first to run the database upgrade wizard on the 2008 media to ensure that your databases can be upgraded.

if they can then you can do an in...

you wont be able to as the runtime for 2008 is different than 2005

you will need to get hold of BIDS for 2005 and redesign the package and redeploy

packages can...

what are de definitions of the custom data types?

what kind of column is t_editstamp timestamp, datetime, varchar etc.

i found this on redgate a couple of days ago, pretty basic but a good starting point

it all depends how you want to manage security I guess.

we disable it as you may have domain admins who are not dba's, who will get SA access if bultin\administrators...

So basically its the same as data collector only central as from what I can see UCP enables the data collector on the managed but makes it report to the...

database backups to local backup disk

backup file is copied to remote server and to NAS

backup disk and NAS copy are backed up to the virtual tape device

every 1/4 year one...

yeah the controls are secure, there are only two people who know where the passwords are, the place where they are is secured with no in or out access other...

yeah I have checked the connection managers, they are correct, all using windows authentication, all of the engine and agent acounts have SA access across the estate so no permission...

no, we use connection managers to define the source destination databases and yes the tables are the same on all three databases.

Just find it weird how it works running manually...