Answer Questions

• JVV Using a XMLA to generate reports

    hi, I am trying to join a cube that is deployed to XMLA using Deployment Wizard  with  a report template i created using reporting services  2005 but could not figure how to join the XMLA query (SSMS 2005) of a cube and the report template  (SSRS 2005) made. I am hoping the readers could provide some info or some link to where the procedure is explained The results obtained wen i executed the XMLA query using SSMS 2005 object explorer: <return xmlns="urn:schemas-microsoft-com:xml-analysis">   <results xmlns=" http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults ">     <root xmlns="urn:schemas-microsoft-com:xml-analysis:empt ...Show All

• Yang Hsien Min programmatically setting package variables in job step command line

  We are trying to start a server job running an SSIS package and supply some parameters to the package when we start the job using SMO. What we have now is this: string cmdLine = job.JobSteps[0].Command; cmdLine += @" /SET \Package\GetGroupRatingYear_Id.Variables[User::RatingId].Value;1"; cmdLine += @" /SET \Package\GetGroupRatingYear_Id.Variables[User::GroupId].Value;1"; cmdLine += " /SET \\Package.Variables[User::period].Value;\"" + periodEndDate + "\""; job.JobSteps[0].Command = cmdLine; job.Start(); It appears that when the job is run, the modified command line is not used. What is needed to supply runtime parameters to a job step when starting the job via SMO Thanks, Yes it's been a learning curve in how to do what we're tryin ...Show All

• Sam Jost This is how to check your version. From FAQs

  I just tried to install SP2 of the Sql Server Express but it wouldn't install. The message was somthing like: No effective changes to make. Am I missing something here How do I check my version Hey Barry, Thanks for translating the WMI sample from C# to VB.NET. I've imortalized your effort by adding it to the FAQ for this issue, which others can fine here . This way it should be eaiser to find after this post rolls down the forum list. Mike It doesn't matter how many time I read the FAQs. I always get caught out! ( and I couldn't find a way to delete my question so I hope the extra effort here allows me some leighway) This code copied from one of the excellent FAQs and c ...Show All

• laserbeam Change Color of Textbox Depending on Value

  He is my question depending on the code field from my database I need to display a different color. The field is a detail in my table with just text displaying the title of the report. I have the actual code value in another column . I then go to the background color expression and am using this code: =Iif(First(Fields!Code.Value, "CodeDataset" ) = 3, "Green" , Iif(First(Fields!Code.Value, "CodeDataset" ) = 4, "Blue" , "Red" )) They all work if you pull the report up one at a time, but when selecting multi-values you get the color from the first record on each report page no matter what the second, third or so on values are. The code field does display each correct code. Is thi ...Show All

• justin tighe Cannot create new or change existing subscriptions

  We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says Only members of sysadmin role are allowed to update or delete jobs owned by a different login When trying to create a new subscription the report manager displays "An internal error occured" and the log says System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin. We are running sql reporting services 2005 sp1. The report server database s ...Show All

• Michael Herman - Parallelspace Can't get more than first field to evaluate.

  I am having trouble getting an i am working on sql reporting IMBogus1 - Can you provide more details about your problem I'm afraid you haven't given us enough information to even know what you were doing when you had problems. thanks, Ah, okay. I've moved your thread to the SQL Server Reporting Services forum, where you can get a better response about SQL Server Reporting questions. We are still waiting on information from you. If we don’t hear from you in the next seven days, we will delete the thread. We do this to keep the system full of useful information for customers searching for answers and focus expert attention on active unanswered q ...Show All

• agentf1 Adding new columns with check constraints using same batch

  I'm using a stored procedure to add fields to an existing table. These fields must have check constraints and I need to use one T-SQL batch. In Sql2000 Ok. In Sql2005, if table exists, I get error "invalid column xxxxx" in Add Constraint statement before new column creation. the code is Declare @Setup bit Set @Setup = 1 if @Setup = 1 Begin --Alter Table MyTable Add MyField Numeric(1, 0) Not Null Default 3 Exec mySp_Add_Column 'MyTable', 'MyField', 'Numeric (1, 0) Not Null', '3' If IsNull(ObjectProperty(Object_Id('xCK_MyTable_MyField'), 'IsConstraint'), 0) = 0 Alter Table MyTable Add Constraint xCK_MyTable_MyField Check (MyField >= 1 And MyField <= 3) End Else Begin -- drop column ...Show All

• rectis Date not evaluating in an expression

  I have been looking all over for some info about other people having this problem, but haven't found anything. I have a package that needs to download a dated file from an ftp site. I am using a couple script objects to set variables, and one of them is the filename based on the date. I use an expression to get the date: @[User::varFileName] = (DT_WSTR,4) Year( GetDate()) + (DT_WSTR,2) Month( GetDate()) + Substring((DT_WSTR, 29) GETDATE(), 9, 2) Everything works really well when I am debugging it locally. However once it is on the server or even once I come back to it in a day or two, I am still seeing the old date. I thought it might be because my variable needed to be set to evaluateexpression = true, however once I did this ...Show All

• Amir.S Installing SSRS 2005 in web server and cluster environment.

  Hi, I am installing SSRS 2005 with the following scenario: - Report Server and Report Manager will be installed on web server - The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server. Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1 When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct. The error message is: HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials. Internet Information Services (IIS) I've been searching on the web and found couple of articles talking about this issue. ...Show All

• DBFrustrater SSIS Package Store and Sql Server

  Hi everyone, Just a question, generally speaking, when you’re going to save a dtsx package, what are the main differences between SSIS Package Store and Sql Server -When you choose ssis package store option you can save the package in: /MSDB/Maintenance Plans/ mypackage (it saves to sysdtspackges90) /File System/mypackage (are we asuming that sql is going to save it on the folder where .dtproj project file is ) -When you choose sql server option: /Maintenance Plans/mypackage (it saves to sysdtspackges90) Thanks for your comments. A question more Jamie. When you're gonna save it to Sql Server I don't get the point between 'Maintenance Plans' or any folder crea ...Show All

• KitGreen Snapshot Agent missing files.

  My Snapshot Agent for SQL Server 2005 sometimes does not fully complete. I am expecting around 2073 files in the snapshot folder but only get 492 (this number does change). I have immediate_sync set to true, so I should get a full snapshot every time. It seems to quit after all data has been BCP'ed out and before the schema generation starts. I do get the " The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active. " message in the MSSnapshot_history table. I am guessing that there is some sort of blocking ...Show All

• Karl Hulme Move database file

  I want to move my database file to a new directory, I search in MS and I use the following steps: USE master ; SELECT name , physical_name AS CurrentLocation , state_desc FROM sys.master_files WHERE database_id = DB_ID ( N 'test' ); ALTER DATABASE test SET OFFLINE ; ALTER DATABASE test MODIFY FILE ( NAME = test_Log , FILENAME = 'D:\Databases\test_log.ldf' ); ALTER DATABASE test MODIFY FILE ( NAME = test , FILENAME = 'D:\Databases\test.mdf' ); ALTER DATABASE test MODIFY FILE ( NAME = test_Log , FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test_log.ldf' ); ALTER DATABASE test SET ONLI ...Show All

• NT2 Joining Many Tables in Loop

  Hello, I am very new to TSQL however I do have a little programming in my background. I am trying to run a query to select several datafields from about 45 tables within a database. I have written the below code to loop through all of the tables and extract the information however I need to find some way to join the results using PCTimeStamp as the key. Any help anyone can give me is greatly appreciated! while (@Table_Number<18240) /*Loop to read data from all Turbine all Tables*/ BEGIN if (@Table_Number=17990 or @Table_Number=18234) /*ERROR AVOIDANCE for Non-Sequential Turbine #'s*/ BEGIN set @Table_Number=@Table_Number+1; END; set @Table_Insert = cast (@Table_Number as NVARCHAR); /*Converts Table Number to Format usable i ...Show All

• davidtcf DBCC Errors - related to hardware? Can you tell

  Hi, I've got a DB thats throwing up a whole heap of errors in a dbcc command. I'm trying to track where these are from and the likely result of an fix using  'allow data loss' If anyone can throw any light on the error i'd be real greatful. thanks     Server: Msg 8909, Level 16, State 1, Line 2 Table error: Object ID -2088070838, index ID 12303, page ID (1:714907). The PageId in the page header = (2612:1024331787). Server: Msg 8909, Level 16, State 1, Line 2 Table error: Object ID -2055175028, index ID 7452, page ID (1:714860). The PageId in the page header = (525:520452223). Server: Msg 8909, Level 16, State 1, Line 2 Table error: Object ID -2038263743, index ID 33159, page ID (1:714850). The PageId in the ...Show All

• Confused4130 Trying to connect to SharePoint database

  I am having trouble connecting to the SharePoint database on my web server. Our company intranet is accessed by http://webservername/ and the SharePoint site is accessed by http://webservername:2020/ (I wanted to put it on a different port to not interfere with our old intranet). Anyway, I need to connect to the DOCS table on the content database, but I can't seem to connect with SQL Server 2005. When I connect to webservername I see our company database but I don't see anything that has to do with our SharePoint stuff. I've tried connecting to webservername, webservername:2020 and webservername\SharePoint and webservername:2020\SharePoint with no results. If this isn't the right MSDN forum for this I apologize, but any advice would ...Show All