Good introductory article. Will you be doing a follow-up article? I'd like to see one on using the T-SQL templates which aid in quickly creating standardised SP's.

Thanks

Phill Carter

quote:

---

To understand this properly can you give me what the output should be from your data posted and why?

"Don't roll your eyes...

quote:

---

Tried tricking it maybe? Build it as a view, then build a view around it? Or how about omitting the left join...

quote:

---

The fastest is to always execute at the server itself. If you do from a client machine the data wil cross the...

quote:

---

Hmmmmm Log to a desktop? Sounds feasable to me. These days the lines between workstation and server blur so easily.

Now that...

quote:

---

Wait for approval - now that's a good one! Ok, if not full blown SQL Server, how about the MSDE engine? ...

quote:

---

Sounds like a nightmare. I don't suppose you could install SQL on the NT box that's downloading the files?

Another question. ...

quote:

---

I have a really dumb question. Why not use the logging functionality built into DTS? What does your logging add...

quote:

---

I thought you would have had another SQL server from which to run a package that just uses Server2 as the source...

Ok Guys

Here is what I have at the moment. I probably should have pasted this in earlier .

Basically, from the current step I can determine the prior...

Andy,

That is just what I'm trying to do. But I can find no method of determining the current step.

Basically I want to log a status message to a file saying...

Another method is to use the Dynamic Properties task. Using this method you can set Global Variables from an INI file, a database query, an environment variable and a couple...

Thought as much. We'll most likely be re-creating on a new server anyway.

I'll generate DDL for all the objects and DTS the data over from our other SQL7 box.

If the...

Thanks for all your suggestions.

Here's what I'm am proposing,

SQL Cluster running Active/Active, One node doing database processing the other doing acting as the distributor. Each node can fail across to...

quote:

---

How can I make the data I retrieve from a pass through query in Access updateable?

any ideas?

thanks in advance

---

May 21, 2002 at 3:40 pm