There appears to be a problem with this, as it's been reported on the Microsoft tech forums as well. I've reposted the original request to see if an MVP will...

Hi Erich,

What's the fill factor on the clustered index?

(btw, you don't know me, but I'm sitting at your old desk

Lezza

The 2005 view is

SELECT

* FROM msdb.dbo.sysjobs_view.

You'll see the enabled column, and you...

This sounds like a bug to me more than a technical problem. I saw your post on the Microsoft tech forum as well. You might consider posting this under the...

If you were to post what the server foolishness was, someone might be more ready to assist you.

3) Forgot one thing. If you have the t-log backup before the FULL at 1:00 am and the t-log after the FULL at 3:00 am then yes, you can restore to...

Best practices are determined by the business unit (or users or owners of data). They decide how much data they are willing to lose at any one given time. Another...

Thank YOU!! My blood pressure just went back to normal.

We're being hammered by HIPAA on our side, and Profiler is the worst performing utility that comes with SQL Server that I've had experience with. We are looking at third...

Not specifically for this example, but the only benefit I've ever known for a Global Variable is if you have multi processes which need to know what that variable is...

I'm a bit confused as to what the situation is. Do you have a user that is using a Web frontend via their NT account, and then the Web frontend...

Would be nice if you let us see the T-SQL. I get this only on datetime and smalldatetime datatypes only when I'm not using CAST or CONVERT properly. Not saying...

Is there any reason why you have to use a .trc file do to this? If you set the trace to dump into a table instead, then you could pull...

Thanks Antares,

I'm DBA2, and I used that argument. DBA1 still didn't believe me. He says that once the log file is full, it's full, and you have to expand the...

It's the XP/EM bug, raising its ugly head. In EM, click on Microsoft SQL Servers title (until the Tools menu options shows up at top). Click on Tools, then on...