Viewing 15 posts - 1,066 through 1,080 (of 1,193 total)
Could be your report localisation doesn't like the format in your string,
e.g. 03152012 = 15th March 2012 in US, 3rd ???? 2012 in UK.
March 15, 2012 at 8:44 am
Cool, glad you found the solution!
Gaz
March 14, 2012 at 5:11 am
It does seem odd that the example adds a layer of abstraction by suggesting using the COLUMNPROPERTY function against INFORMATION_SCHEMA tables, rather than going directly to the sys.columns view. ANSI...
March 13, 2012 at 5:23 am
Ok, see if the information here is any use to you:
http://technet.microsoft.com/en-us/library/ms345234.aspx
There's also a link on that page that goes into more detail on the structure of the RSReportServer.config file.
Thanks
March 13, 2012 at 5:12 am
mohan.bndr (3/13/2012)
The person doesn't have that list. I need to prepare and then ask.
That sounds the wrong way round to me!
Agree with Gianluca's recommendation though.
March 13, 2012 at 3:51 am
Hi Mark,
Not sure if it applies as I don't use SSRS in Sharepoint mode, but what's listed on the Email Settings page of the Reporting Service Configuration Manager? (Shortuct should...
March 12, 2012 at 11:36 am
Hi Greg,
From Books Online:
In SQL Server 2008, the ORDINAL_POSITION column of the INFORMATION_SCHEMA.COLUMNS view is not compatible with the bit pattern of columns returned by COLUMNS_UPDATED. To obtain a bit...
March 12, 2012 at 6:31 am
Thanks, good article.
And to echo you both, definitely something DBA's should know.
Helps that I find it an interesting area 🙂
March 9, 2012 at 9:56 am
I'm still having nightmares from trying (and mostly failing) to get SQL 2K to work with Crystal Reports. :crazy: :crying:
Luckily the company was down to 3 monthly Crystal Reports by...
March 9, 2012 at 4:27 am
Yep, we've got a couple of servers running SQL 2000, one was only commissioned 12 months ago!
Love SQL 2000 (it's what I cut my DBA teeth on), but it's "pre-SSRS"...
March 9, 2012 at 3:45 am
The update will fail I believe - as the non-cascading FK would be violated.
a.penasco (3/7/2012)
No, I'm afraid that a surrogate key wouldn't solve the problem.
Why not? Seems a good solution...
March 7, 2012 at 7:58 am
Isn't sys.sysprocesses marked for deprecation?
I use sys.dm_exec_requests/connections/sessions (whichever's appropriate) in its place.
February 29, 2012 at 7:14 am
I've wondered about that with 64-bit systems myself. And having to use the trace flag on Standard edition is a new one on me.
Looks like I've got some SQL services...
February 28, 2012 at 6:44 am
Victor Kirkpatrick (1/5/2011)
Columns in the IN clause! 22 years of sql and that was a first. You're never too old to learn. Thanks!
And I was feeling bad for not knowing...
February 23, 2012 at 8:42 am
Viewing 15 posts - 1,066 through 1,080 (of 1,193 total)