You all have a wicked sense of humor... 😀

Looks like you are using SQL Server express in web server. That is why you are not able to see the SQL Server Agent service.

What you could try is...

It would be best to use power shell instead of using T-SQL to write to OS files. Phil factor has some articles that help you with doing it in T-SQL.

Anybody having problems posting here? One guy complained about it in Twitter.

The next big release of Sql Server is Denali. The CTP version is out. You can search for SQL Server Denali and you will get more details regarding it.

Get well Jack. November is just not your month I guess. First your son broke his hand now you are having high cholesterol.

Do you have any filters set for your replication?

It could be problem with the log reader. I have heard people saying that a reboot will solve this. Usually it is...

Steve is not in town.. he is at the airport. And it is Friday... 🙂 Let the party begin.. 🙂

Alvin Ramard (11/19/2010)

Stefan Krzywicki (11/19/2010)

I'm an American, so I have no first-hand knowledge...

Thank You for posting the issue and the way you solved it. It will help others if they encounter this problem.

The way I see it is like this.

I would not want to have any third party vendors to have any access to my database. Therefore I would write a simple...

SQL Server will release memory when some other operation of OS needs it.

But in this case, we are not sure if there is a memory pressure or not. Only...

To free up memory you can run

DBCC FREEPROCCACHE will free procedure cache

DBCC FREESYSTEMCACHE will remove...

As per MS, To reduce the max server memory you may need to restart SQL Server to release the memory.

The only way to release memory is to use DBCC commands....

Is this a 64 bit or 32 bit? Did you set up maximum memory for SQL Server?