Brian, Ctrl-click doesn't always work for me in IE6. For example, Ctrl-click on your web address opens a new window, but Ctrl-click on your name re-uses the same window. Probably...

I'm on-site at the customer right now. Sure enough, I right-click the db in SSMS and select Properties - the last tran log backup was when I did one manually...

Getting back on-topic, no pun intended.

On the old SS2000 server that did have a maintenance plan, it seems that the ldf files would usually run about 1/3 the size of...

Turns out my web host is having trouble with the email server, so in my case it has nothing to do with the list. My public email address at my...

I'm well aware of the fact that the tran log will grow if not backed up. When RightFax was installed on the old SS2000 server, there was no backup at...

Yes, it does make sense, thanks.

I was outside the loop on the actual server upgrade, but a non-IT person repeated a statement from the vendor about how "Backup Exec can...

Sugesh, Let me clarify - Immediately after restoring the db from production, the ldf was around 220 Megs. I didn't note the size after the first backup, but it is...

This server is on my home office peer-to-peer network, so I am certain there is nobody else in there. But I will check the auto-close/shrink etc settings thanks for the...

There was a recent thread about this, take a look at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=381755

There are no other maintenance tasks scheduled, other than the full backup at midnight & tran log backup every 3 hours. The tran log backup Subplan_1 consists of 1) History...

Jason, how are you going to approach modeling the db if there are no FK's?

I have a similar situation, working with the Microsoft Retail Management System (RMS) and was wondering if you...

I recently had occasion to call Sprint "Customer Solutions" with a simple question: I wanted to find out how to block my outgoing number on a per-call basis. The reason?...

Take a look at the Shell command. Use something like this...

Dim dblTaskID As Double, strCommandLine As String

strCommandLine = "C:\WINDOWS\MyProgram.exe C:\Documents\file.tif"

dblTaskID = Shell (strCommandLine, vbMaximizedFocus)

... dblTaskID = 0 if it fails, otherwise...

Thanks Steve.

Will that be a Beta or a CTP

Here's a very basic explanation how to do that:

http://wvmitchell.blogspot.com/2007/03/pivot-tables.html