You have 2 options, forgive my quick code but wanted to throw something together that would work for you (I tested it locally just fine) - hope this helps!

1) Re-execute...

Have you tried to set the "Use 32-bit runtime" under the job step's Execution Options?

This article may help

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/17a6c4f4-3a44-4d72-89e4-37c3ab9df532

Crude, but this will work, just loop through a directory (if you are able to execute xp_cmdshell, if not I'm sure there's a powershell script lingering around)DECLARE

...

IMHO it's used mostly to save time when writing the code. It's like saying INSERT this set of data...and also this, oh wait, here's a few more rows to...

I know this is an assumption, but the 'sa' account you are using to connect via the credentials...it is the actual "sa" account and it is a member of the...

When you right click and view the DB size it includes the log file and is a rounded number (which you know). The space shown in the properties tab...

It's a good rule of thumb to place it on multiple drives (especially in RAID configuration). Have you taken steps to monitor your tempdb usage and do you have...

You are absolutely correct (my bad) :w00t:

SQLRNNR (1/18/2013)

---

Somebody probably created the second file as a spillover due to the space issues.

If the drive where the first log file was created is out of space, I would...

Here is some code to determine which file group your tables exist on:

SELECT o. [name], o .[type], f .[name],f.data_space_id

FROM sys.indexes i

INNER JOIN sys.filegroups f

ON i. data_space_id = f .data_space_id

INNER JOIN...

I believe an accidental typo?

INSERT INTO #BreakDownByCategories

EXEC dbo.spGetCategoriesByDocIDAsTable @DocID

Index Id 2 should relate to a non-clustered index, simply drop and recreate the index and you should resolve the issue. After that run a DBCC CHECKTABLE('YouTable') WITH...

There's probably a much better/efficient way to do this but here's a simple example you can modify to suit your needs - FYI the U NION ALL is on purpose...

I'm going through a similar situation - check out my thread - http://www.sqlservercentral.com/Forums/Topic1407363-1550-1.aspx#bm1408963

In your situation, what do you mean by "root" directory? if there's just user DBs on the...