I knew I must have been missing something.

Thank you!!!

Hmm, actually I had a mapping in place.

With the explicit mapping removed, it doesn't work for me even within the same database.

-- Logged in as sa

USE master;

SELECT COUNT(*) FROM master.dbo.mytesttable;

EXECUTE...

GilaMonster (9/25/2012)

---

sestell1 (9/25/2012)

---

If you impersonate an account that does not have explicit rights within a database, you will not have any rights within that database, even if both accounts are...

opc.three (9/25/2012)

---

sestell1 (9/25/2012)

---

opc.three (9/25/2012)

---

To be clear sa...

It's not an option you can change in the editor. You have to set it from the task properties.

Interesting! I have no idea, as I've never seen anyone try to do this before. I'd guess if things like the job agent work alright then it should...

opc.three (9/25/2012)

---

To be clear sa is implicitly...

Try going to the properties of the step causing the validation error and setting delay validation to true.

If ^ was a POWER operator, you could do:

SELECT $^$

Alas,...

Hmm, I couldn't think of anything shorter. I wanted to find a way to implicitly convert PI to a bit, but apparently there's no bit literal in SQL Server.

I...

Shoot, I had selected sp_who2, but changed it since it said disk reads instead of total disk IO.

Ugh... I'm never quite sure if it's an oversight, typo,...

Depending on the version of Windows your servers are running, you should be able to get the disk space information doing something like this:

EXEC xp_CMDShell 'wmic volume get capacity,caption,freespace'

You could...

Interesting question, I would have thought it would never return results if all the data was on a single page.

Divine Flame (9/17/2012)...Many of us (including me until I didn’t face this issue) assume that FORMAT & INIT work in the same manner, that's what prompted me to add INIT...

Good question... something many people tend to learn only after running into this for the first time.