Questions:

1) Are you running SSMS on your local, desktop system?

2) Are you connecting to a remote server named Belmont?

If the answers to these questions are yes, when you run the...

At some point, you have to work with the people in the best position to help.

briancampbellmcad (5/18/2015)

---

I verified that those objects existed in the paths I used below and still got an error:

RESTORE DATABASE BCCrestore

FROM DISK = 'Z:\BCC_DB_backup_201505020017.bak'

WITH MOVE 'BCC' TO 'Z:\Databases\Data\BCCrestore.mdf',

...

And what does this mean?

xizwyck (5/18/2015)

---

It's six years old but still appears in a search engine query result. If the information/thread is incomplete or not marked as resolved and it's this old, it should...

briancampbellmcad (5/18/2015)

---

I ran xp_fixeddrives and saw:

drive | MB free

C | 45177

D | ...

What version of SQL Server are you using? Sounds like you may be using SQL Server 2008 and the features you are looking for were released in SQL Server...

pdanes (5/18/2015)

---

That looks promising, but I'm getting an error:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or...

Or like this:

declare @TestTable table(

Id int,

GroupCode char(1)

);

insert into @TestTable

values (1,'A'),

(1,'B'),

...

Sean Lange (5/18/2015)

---

Well...

Vyper426 (5/14/2015)

---

I Really appreciate everyone who contributed information. I must also apologize for neglecting to let everyone know the other issue that brings me such joy in this new position:...

Start here:

https://msdn.microsoft.com/en-us/library/ms188754(v=sql.105).aspx

And then of course, there is the NOLOCK hint with a query that appears to be working with financial data.

Same issue when I run it on a SQL Server 2008 R2 SE instance (10.50,6000).

Really interesting. I ran the T-SQL code provided by the OP on my SQL Server 2012 DE and I get the Error converting data type varchar to numeric as...