Answer Questions

• Menthos Probem in using the Copy Database wizard

  I am trying to migrate from  Sql server2000 to Sql server 2005 with the help of Copy Database Wizard of 2005. It is failing in the Last step. That is when executing the Sql Jobs.Could any one help me out Thanks Ram Vajrala I also have the same issue and I am using the Attach/Detach method. I also have SQLServiceAgent Service Started and Automatic. It still fails on the last step. In addition, I would like to know how I can delete the saved SSIS package that the Copy Database Wizard has created. I also want to know how to modify it but since I can't get to it, I can't modify it. I can see the job and according to the information that the job has given me the Package Source: SQL Server ...Show All

• CodeDjinn TRyign to extract Top 3 records using Partitioning

  Hello, I have a table containing 3 columns Department Name, RiskScenario and Cost. I am trying to create a data extract that contains the top 3 Risk Scenarios (sorted by Cost) per Department. I tried using this sql statement in MSQuery but it doesn't work. Any ideas where I'm going wrong or if there is a simpler way to do this Select * from ( Select DepartmentName, `Risk Scenario`, Cost, row_number() OVER (PARTITION BY DepartmentName order by Cost) rn FROM 'Departmental Risks`) where rn <=3 Please help. Just can't figure this out! Meera yup. rank() will also give you the ties. Yeah - you just need to name y ...Show All

• ondrejsv For Each across list of databases

  I need to get records from multiple databases. In my main database, I have a list of databases related to seperate business units. For each of those databases, I need to get a list of values from a table (the table exists in each database). Basically foreach database in a list Do a Lookup end Possible The option I would consider would be to put a Data Flow Task in the PreExecute Event Handler of the For Each Loop Task to loop through the databases you need to access. First, parameterize the Connection String of your source main Data Flow DB source (not the Event Handler DB source) with a variable. Here's an example of what I'm doing within an expression for the ConnectionString: "Data Source=" + @[User::masterServ ...Show All

• John123 Gantt chart in SQL reporting service

  Hi all, I need creat a gannt chart for project server report in SQL reporting service. Is somebody know some good third party tool can help to implement or how to creat by hand Thanks in advance! Thanks Jasper! But Dundas chart is a little bit expensive solution for us. It supports SQL 2000 reporting service I downloaded the Dundas Chart for Reporting Services and try to create a Gantt chart. I found it's very difficult to do, as there're many settings on it. Is there any tutorial provided Thanks! I use Dundas Chart for Reporting Services and can thoroughly recommend it and it supports Gannt Charts ...Show All

• Bogey1 Unable to connect to SQL server database

  I recently installed VS2005 Prof edition and SQLExpress 2005 and have been teaching myself C# using the book Microsoft Visual C# 2005 step by step. I have done all the examples including the examples on databases without problems up to chap 27 which is trying to demonstrate adding security to a web site using the ASP.NET Web Site Administration tool. After opening the tool and clicking on "security" the error message appears. Unable to connect to SQL server database As I understand it a database provider AspNetSqlProvider is supposed to create a database called ASPNET.MDF in the App_Data folder of the web site. Needless to say nothing is produced. I have read various posts and done the following without success. ...Show All

• Terry B Report footer doesn't export to excel

  Hi, I had developed a simple report, that has header, body and footer. In footer i have copyright. Now the problem is that, when i export it to excel the copyright text i had in the footer doesn't export. any one had any idea. Chinna. Thanks Geoff, Ya, i had checked that, i does displayes in preview. why can't in normal view! Footers always appear in the actual Excel Header/Footer section, not in the report body (as headers do by default). Did you check View -> Header and Footer in Excel If I'm understanding you correctly, the footer is there, but it's not being shown in Excel on the normal view. This is just the way Excel works, and is not RS specific; page headers an ...Show All

• Mike Thurber Inserting row with single quote

  I'm inserting a row of people's names and addresses to a table. This seems to work great, unless the person has ' in their name, for example O' Riordan. When the address has single quote (such as Wilder's Path), I'd get the same error, unclosed quote when inserting the row. What would be the best way to work around this, other than read the line and replace it with a space. Sorry.. after looking thru the website i still dun know how cause my sql statement is like that.. String query = "INSERT INTO addresses (" + "company, address, name, hp, " + "phone, fax, email, start, day, month, year, " + "mrc, isp, des, sa ...Show All

• VTG35MBA Relationships in Management Studio Express connected to SQL Server Compact Edition

  Hello , Is possible to specify reationships between tables on SQL Server Compact Edition database in Management Studio Express I can connect to database file , add tables, add data , but I dont't found the right methot to specify reationships as with SQL Server Express. Any ideas Thanks Erik for the information. I know it can be done in code, I was hoping to find the complete table designer in the ce edition. I understand that it's not there. Apparently 'lightweight' refers not just to the product's functional capabilities, but also its development tools. You have to specify the relationships in the query analyzer, like this: ALTER TABLE MyOrders ADD FK_CustOrder FOR ...Show All

• austriana Queue activation context

  Is there any way to identify the context by which a stored proc has been activated. i.e. I want to use the same sp to end conversations on receipt of the end mesage from the target. However I don't know how to find out which queue activated the SP. See this previous thread on the topic: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=752317&SiteID=1 HTH, ~ Remus ...Show All

• JD Li Changing SID of a USER

  Hello can anybody out there help. I am just getting ready to move a system to production using SQL 2005 and SQL Mirroring. The problem that i have is when the databases fails over my connection string user account losses its rights on the DB untill i run the SP_CHANGE_USERS_LOGIN script. I have been trying to come up with a method of getting around this so far the only fix that i have is to make my user account sysadmin but this is far from ideal for production, does anyone have any ideas i was thinking that changing the SID of the User so that they match might get over the problem. Any help will be good Matt. Thanks that has sorted the problem. Matt ...Show All

• terryhohoho Transaction Rollback Issues

  Hi We are loading data from one extract file in to 4 different database tables. When we are loading if the first table gets loaded without any issues and the second table loading gives any issues, we need to rollback the data loaded in to the first table also. In the package for achieving this, we are using Sequence container. In the sequency container we are having 4 different tasks for loading data to 4 different tables from the same extract file. We also tried setting the different transaction options given in the properties box of the packages, container and tasks. Also we tried the properties by setting as mentioned in the Test# 7 and 8 in the following URL http://www.sqlservercentral.com/c ...Show All

• Peter Cwik Creating Dimensions

  I have a cube with a dimension 'Destination', that has the follown herarchy. Country -> State -> City. As measure I have Number of transactions. When I browse the cube I can get the total transactions if I expand all the levels, but If I just want o have number of transactions by state or country the cube is no creating totals by those levels. Even in the cube when I expand all levels (including city), there are not totals by state and country. What I am missing You can email me to jzuluaga@msn.com or jzuluaga@quisqueyana.com Thanks Juan, What are you using to browse the cube Steve Check the calculations of the cube and make sure that it contains the CALCULATE command. ...Show All

• Roger Jennings HowTo: read/write package level variables in custom task

  Hello all, I have been struggling trying to read and/or write package level variables from within my custom task.  I'd like to be able to get and set values from within the Execute method of my custom task.  I have searched this forum and the books online and can't seem to find the answer.  I thought maybe I could use an expression on my task (mapping the package variable to a custom task public property) but that doesn't seem to be working for me.  I also would have thought I could use the VariableDispenser object from within my task but the collection is empty.  I have 3 package level variables configured and can't seem to find a way to access them (with intentions of getting/setting).  Cou ...Show All

• Sujithf multivalue parameters - is this possible ??

  i am trying to build a report that uses multivalue parameters - the report is a simple listing report that lists out a list of cases as a table - the data is obtained from a view which just returns all details for all cases there is no user input for the selection details - am going to be calling the report and passing over the parameter values directly to it. there are several parameters for the report - they all default to "All" for each of these parameters, i need to be able to either use the default value of "ALL" or to enter a list (comma separated ) q1) could i just enter the list as a string comma separated list (rather than as multivalued parameters) and then use this list to filter the data usin ...Show All

• longint replace value of (sq:variable("@variable")) with ""

  replace value of(/node/sql:variable("@varname")/@Status)[1] with "pass"' gives me The XQuery syntax '/function()' is not supported. Is it not supported If it is not supported what is the best way to update a specific node out of many based on certain criteria like update Student Grade to A for Student node with name "John" and not any other, without having to use dynamic SQL. Tim reproducing answer to this by Pohwan on another discussion alias. This is exactly what I wanted and it works if somebody else is in is same boat ***************** Workaround, /node/*[local-name()=sql:variable("@varname")]/@Status instead of /node/sql:variable("@varnam ...Show All