Michelle, we just ran into this same issue last week and lost almost a week of data. Look carefully at the System event log. There will most likely be a...

Five minutes is deifnitely not enough. We have 8 different enterprise db servers. As for the cause, it looks like a brown out since none of them recorded a shut...

Yes, our servers are on UPS' and battery backups. However, and this opinion does not reflect that of upper management, they suck. We have maybe 5 minutes to gracefully shut down...

It could definitley be a permissions issue. To determine the account used by SQL Server go to services, double click MSSQL service and click the "Logon tab". Then, try logging...

So mom, you are suggesting writing a custom log tool.

Is there anything on the market besides Log P.I. that performs a similar function?

I guess I need to rephrase. What I am looking for is some kind of tool that will detect the error, even at 2:00 in the morning, as it's written to...

The database is one of our smaller ones, about 14 GB and we do perform a nightly backup. We do have 3 other systems in a failover environment with log shipping but we...

Cory, use the UNC path to the executable when using xp_cmdshell to avoid conflicts with different drive mappings.

dab

This was an interesting question. I do no yet have a "full" Yukon environment to develop or test in ( I have the Management Studio on my workstation and the...

Paula, not only that, but anything + null = null

dab

Paula, by first 4 columns I assume you mean e.rollno, e.optout, e.electorsurname and e.electorforename1. If these columns return data then look at the remaining columns. One ( or more )...

Race, try putting the where clause outside the OPENQUERY() like this:

SELECT * FROM 

    OPENQUERY(AS400, 'SELECT * FROM Library.SomeTable ) 

WHERE UserID = 'd00d'

AND EnteredDate > '1/31/2005' AND EnteredDate < '3/1/2005'

dab

There were no deleted databases in the list. It has always been master, msdb and the product database.

dab

I think I may have a corrupt MSDE install. I recreated the maintenance plan and omitted the "Remove files older than" steps since the selection box for "Month(s), Week(s), Day(s)"...

That will most likely be the day I stop using SQL Server and make the move to Oracle. I've been weaning my developers from using constructs such as

T1 left outer...