Monday, September 23, 2013

[SQL 2012] SSRS report with dynamic column headers

[SQL 2012] SSRS report with dynamic column headers

SSRS report with dynamic column headers

Posted: 22 Sep 2013 05:24 AM PDT

Hi,I have a report which runs for last 12 months data. Since this is going to be last 12 months the column headers change every month. How can we implement this with dynamic column headers in the dataset? Thanks.

sql server 2012 licensing question

Posted: 22 Sep 2013 05:53 AM PDT

Hello all We have a fairly simple SQL server environment today (licensing wise) All of our SQL Server instances are standard edition and we have a simple per-processor Enterprise aggreemnt with MIcrosoft. What is now being proposed is the followingNine new Servers running the following: SQL Server 2012 DBMS DevelopmentSQL Server 2012 DBMS QASQL Server 2012 DBMS ProductionSQL Server 2012 Analysis Services (SSAS) DevelopmentSQL Server 2012 Analysis Services (SSAS) QASQL Server 2012 Analysis Services (SSAS) ProductionSQL Server 2012 Reporting Services (SSRS) DevelopmentSQL Server 2012 Reporting Services (SSRS) QASQL Server Reporting Services (SSRS) ProductionDoes anyone know how the licensing works for SSAS and SSRS when they are split out and run on servers that are separate from the DBMS Servers: Is SSAS (or SSRS) counted as a separate SQL Server license?

MSDB Error in backup of user database

Posted: 22 Sep 2013 12:17 PM PDT

Hi all,A new database was created on our existing single instance Sql Server 2012 Enterprise . Our over night maintenance job to backup the database failed with the following error from this new database:Msg 8152, Level 16, State 13, Line 1String or binary data would be truncated.Msg 3009, Level 16, State 1, Line 1Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.-I have verified that MSDB is not corrupted via dbcc checkdb with 0 errors -Space is not an issue on any database as all files are set to auto grow and this is a new server with plenty of disk.-Since the db was created the maint job has failed on this specific db, but I have not tried to drop/recreate this new database. (trying to avoid drop/create)-I've tried restoring msdb from an older backup from before the db create, but backup still errors out. (never had a successful backup since new db created)(One thing I've noticed since this is a sharepoint database, the name is 97 chars long, however as a test I created another test db with a longer name than this one and backup worked fine)I've searched online and the forums here with old entries and no luck. Am I missing any other possible solutions?Thanks in advance!
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog