I don't think the original poster is, but it's possible. I think the poster was looking for a particular solution that worked in other database platforms but that isn't possible...

Because like it or not, SQL Server is going to install some files on the system drive. That's why when you do the install and you specify file paths you'll...

It's entirely possible the original poster is trolling, but I try to give everyone the benefit of the doubt. This isn't Usenet, after all.

Yup, for instance, if the linked server is MyTextFile and the text file is MyLogFile.txt you'd do something like:

INSERT INTO MyTextFile...[MyLogFile#txt]
(Col1, Col2)
EXEC dbo.MyProc

Do note the period becomes a # sign....

I think your impression of Books Online is incorrect. Many cases Books Online contains practical information, especially syntax. It also usually explains why you can and can't do something in...

1) Because others may be dealing with a similar issue and by answering this user's question, those other people may be helped.

2) Getting angry at a particular person doesn't solve...

30,000 ft view:

Functions are typically used to return values. For instance, I can create a scalar function and use it as part of a SELECT query. Functions cannot, however, modify...

1) Create a new logfile on another disk (I'm hoping that's what you meant... another poster has already indicated that putting database files on a network share isn't a good...

Why do you need to switch the log file? Is the issue that your logfile is 200 GB and it should be smaller? If so there are better ways to...

There is no direct way to do this. If you watch what Profiler does, it actually has the trace go to temporary files. You can find them under the local...

Because SQL Server can support many users connecting at once, it sounds like you want to use the Profiler tool. You can track what each user is submitting and keep...

The information on the database files for a given database are stored in two places. In the master database, when the database is attached, you'll find the primary file stored...

They are asking for the code in an effort to help you. Perhaps in the way you've written the code there is a problem. You've looked over the code many...

Keep in mind that when you execute a DTS package through Enterprise Manager, two things are true:

1) It runs under your user context

2) It runs on your workstation

When a job...

Do you get the same errors when you're running from another tool like ldifde or through scripting such as with VBScript? Also, what service pack on Windows 2000?