Whatever technology you use, you need some sort of application that can control the printer. I don't think SQL Server is a good place for this. Some small .NET app...

You might also search for some scripts here on the site. Chances are someone has writtne some of them already.

I usually read the overview and then skim the case study. There's definitely extra information, so I'd recommend what Matt suggested. Get to the question and then read the case...

Never delete a log file. Even if the drive is full there are options. You can backup with truncate_only, fun a shrink only on the log, and more.

I'm not sure what you are asking. Please specify in more detail what you'd like to do.

The log file might have been created that large. You can't shrink beyond the initial size.

Matt, Great catch. I missed that in the thread.

There's no good way to do this for a like in 2005. 2008 is supposed to include encrypted indexes, but I'm not...

I could go three! I'll throw in some books as well 🙂

At the very least, can you post a picture to this SQLBay auction??

It's actually not AJAX. It always loads, just closed off by default. It's some type of DIV tag.

If you open it, a cookie will open it next time.

I only fixed that one. I'll have to search around for others.

you can recycle an application pool in IIS based on worker threads, memory use, time of day, and some other options. We used to recycle a few times a day...

If you have enterprise edition, it's included. There's a wizard and menu item.

If you don't, it's simple. Backup logs, copy them to the destination server, restore them with NORECOVERY.

If you...

I've had great luck with batching updates into smaller chunks. One long update might take an hour, but going with quarters (1/4) each time, I might get all 4 to...

First, what version of server and how are you trying to connect? Also what error message?

Second, please post in the appropriate forum. Read the titles of each page to know...

Previous versions allowed pinning, but current versions do not.

I think Jeff has the best idea.