You need not have DTS packages on the SQL Server 2000 boxes.

Though, I am not completely aware of the internals of the data and how complex / simple it is...

Can I know what is that you are trying to achieve, I saw you posting the same in reply to another post that was few years old and even there...

If you disallow remote connections on your SQL Server, how is...

Yes, unless the data is needed in a near real time and the volume is large, there is no point in setting up replication.

With SSIS you will be pulling the...

Are you planning to get all the data (200 odd rows) once a day (something like day end for that day's entire records)

OR

planning to get the data into your...

Of course moving to 64 Bit brings problems with SSIS with respect to 64 Bit drivers for all the Data Sources your SSIS Packages are using.

Also my suggestion is consider...

This should work.

SELECT T1.Tests, T1.Patient_Id, T1.Date from Table1 T1

Inner Join Table2 T2

ON T1.Patient_ID = T2.Patient_ID

What is that you are looking?

Are you looking for current running Job Names in Activity Monitor?

osama.g.y.a (12/6/2009)

---

We have a table in the SQL database name Alies This table note of each period of the disappearance of all its contents

We do not know what is the...

You have the following MCITP: Database Developer exams 70-441 and 70-442.

For more information follow the link below and look under Microsoft SQL Server.

http://www.microsoft.com/learning/en/us/certification/mcitp.aspx#tab2

I remember saying that (in my initial reply) it would not be possible to change the recovery model when the rollback was running.

What are error messages SQL Server reported...

It's a tricky question to answer, some people say do it and some guys say don't do it.

keeping it aside, if you prepare using the MS Self Paced Training Kits,...

Alvin Ramard (12/4/2009)

---

Bru Medishetty (12/4/2009)

---

I am not sure what did he mean by this

Does SQL Server supports any other OS...

GilaMonster (12/4/2009)

---

Now that I read it again, it's a 2-for-1.

When did replication gain a...

GilaMonster (12/4/2009)

---

I've pinged Paul R and asked if...