Thanks, much appreciated.

Thanks, you've been very helpful, much appreciated, will have a look at BOL for further info.

My next task is to create an SSIS package for copying the result I just...

Thanks to you Adam and Grant, I got a result now, Its quite a long row, I noticed that the column 'RS.individual_id = 10734589 ' was repeated a few times,...

Thanks for the contributions, I tried the tsql sent by adam below:

SELECT

* --replace with what you want if not all

FROM

recent_student RS

JOIN

recent_student_graduate_2330 SG2 ON RS.individual_id = SG2.individual_id

JOIN

recent_student_professional SP ON...

Thanks for your reply Grant, there are actually no primary and foreign keys on the tables.

I am a DBA, actually setting up a test environment, so I have installed the server, restored a database, created a user and login for it, will be doing various...

The 'login name' column from sql server should be used to find the 'surname' and 'initials' in outlook. Need to find a way of doing that.

The results in the...

Yes, no 3 has to be done manually, I think I need to create a table, then insert the surnames and initials. I have checked syslogins and sysdatabases and they...

Thanks for all the contributions.

Thanks for all u bits.

Please what will the value 'OUTPUT' be?

I have scripted the trace, now the challenge is to run a job, setting the trace to stop, then restart, the trace will definitely not enter the job step, so...

Hi, just a quick one, if I set the appropriate events in profiler on a server (stored procedures and adhoc queries), can it capture all the previously run transactions on...

Thanks for that, also can you suggest a value to set for the fill factor, books online says anything between 0 to 100%, can I also set fill factor on...

Thanks Carolyn, will let you know how thing go, if I need further help.