Gazareth (8/6/2012)

---

I think the OP means this:

SELECT CASE WHEN Col1 IS NULL THEN 0 ELSE Col1 END + CASE WHEN Col2 IS NULL THEN 0 ELSE Col2 END ?

SELECT ISNULL(Col1,...

Where are you using the variable? 🙂 I think you meant...

Can you clarify the question? Are you talking about adding a column to a table or to a result set?

Here's something I just threw together. Someone else may have a better way, but this is just off the top of my head:

DECLARE @spName VARCHAR(250);

SET @spName = 'sp_syspolicy_purge_history';

SELECT sj.name,...

That's all there is to it!

For those interested, we have come up with a pretty good idea based off of a current requirement. We have a job that takes a nightly backup of the...

The key here is to keep your storage aligned. We'll be here to help on specifics 🙂 Good luck!

At this point, I would try a repair with the original disks, and then try to reapply the SP.

And how...

mrtrich99 (8/1/2012)

---

james.thomas (8/1/2012)

---

Go to the properties of the job in the Job Activity Monitor and check to see who the owner is set to on the General tab.

If...

mrtrich99 (7/31/2012)

---

SQLRNNR (7/31/2012)

---

Nope. I mean the location on disk where the maint plan is trying to access to write backups, logs, or delete files. Have you tried running...

Ok. I had seen issues with SQL needing a restart, and then you restart and it still says it needs a restart to continue installing. I didn't...

A Partition function and scheme are not table specific, the table is built on the scheme. So if you have more than...

To echo Gail... What problem are you trying to solve where partitioning came up as a possible solution? If it isn't broken, don't try to fix it. However, if...

Start regedit.exe by typing regedit into your Windows search, or navigate to c:\Windows and double-click on regedit.exe.

Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager and locate the PendingFileRenameOperations entry.

Post what you find as the...