I never restart instances unless there are patches and I need to. The log has nothing to do with restarts, as mentioned.

Read Gail's link and manage your transaction log.

You are correct. You gain nothing preserving it on SQL Server. Now depending on server memory, load, and the data set, it's likely in memory on SQL Server so it's...

wait, wait, wait.

I think you're confused about what is happening. When you start (before page 1), you have:

SQL Server: dataset needed for user 1 + other data

Web server: no data

Client:...

Did you grant "log on as a service" to the account?

I might set up a new domain account (base user, no rights), then use Config Manager to assign this to...

Saw three movies in the last two weeks, a record for me since I think I've only seen 3 or 4 the whole year before that.

- Hangover 2, ehhh, OK

-...

Can you let us know what it is? just in case someone else hits this thread.

David.Poole (6/23/2011)

---

In the UK a number of banks were bailed out by the tax payer. In the same year the bankers were payed immense bonuses "we don't want to...

You backup the tail of the log if you are having issues with your database and are about to restore. It's a normal log backup.

This should help: http://msdn.microsoft.com/en-us/library/ms179314.aspx

Monitoring solely off an iPad, Xoom, etc isn't the use case. It's an additional way to monitor, which can be handy if you aren't near a desktop/laptop.

Hoping Comicon comes to Denver sometime.

Probably. I'm not sure it hurts to be there, but I can understand it being annoying.

If you open a case, would like to know how you remove it.

So can you post all the code? REPLACE by itself doesn't change things. You would have to do this:

update mytable

set col011 = replace( col011, CHAR(10), '')

are there quotes in the name of the server?

Maybe this?

sp_dropserver '''ServerA; UID=DEVAccount;PWD=DEVPwd'''

Sorry, I'll ask some people if they have other ideas.

Are you saying this doesn't work?

replace( col011, CHAR(10), '')

http://msdn.microsoft.com/en-us/library/ms186862.aspx