I ofcourse see the messages, but I want them to be written in a file

See my first post: I need to have the messages shown in "Messages" tab when running...

I need the messages like this:

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

We have 2 tabs when running a query

One...

It was because the one running the job did not have WRITE permission on the folder which OUTPUT was being written.

🙂

Of course.

It was run successfully, but the output file is not created.

I searched the HARD DRIVES to see where it is created. It was nowhere.

When I stop the mssqlservr SERVICE, 3.5 GB is released. That is how I find how much memory is used by the server

The point is that the server is 32 bit and sql 2000 uses 3.5 G of 4 G, on a PC with 4 G RAM, which is also 32 bit,...

32 bit

As I have not installed that SQL 2000, would you tell me how and where it has been told to you've use all the memory on the server if...

GilaMonster (4/16/2012)

---

GilaMonster (4/16/2012)

---

SQL by design uses a lot of memory, it will take any available memory it is allowed to (max server memory setting) and will keep using it until...

Many thanks for your prompt response. I installed it and used it to read the LDF file. Now the problem is that although I am sure that the Table was...

I could not wait more so UNWILLINGLY I stopped the sql server and restarted it and everything was OK then. I really wanted to find out the root of the...

Would you please kindly let me know how I can insert data in a table via QA in SQL which has binaru data

Suppose the table has 3 columns(id, Desc, File)

id...

Thanks for the reply.

I checked the SQL log, there was a message saying "insufficient memory"

And the spid it referes to is for a database which is not the one which...

I get the error when the size of the files exceeds 400 K or so

Files lower than 400 K are uploaded easily.

I get this error when the file is more than 400K:

A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on...