Answer Questions

• qjay Identity column not returnd after AddNew / Update with ADO and SQL 2005

  Hi, I add new records to a table with ADO. The tables contain an auto-increment identity column. I want to retrieve the identity value after the insert operation. This works fine for SQL Server 2000. On SQL Server 2005 this only works if I use a table in the select statement. If I use a view in the select statement, ADO returns no value for the identity column, a trace with profiler shows that there is no Select @@IDENTITY statement. What is the reason for this behavior How can I change this behavior in SQL 2005 so that the behavior is the same as in SQL Server 2000 Best regards, George Sorry if I resume this old post. I have the same exact problema, but I wonder if this is a documented ch ...Show All

• __ButterFly__ Restart Sql Express from sqlcmd

  Is it possible to restart the Sql Express engine from the sqlcmd utility Thanks You could either use the command prompt which uses Net stop "SQL Server (MSSQL$Express)" AND Net start "SQL Server (MSSQL$Express)" or wrap that in the xp_cmdshell procedure if you have activated that. HTH, Jens SUessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• ryan101 Predicting player win over a period of time

  I would like to create a simple regression equation to predict player win on their next trip. I have tried to create the model using a linear regression tree based on two players (as a test). The result gives me a single node (expected) with only a coefficient instead of a regression equation. I can do this math by hand to get a regression equation and predicted value for the next trip for each player. The dataset I used for a simple test is..... Trip # Player Win 1 1001 1,250 1 1002 50 2 1001 1,450 2 1002 75 3 1001 1,600 3 1002 100 4 1001 2,000 4 1002 175 I also tried to predict next trip worth u ...Show All

• MarcoB simple text processing e.g. regex search and replace

  I've got an nvarchar(max) column that I need to transform with some simple text processing: insert some markup at the very beginning, and insert some markup just before a particular regular expression is matched (or at the end, if no match is found). Since the SSIS expression language doesn't support anything like this, is a Script Component the only way to go Does Visual Basic .NET provide regular expression matching Thanks! there is no need to use a script component or create a custom component because microsoft already provides a regex component for ssis: http://www.microsoft.com/downloads/details.aspx familyid=c16f11ad-150a-4091-b3a2-83d21d3e0973&displaylang=en Kevin Rodgers wrote: Duane ...Show All

• bjkaledas Time Dimension Browsing Very Slow - ProClarity

  Hello, I have a problem when browsing the time dimension (when cube cells have values) I have a standard time dimension with the following levels Year-Quarter-Month-Day. My cube has values for the years 2003 .... until 2006. 2002 Does not have values. When I browse the time dimension for 2002 (the year where cube has no values), I have no problem..but when I browse the dimension for values in the other years.... I wait until 1 minut to make a drill down in the dimension Pane (whitout executing the query). PS: I notice in SQL Server Profiler, that each time I browse the dimension in ProClarity, all my 80 partitions are read in the OLAP Server....without executing the query. Thanks in Advance Joao Campanico ...Show All

• vtortola Reports running automatically when all parameters had default values

  If all the parameters for a report have default values, the report runs automatically as soon as you open it. Is there a way to prevent this The point is that I WANT to provide defaults for all parameters but I DON'T want the report to run automatically. Hi, Remove the default values of the parameters in the report or in Report Manager.Set the default values for parameters in Stored procedures. Thanks, Will give that a try. Do the default values still show up in the Reporting Services client I guess I will find out when I test it. There is another issue with this solution, I am using a table valued function that is p ...Show All

• Jurgen Meijer How to manage all the SqlNK versions at the same time?

  Hi everyone, Nowadays, we've got four sql versions running around: 6.5, 7.0, 2000 and 2005. If you try attach from Enterprise Manager 2005 servers it doesn't allow you because of 2005 uses SMO instead of DMO. If you try attach from Management Studio 6.5 or 7.0 servers it doesn't allow you too. We'd like to have from the same place a tool for all of them. Is it possible Thanks in advance, Hi Staya,   I meant, when you do this action: "New Sql Server Registration" from your client. Yeah, I know, I can open three clients in my own workstation without problems. I'm talking about that you can't attach from your Management Studio (2005) 7.0 or 6.5 clients. Beyond of this, from Enter ...Show All

• kampak1111 Report parameters being searched for after they have been removed from all visible interfaces

  I've been building and testing my reports and have found that if I decide that a report parameter should be removed, removing the parameter causes the report to fail. If I remove a report parameter via the 'Report Parameters' menu, and I also remove the associated data dimension, filter expression and parameter check boxes, when I preview the report I get an error message. It appears the report is searching for the old parameter name even after it has been deleted. This leaves me with the option of either restoring the parameter as it was, or rebuilding the report from scratch. I've done some investigation and the parameters seem to exist within the XML code that underlies the report despite the parameters being deleted. Is there ...Show All

• dobauer SQL Server 2000 Query Problem

  I'm having trouble coming up with a query in SQL Server 2000. Trying my best to sum it up in one sentence; I need a result set that for every EventID/StartDate that exists in tblEvents, I need all StartDates within x days to have a minimum sequential, unique number starting at 1. Now I'll go into some more detail and possibly confuse everyone. What I have is a table of events that to simplify this question include only an EventID and an StartDate field. What I need to do is for each event, find the other events that occur within x days after the event in question. I then need to number the events starting at 1 so that each eventB that occurs within x days of EventA has the minimum number different from any events from the past x days. I ...Show All

• Nicolas Dupras Removing Mobile Edition BOL

  I'm hoping that someone has any ideas on this. I want to completely strip the entire Books Online module for SQL Server Mobile Edition. Why It gets really irritating when I try to look up topics and it always yanks up stuff from the Mobile edition and I could care less about those. There are entire sets of topics that BOL will do nothing but pull up the Mobile edition topic which is completely irrelevant for other editions. Hi Michael, The scripting error you're getting occurs in some scenarios when SQL Server 2005 BOL and the MSDN Library are installed side-by-side. I was told that this error was fixed in the April refresh of SQL Server 2005 Books Online. Updating your version of Books Online to the April or July refresh from h ...Show All

• Ian_E SQL Configuration settings being ignored?

  I am sure I'm being blind here (it wouldn't be the first time - and won't be the last time). I have a package that retrieves some values from SQL table to allow me to dynically create an email message, so it retrieves To Addresses, From Address, Header, Body from a table, populates variables, and uses expressions to assign those to the SEND MAIL TASK. That is working (after a bit of head/wall/banging to get my default virtual SMTP server running locally). Now I am trying to make the SMTP Server Name dynamic. The Property SMTPConnection specifies the SMTP Connection Manager to use, and not the server, so it doesn't seem as though I can configure a property on the SEND MAIL TASK to achieve this. Now I'm focussing on using SQL Package Configu ...Show All

• Dangerous Dan The connection manager 'OLEDB' is not properly installed on this computer

  Please help someone from MSFT! I've just finished installing the Sep CTP on my laptop.  I previously had the April CTP and June CTP.  I followed the instructions for removing a previous installation of SQL 2005. Now, when I try to create an SSIS package, I get a message that says: TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL INFORMATION: The connection manager 'OLEDB' is not properly installed on this computer. (Microsoft.DataTransformationServices.Design) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.24&EvtSrc=Microsoft.DataTransformationServ ...Show All

• blue_devil Using calculated members in RS 2005

  Hi everyone... This is my first post here... Well, I got a problem with a calculated member I have created in a cube.Its based on "Percentage of Parent" template. I'm trying to build some reports for a survey and I have data about the profiles of the users (that is I know the answers of each user and I have data about their living region and prefecture). FactAnswers : AnswerKey, PrefectureKey DimAnswerKey: AnswerKey, AnswerName, QuestionKey, QuestionName, SurveyKey, SurveyName DimPrefecture: PrefectureKey, PrefectureName, RegionKey, RegionName Measure: Surveys Count Actually i use snowflake schema but for simplicity's shake I'll describe the problem using the above star schema. In order to get the percent of Answers for eac ...Show All

• Duane Haas Using Configurations Class within Script Task

  How do I access the configurations collection of a package within a Script Task component Is there any sample code anywhere Thanks! I was hoping to read the config PathFile location information from it to set to a variable. THX. You set SSIS configurations as part of the package definition, and the ability to set a variable value is a perfect use for them. Go to the Package menu, and select Configurations to set this up. Not possible from what I can see. You are no longer allowed to access package objects as you may have done in DTS previously. I cannot see why the configurations would be of use anyway, they are essentially done with by the time any tasks ex ...Show All

• Ravencraft Using SQL Server 2005 Express in a Windows peer-to-peer workgroup

  Does anyone have a experience or links to resources for implimenting SQL Server 2005 Express in a Windows peer-to-peer workgroup Thanks. connection string is the same that I am using. Is the SA user enabled the SA account is disabled by default Hi Matt I got peer-to-peer connection problem as well. I am using C#. I used connection string as below: Data Source=Tara\SQLEXPRESS;Initial Catalog=ContentDatabase.mdf; User ID=sa; Password=mypassword Tara is the computer name, the database is on Tara computer. I did surface area comfiguration, selected local and remote connections: TCP/IP only set sql browser auto start. add sqlbrowser.exe and sqlservr.exe in the exceptions of windows firewall. Als ...Show All