Answer Questions

• Najwa Reporting Service interoperability

  Hi, I'm evaluating Sql Server 2005 for my company. Here we also use AS400 DB2 for our ERP. Could I use Reporting Service to create report on DB2 in the same way as someone could use MS access TIA Marco Paci Yes. You need to go to the IBM web site and download the db2 drivers. I think the package is IBM DB2 Client Access Enabler (CAE). You then need to write your DB2 SQL in the report which can get kind of hairy. If I can get away with it, I write SSIS packages and write the reports using SQL Server. ...Show All

• StuartGM How to create CHECK CONSTRAINT with SMO

  I am using C# and SMO to create tables. Have figured out how to create the tables and foreign keys. but not how to add a Check Constraint in code as in: ALTER TABLE [dbo] . [BackgroundChecks] CHECK CONSTRAINT [FK_BackgroundChecks_BackgroundCheckTypes1] Any help is appreciated. That creates the foreign key, but not the Check Constraint. Have you looked at the AddDefaultConstraint method of the Column object OK, got it. Much simpler than it should have been given the amount of time spent. string sqlCmd = "ALTER TABLE [" + myTable.Name + "] CHECK CONSTRAINT [" + myForeignKey.Name + "]" ; myDB.ExecuteNonQuery(sqlCmd); On second thought, you probably want to w ...Show All

• JoelBennett How to stop automatic excution of a report?

  Hi, I have a report containing one multi-value parameter with default values given. When open I report in Report Manager, report executes automatically. I need to stop this automatic execution of report. I need to give user an option to check if default values are ok for him or not. Is there any way other than removing default value from parameter to do this Thanks in anticipation. Saeed Sorry, there is no way to achieve this behavior in Report Manager. You need to remove the default value, otherwise the report will render. It is unfortunate that this was not considered as a requirement during development. However, you can work around this by adding an additional report parameter. Add a Start Report parameter as ...Show All

• Ruchits HideMemberIF: Parent vs. Only Child w/ Parent

  Even after reading the SQL BOL definitions, I'm unable to actually demonstrate a real-world difference between the "Never", "ParentName" and "Only Child w/ ParentName" settings for the HideMemberIF property with my multi-level hierarchy on it's ragged dimension. Specifically, my hierarchy simply will not hide a member named the same as it's parent, when viewed in VS's Dimension browser window, regardless of the HIdeMemberIF setting chosen. I've not yet loaded SQL 2K5's SP1, and here are my questions: (1) Could it be that VS's dimension browser and/or cube browser do not support the HideMemberIF property (2) If so, has that changed with SP1 I did not get a response ...Show All

• PeteJM01 linked server can not connect using Named Pipes

  Push Transactional Replication Replication was running fine, we switched one of the servers in the local lan to named pipes. We can still connect to the database with Query Analyzer (QA) and Enterprise Manager (EM) but replication failed. We realized that the linked server on the distributer for that subscriber could not connect. We switched back to TCP and all is well again. We can issue a Net Use \\server\ipc$ with success so it seems the pipe is ok, and we can still connect with QA and EM. Why would the protocol make a difference. Why can't we connect a linked server with Named Pipes when it connects fine with TCP, and why even though the linked server can not connect can swe till connect with QA or EM. ...Show All

• K Sumeet Form based authentication

  We developed ASP.Net portal with form based authentication. We developed reports using SSRS 2005. We have a login page in portal, after user login we have some user interface where user can select the parameters for the report. Based on user parameters we are generating a url such as http://xyz/reportserver Reportname name=tom . The generated url is opened in a new page and report is displayed. As SSRS 2005 implements windows authentication. Whenever we are try to access the url it asking for server credentials. Is it possible to use ASP.Net portal authentication cookie to run the reports without asking for credentials Is it possible to redirect the user, if he types the url( http://xyz/reportserver ReportName name=tom ) direc ...Show All

• RMORAR article row filter - 2 parameters

  hello, i need to filter an article based on a user-supplied datetime filter (the datetime parameter is specified by the subscriber just before replication). at the same time i need to filter again by user (different subscribers get different rows). i already did the user-based filter using HOST_NAME( ). but the difficulty here (al least i think so) lies in passing 2 parameters to the filter. i cannot rely on using SUSER_SNAME to pass the user filter, because no one will want to create 500 user accounts. so i guess the only solution here is to pass both parameters using only HOST_NAME( ) and then write 2 splitting functions which uses HOST_NAME( ) as its parameter. am i right publisher/distributor is sql server 2005, all subscribe ...Show All

• Yassi Task Priority

  Hi, In my Sequence container task, I have 3 data flow task ( one data flow task is based on the constraint option Expression). 3 are running simultaneously, is there a way to assign a priorty which one should finish first before the other starts. If I make all of them in one sequence then the conditional task come in between which may stop the execution of the 3rd task depending upon condition. Please Guide. Precedence constraints define which of them start first. Why are precedence constraints not working for you -Jamie That's a dead link for me I'm afraid!!   So, I'm still not understanding what it is you want to do. If the execution of some task is dependent on some condition then put an express ...Show All

• CodemasterMM using a text editor to open a SQL Database

  is there some way to access a corrupted database with a text editor so that I can copy over my text database to a new database file I apparently have corrupted my file headers of both the online database and my backup copy. Thanks in advance for your help hi, please do not if you really need that data, open a case with your local Microsoft office in order to get all the still available data under PSS support regards Are you saying that you're having problems creating Logins and User Could you be specific about the problems you're having Mike yes the problem has evolved through my experimentation I've managed to clear out alot of the hangups but I still have a problem creat ...Show All

• Wilfried Mestdagh Real size of database

  I have a database which I do not think is really big, but when it was created the initial file sizes where set to very large amounts. How do I get the actual size of the data When I do shrink database, SQL say there is no space to reclaim but when I back it up the backup is extreamly small, does this mean that shrink database will not shrink past the original size How do I resize the database to only the actual size needed Here is the result of sp_spaceused: database_name database_size unallocated space -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ CCCca 99863.81 MB 96318.27 MB reserved data i ...Show All

• dave987432987 Error encountered while starting the SSIS service

  I installed SQL Server 2005 Integration services on Windows XP machine. Then I went to the SQL Server Configuration Manager and tried to Start the SSIS service. The "Log On As" value is "NT AUTHORITY\NetworkService". But I get the follwoing error: The request failed or the service did not respond in a timely fashion. COnsult the event log or other applicable error logs for details. Event Log details: ------------------ The SQL Server Integration Services service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . I tried running the service using the "Local Ser ...Show All

• Gumbatman SSIS Expression result limit of 4000 bytes

  I have a package with an input column that is varchar(8000). I want to strip the first byte off of this column and put it in one result column and the remainder of the field I want to go to a second column. If the input column is an empty string, I want to return NULL. Pulling the first byte off works fine, no issues, however putting the remainder of the input column into an output column is giving me a little trouble. If I use this expression: LEN(FLD1) == 0 NULL(DT_WSTR,1) : SUBSTRING(FLD1, 2, LEN(FLD1) - 1)) I get an error that says my expression evaluates to a string of greater than 4000 bytes. If I do this instead: LEN(FLD1) == 0 NULL(DT_WSTR,1) : RTRIM(SUBSTRING(FLD1, 2, 7999)) The expression passes muster but ...Show All

• jerfoo "!New" Indicator on report

  Is there a way to set how long the "!New" flag is displayed next to a report in reporting services Thank you, Dave Unfortunately no, this is fixed at 48 hours. ...Show All

• Mike V T parameters not updated on re-publish

  RS2005 sp1 - I have a report that was published to the report server. I needed to make changes to some of the parameters. I changed them to be INTERNAL. When I re-published the report from visual studio to the server (selecting overwrite item if exists) - that INTERNAL parameters were still showing and active when I chose VIEW report. Then I tried the Upload File from the report server to see if that would behave differently ... but I got the same result. Can someone tell me why this is happening I am having the same problem, if anyone can help I would appreciate it. I recognize that deleting the deployed report fixes the problem but for a fast paced environment that is not very efficient. We are o ...Show All

• waterking Report Parameters creation via Code

  Hi, I have a report that that needs to be filtered by StartDate, where StartDate is the first day in the week of a specific year. The values will be each week of the year (52 weeks = 52 Start Dates) and the range of years is between 2006 (current year) back to 2003. My questions is how to generate these values for the StartDate parameter. I don't want to define actual database tables to store these values, as it seems like something I should be able to easily generate via some code. After trying it out for while and searching the forum, I'm starting to think I will need to statically store these parameters. Can anyone offer any advice on how to solve this parameter value generation issue Thanks, - Jim ...Show All