I started hacking up the sp and found at the beginning there are a couple of checks to verify there's valid data in the spreadsheet and it stops processing if...

That's a linked server to an Excel Spreadsheet.

I have updated to add table alias and changed table alias on OUTPUT and gone with a real table instead of temp table:

UPDATE company SET

active =

CASE

WHEN [F51] < GETDATE()...

Here's an example: I built a FoxPro database queue solution to update a telephone switch. There was a FoxPro communication library that was able to connect to it....

I took my 10th trip (I had been going since the 1970s) to the UK from the US. Instead of just staying in London and doing day trips to...

ok, I ended up creating a batch file as step 1 to see if the file is there and set an exit code when it's not there, which causes sql...

michaelrounds (9/27/2013)

Unless I'm misunderstanding...

Whenever an email is sent, it comes from me, I'd rather not have that. I've been looking in SPs and tables, but don't see it.

Thanks, I'll do that next time.

On the email alert for blocking, the SQL may get truncated, so I cannot see the table. So, I go into activity monitor where I can see the object...

How about adding a job that can check disk space every hour?

Excellent thanks, I did a dbcc errorlog and reran it. It ran in less than two seconds.

I was on an older version that did not have the Errorlog in...

On one server the daily report runs an incredibly long time. It's on vmWare SQL 2008R2.

I am getting negative numbers on file stats last 24 hours for one of my databases.

File Stats - Last 24 Hours

Filename# ReadsKBytes Read# WritesKBytes WrittenIO Read Wait (MS)IO Write Wait...

Does this work if you use external software such as ArcServe that calls SQL Server APIs?