Yes, the column allows Nulls.

Ok, I'll give that a try tomorrow. However, it's strange that the current setup has been working for years and now all of a sudden it's...

Actually I figured out a solution. It wasn't easy but it turned out that the report I was trying to deploy was already existing on the server, but it was...

Sorry Guys,

It turned out to be an SQL 2005 installation that was previously there. I reran the SQL Express 2008 but this time, I selected the option to upgrade from...

Actually, I learned from the DBA today that the stored procedure really was copied over to the new server. But what the DBA told me is that the EXECUTE permission...

Problem solved.

The DTS components that were installed were behaving strangely. Everytime I opened a package an error kept popping up. I don't remember what the message was off hand. But...

I need to JOIN it with tblOrders because the next box number is based on the order date. Box numbers can repeat on different days. If I wrap it inside...

But that wouldn't fix the problem. I still have to go to this new table to get the next box number. And of course, two people can read the same...

I'm not in front of my computer right now but the entire report did not want to render. I got a message saying along the lines that the report could...

I created the synonym but I soon learned that you cannot create a synonym for a server object. Or can you? I tried creating the synonym like so:

CREATE SYNONYM Remote_Server...

I've never used synonyms before. Does that mean that when I refresh the DEV database I need to modify the synonym every time?

Yes, it is an ADP file that is connected to SQL 2005.

So, I'm understanding that even when a SELECT executes, the record gets locked?

Thanks guys, that did the trick...

I believe those are specific to SQL2008, I'm using SQL2005.

That's right.

He only used views inside Stored Procedures.

For example, when I open one called uspSelCustomers, I see:

SELECT CustomerID, CustomerName

FROM dbo.vwCustomers

WHERE Active = 1

And the view is defines as:

SELECT CustomerID, CustomerName,...

The proxy account is a domain user. I asked my network guy to set up the security and it now works perfectly.

Thanks !!