Someone trying to see if they could get on this thread?

17

Do you have any other applications connecting to this data source? Are they having any issues? Any errors in the SQL Server or Windows error logs?

My vote is permissions. Verify the SQL Server login you created for the linked server has rights to the database and table.

Without seeing the DDL and having some test data, see the link in my signature, it is hard to give you an exact answer,

but I think this will do...

What is the error? You didn't include it in the post anywhere.

Wish I could do more, but I don't have a 64-bit box to experiment with right now.

Your SQL Server is set to recognize dates in mdy and the parameter you have on your convert is producing dmy so when sql server is converting it back to...

I've never been involved in scouting, but I have about 10 years of coaching various sports from youth to High School and I agree that it is very rewarding to...

Lynn,

I went the simply route and looked at the Summary logs first, side by side. Here are the sections:

Dev01:

Products Detected ...

One thing I noticed pretty quickly is that the 2 servers have different builds and the one that worked has a later build. I don't know why that would...

Thanks, I only got it because I had to lookup what number was returned for Wednesday and...

I agree with Jonathan. Here's a basic idea of what you would want to do:

[font="Courier New"]SELECT TOP 366

   IDENTITY(INT, 1, 1) AS n

INTO

   #nums

FROM

   sys.all_objects

   SELECT

       DATEADD(DAY,...

A good place to start would be in the Scripts section of this site. Here is a list of security based scripts: http://www.sqlservercentral.com/Scripts/Administration/Security/. One of these should point...

You can just use the parameter in the Header. Like this:

="Fee Date: " & Parameters!feeDate.Value