Ron

Never had much luck with shrinking the log file under SQL7. In SQL2K it's a bit better, but not that much. You can play around with the virtual logs files,...

quote:

---

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_1d7y.asp

---

Thanks, just what I needed.

Thanks

Phill Carter

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...