Viewing 15 posts - 31 through 45 (of 52 total)
I typed up a simple example in response and discovered that my simple example worked. So I must have done something wrong initially.
May 19, 2007 at 10:35 pm
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...
May 8, 2007 at 5:20 pm
I have not used LogExplorer, although I see they have a free trial. Thanks for the idea.
April 29, 2007 at 12:23 am
April 23, 2007 at 2:16 pm
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...
April 2, 2007 at 3:35 pm
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...
March 30, 2007 at 8:36 pm
Never mind. I figured it out. Just write this:
parameters(0) = New ReportParameter("X")
November 12, 2006 at 11:47 pm
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...
October 14, 2006 at 7:58 pm
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...
July 29, 2005 at 10:47 am
July 29, 2005 at 7:43 am
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...
July 28, 2005 at 2:09 pm
July 28, 2005 at 12:21 pm
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...
June 8, 2005 at 7:43 am
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...
April 8, 2005 at 11:40 am
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...
March 24, 2005 at 3:38 pm
Viewing 15 posts - 31 through 45 (of 52 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy