OK, that worked. Any idea why?

And thank you!

A little more information - if I just run this code outside of a stored proc, it works fine. So:

DECLARE @SQLString AS nvarchar(200);

DECLARE @Parms AS nvarchar(200);

DECLARE @NumberofRows int;

DECLARE @OneSlashServer...

@SQLString is an nvarchar(200). If, instead of executing, I just PRINT it, I get

SELECT @CountOUT = COUNT(*) FROM [SQL004\SQL004].rems.dbo.[Order] WHERE OrderID = 14 AND UserID = 533

which is what...

That is the exact error message I get from the computer. However, what's in the sp has the correct number of square brackets:

SET @SQLString = N'SELECT @CountOUT = COUNT(*)...

How does the linked server definition (which exists) need to be changed?

Also - I should've noted that the server where this sp resides is 2005, but REMSServer is SQL Server...

No, that's not the solution. The solution was embarrassingly obvious - I just kept missing it. My parameter length was only 10. Changing it to 30 made...

OK, I've solved this, although I'm still a bit befuddled. One really big problem was that the production database server is in a cluster and had failed over to...

Yes! Thank you SO much! I knew my way was just too too dumb, but I just couldn't figure out any other way of doing it. My...

That was it! Thanks so much! 😀

OK, sorry, somehow I posted this before I'd finished writing it. This is the 2nd time I've done that on this forum recently. Sorry!!! :hehe:

Anyway, as I...

Thanks everybody, very helpful! 😀

Sergiy, thanks so much, this works beautifully! 😀 😀

Quite correct! I always assume that my goofs are going to be glaringly obvious to everybody but me, but just in case:

I'm setting ConfigurationManager.AppSettings["TrackitDB"].ToString() = TRACKIT8_DATA (which is on...

Got it, thanks!

Forgot to mention your question on the clustered index for AttendanceDateTime in the Attendance table. I'll research this; I really don't know. This is an app I inherited...