I typed up a simple example in response and discovered that my simple example worked. So I must have done something wrong initially.

I don't believe I ever found the answer. Copy/Pasting the value into hundreds of reports wasn't all that bad, so I did that. I think the question does have a...

I have not used LogExplorer, although I see they have a free trial. Thanks for the idea.

Yes, the DTS package is scheduled as /E. I may also note that if I schedule the package using the normal method, which results in an encrypted /Z string in...

I just tried that and I get the same error.

I think it may have something to do with the Service Principle Names. I don't have a regular user account on...

Never mind. I figured it out. Just write this:

parameters(0) = New ReportParameter("X")

I have very similar code to what you have, but I am running into this error when I try to use the object in the report.

[rsCompilerErrorInExpression] The BackgroundColor expression for...

Thanks for the example. The DBCC CHECKIDENT command works when I run it as the sys admin, but not as the dbo of a database. Brian mentioned in another thread...

Thank you. Can this same trick be used for table variables? From what I understand, table variables are better than temporary tables. If I can use this trick for table...

I installed the service pack on six computers. Updating MSDE on my XP box and updating a Windows 2003 server did not require a restart. All four Windows 2000 servers required a...

I personally like the idea of truncating the table then copying over the data. It is clean, but it is much slower than renaming a table for large tables. It...

Thank you. I went ahead and changed my stored procedure.

If anyone knows how to suppress an error in SQL Server 2000, I would still be interested to know in case...