Answer Questions

• Per J SSRS Question?

  Q1: Is there any utility available to convert Access reports -> SRS Reports Q2: Does SSRS support DB2 Thanks, Q1: In Report Designer, you can find an Access report importer that converts Access reports. http://msdn2.microsoft.com/en-us/library/ms156375.aspx Q2: Yes. SSRS supports any standard .NET data providers. ...Show All

• rahvyn6 Invalid Semantic Model

  Hello While following the instructions on the tutorial "Creating a Report Model Based on an Analysis Services Cube", I got this error when trying to create the report model: The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.micr ...Show All

• sadia That assembly does not allow partially trusted callers.

  I have a report that references a custom assembly. The assembly loads an xml file from a web site in the code OnInit. The reports designer the code runs fine, because it is called with full trust. I deployed the report to our test sever, and copied the two dll files to c:\Program File\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportService\bin. I have added the following to the rssrvpolicy file. < PermissionSet class = &qu ...Show All

• pbala can't start mssqlserver

  I installed a copy of SQL server 2005 on a Win 2003 machine. I connected remotely from another machine and started Sql Server Configuration manager. The MSSQLServer is stopped. So, I click to start and it failed. The error it gave me was that it time out. I am new to SQL 2005 and I thought the next step after installing was to configure. Can anyone help me please. Hi, in addition to the aother post, try to make ...Show All

• Gun Not sure how to form select with checks

  I only want to insert an extra data record for each corresponding m.number if and only if there isn't an existing record in extradata for that specific m.number where extradata.extracode = 'UU'. The requirement is that this is a nightly run. It searches for any recors in the phones table for m.number where p.good is null or =1. If found, then insert a record into extradata with an extracode of 'UU' if and only if one doesn't exist for each m. ...Show All

• Barnabas weekly schedule

  Hi,   I need to implement the weekly scheduling logic in a stored procedure similar to windows schedule task weekly.  It needs to find the next runtime from the current date.   I will provide schedulestartdate, frequency (in week), days of execution like @Mon, @Tue, @Wed, @Thu.. and if their value is 1 then we need to execute on the corresponding week day.     The procedure needs t ...Show All

• RenjithG Date time conversion problem

  Hi, I've run into a date conversion problem. When my package starts, I use a SQL Execute task to insert a record into a table. I set the SQLStatementSource value as follows: "INSERT INTO tblUploadHeader (ExecutionGUID, StartDateTime) VALUES ( '" + @[System::ExecutionInstanceGUID] + "', '" + (DT_WSTR, 20) @[System::StartTime] + "' )" which evaluates to INSERT INTO tblUploadHeader (ExecutionGUID, StartDat ...Show All

• Selim Yucel Passing parameter using .SQL

  Hi all I need to pass parameters when I call a .SQL file. Is there a way to do this in SQL Server thanks!!!! There is no easy way to pass parameters from a batch script and reference it in a SQL script in SQL Server 2000. So you will have to use a different utility to pre-process the SQL script based on the parameter value and then pass it to OSQL. In SQL Server 2005, you can use the new SQLCMD command-line utility which has some pre ...Show All

• GaryKnowles How to identify which version we have?

  How do I tell if I am running SQL2K Enterprise Edition or Standard Edition We have a 2-node cluster. Does that imply Enterprise Edition, or could Standard do that as well Thanks for any info. If it's SQL 2000, only Enterprise is supported in a cluster configuration...if SQL 2005, Standard is also supported. You can run the following to find your the edition of the server you are running...just connect via ...Show All

• DannyMc SQL Server 2005 Remote Connection Problem... Big Time.

  Hi, I installed SQL server 2005 express edition on my windows server and I had no problem with connecting it remotely through Management Studio, then I removed it and installed a full edition SQL server 2005. That's when it's gone all wrong. Now I can't remotely connect the server through Management Studio. The error I get is the same as some of the people in this forum has which is: "An error has occurred while establishing a conn ...Show All

• Christian Bayer Error when I setup website to sub level

  Hi, I am getting the following error when I use the Membeship Controls w/ Roles enabled. Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.  This error can be caused by a virtual directory not being configured as an application in IIS. I use ROOT>USER>WEBSITE for FTP Directory Setup. If i need to change my old ways please inform me on the bes ...Show All

• Matthew Carter Passing multivalued parameter from parent report to child report in Reporting service

  I have report which accepts multi Value paramter in the Parent Report, this report has a drill down feature. but when i try passing the multi value parameter to the child report only the 1st value in the list is passed. Parent Report accepts multiple users and based on which it shows the total % of issues submitted by thoses selected users in the multi value list. on drill down i need to send the user list again from the parent so that the ch ...Show All

• Raghavendra Prabhu MSFT Unable to install SQL Server Express : Hanging On 'Scanning your computer'

  Hi! I'm attempting to install SQL Server Express under Windows XP, and have installed all the pre-requisite software (Windows installer and framework).  However, when it reaches the screen during the SQL Server install entitled 'System Configuration Check' it pauses at 'SQL Server is scanning your computer's configuration'.  It was hanging there for an hour, so I retried, and it's doing the same. Is there anything I can do to get ...Show All

• Joao Costa I need a second opinion on SQL 2005 syntax

  I am not that experienced in SQL 2005 and I'm trying to debug a stored proc (written by a far more experienced programmer which is why I'm appending here.) At the top of the proc is the statement ' DECLARE @BillActualRoom bit'. If I understand correctly this is a local variable. Later in the code we have the statement 'SELECT @BillActualRoom = 0 FROM BillingOptions WHERE CenterID = @CenterID' where @CenterID is an input ...Show All

• __MaVEricK__ How can I move the system databases?

  I have been attempting to detach and reattach the model database.  I tried to set the Trace Flag 3608, but it is having no effect. Just to be sure I am setting the flag correctly, here is the startup parameters string in my Configuration Manager: -dD:\MSSQL.1\MSSQL\DATA\master.mdf;-eD:\MSSQL.1\MSSQL\LOG\ERRORLOG;-lD:\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T3608 Has the process of moving system databases changed in 2005 ...Show All