Answer Questions

• Sumit Chawla results to string array for reference within CLR Proc

  I keep running into a problem with the debugger freezing up. I'm trying to pull results from a query into an array (not more than 10 rows) cmd.ExecuteReader(); while (rdr.Read() == true ) { letter = rdr[0].ToString(); i += 1; } if I comment out the "letter = rdr[0].ToString();" portion of code, the project runs fine. With that code there, I can not step into the proc from the SQL test script. No errors are raised. VS just freezes. Hi, Were you able to resolve this issue I tried this code and i am able to debug this just fine. Does the problem occur only during debugging or outside of debugging as well (executing the test script without debugging) Are you able ...Show All

• Flashouille scptxfr problems on sql 2005

  Having used the scptxfr utility successfully on Sql 2000, I am trying to use it against sql 2005. I have had mixed results, in simple databases this seems to work ok however in complex databases the utility appears to hang, has any one had this problem or knows of a workaround Scptxfr.exe was a tool included with SQL Server 7.0 and 2000, but not with 2005. One option I've heard people using is located here: http://www.codeplex.com/Wiki/View.aspx ProjectName=sqlhost&title=Database%20Publishing%20Wizard Thanks, Sam Lester (MSFT) The tool probably works great in some situations with SQL 2005, but is not included with the product and thus not supported. I'd suggest trying some of the other s ...Show All

• Joeku Problem with MDX query using date range from Date dimension table.

  We are facing problem with MDX queries using date range. We have a Date dimension table populated with dates from 2005-01-01 to 2020-01-01 Date dimension table contains dateid as the primary key, which is associated with dateid column of fact table. Following is our MDX query: WITH MEMBER [DATE].[Date].[DateRange] AS AGGREGATE ( STRTOMEMBER(@startDate) : STRTOMEMBER(@endDate), [Measures].CURRENTMEMBER ) SELECT NON EMPTY { [Measures].[PRODID Count] } ON COLUMNS, NON EMPTY {[PRODUCT].[PRODUCT NAME].[PRODUCT NAME]} ON ROWS from [PRODUCT] WHERE ([DATE].[Date].[DateRange]) where startDate and endDate are my query params. startDate=[DATE].[Date].[All] endDate=[DATE].[Date].[All] We have data from 2005-01-01 to 2005-01-31. If we give startD ...Show All

• FredDabb E-mail notification issues

  I just set up an SMTP email account though the Management Studio a Server a Database Mail. The test email was successfully delivered to my mail box. Now I’m trying to test the notifications. I created an Operator with my email address, and my test job is set to email the operator when the job completes using the email account above. However I am not receiving any emails upon the completion of the job. When I go to notification history under the Operator, there is none. What am I missing Thanks a lot for your help! LoveDanger wrote: I just set up an SMTP email account though the Management Studio a Server a Database Mail. The test email was successfully ...Show All

• Anna Vanyukova ACT! and SQLsmbiz server

  I honestly have no idea what I even need to ask here but bear with me. I had ACT 3.0 installed on my Dell Inspiron notebook. MS Professional with SP2, MS Small Business and MS Small Business Accounting. I use Outlook with Contact Manager too. As ACT 3 is old and not really useful to me now I wanted to upgrade to ACT 2006! Before so I and without knowing I shouldn't have done so, I "uninstalled" ACT 3.0. Or so I thought. Installation seemed successful with ACT 2006 except I am not able to either build or open any database or demo database. Get message relating to no Master something". Tried to uninstal ACT 2006! but unable to remove all components. Long story short I called ACT and after paying $199.00 for a service agreement ...Show All

• Azriel Cross Using variable in MDX query for Time value

  {[Time].[FiscalYear].&[2007] } * { [Measures].[YTD Actual], [Measures].[Prior YTD Actual] } This is what we currently using in our MDX query but it returns the entire year instead of a true YTD value. The problem is we don't know how to determine what is the current YYYY-MM in MDX environment, like what we can do with Getdate() in SQL. Is there a way to let query self-determine YYYY-MM during run time Hi Julius, The problem lies with the expression: Time.FiscalYear .CurrentMember > VBA!Now(), The infinite recursion is due to your not mentioning a measure in that expression, so Time.FiscalYear .CurrentMember returns the value of the calculated measure you're actual ...Show All

• HowardRoark Invalid Character in Flat File or Turncate problem

  My source is a csv flat file. Currently I use that same flat file on SQL 2000 and SQL 2005. On SQL 2000 it runs fine and it inserts that character as part of the string (varchar), however, it gives me truncate error on sql 2005. I already use the "Suggest Types...." and my Output columns have the correct lenght (specially that lehght of that column is only 30 char which is less than the default anyways). If I remove that character it runs fine for that column..... This is the values that I get in my flat file for the trouble coulmn is "ATTN: JON OLSEN a€“ CTRL8 " And the error that I get when running the SSIS is [Flat File Source OrderDetail [1]] Error: Data conversion failed. The data conversion for ...Show All

• Leon94 How to update a dimension column with the pipeline tasks

  I have been working with DTS and ETL in data warehousing projects for several years and my question is this. You can only update a dimension column with SSIS by using TSQL-update statements. There is no way to do this except issuing TSQL from the control flow or the data flow This subject is not mentioned in Wrox SSIS book nore in Kirk Haseldens book. When you run the SCD task in the data flow you will get an OLEDB command that actually do this, issue a TSQL-statement. Is this correct Regards Thomas Ivarsson Correct. If you're looking to perform an update, SQL will have to be executed. It'd be nice to have an update data destination, eh I agree. Never aim at a moving targe ...Show All

• MartinBo DB mirroring + load balancing

  Is it compatible to set up SQL DB mirroring on 2 different physical servers (High availbility + FULL transaction safety + Automatic failover with a third server as witness) and simultaneously set up network load balancing between these 2 servers (option with Windows Server 2003 Enterprise) If yes, which type of licenses do I need and how many (for SQL server 2005 and Windows Server 2003) with such a configuration - 4 physical servers in total : A, B, C and D - load balancing between A and B (same application) - load balancing between C and D (same application) - A hosts principal DB X, B hosts mirror of DB X - C hosts principal DB Y, D hosts mirror of DB Y - D is witness for A and B - B is ...Show All

• jpcesar SP2 Integration mode kills Sharepoint Central Administration

  Hi I had the following setup: Farm Server 1 * Sharepoint 2007 full install Farm Server 2 * SQL Server 2005 I installed the following: * SP2 for SQL Server 2005 on Server 2 * Web-front end install of Sharepoint 2007 on Server 2 - to install the object model * SSRS2005 reporting services add-in for Sharepoint technologies on Server 2 Since doing that, I can no longer get to central administration on Server 1 - I now get the following error when navigating to central admin: Server Error in '/' Application. Can you try the options I suggested on the following thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1282744&SiteID=1 thanx, Prash What is the authentication mode you have set in the Manage Integrated ...Show All

• C#noob Creating UserInstance DB at application startup

  Hi, I'm developing a WinForms app that will be deployed via ClickOnce deployment and that uses SQLExpress as a local data store. In order to avoid the upgrade DB problem, I'm having my application check for a database and check its version on startup. I am able to successfully create the database if it does not exist, but when I try to connect to the new database, I get a login failed error. However, if I restart the app, it is able to connect to the newly created instance. Here's what I'm doing: If the db does not exist, I connect using this connect string: Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True;Connect Timeout=60 I then issue a CREATE DATABASE command and run my table scripts. I then try to reconnect as D ...Show All

• Paulustrious [Execute SQL Task] Error: An error occurred while assigning a value to variable...

  hi chaps i m getting the following ERROR: [Execute SQL Task] Error: An error occurred while assigning a value to variable "JDETimezone": "Unable to find column Timezone in the result set.". i know what the problem is i.e. no row is returned then what is the problem here you are.... i want to it work... strange... ok i explain... actully i have some processign to do with variable JDETimezone even no row is returned.... can u tell me the alternative to do the follwing task... I want to retrieve a record from some table and do some processing and if no row is present or returned then i want to do seperate processing.... can ne one help me out regards, Anas That error usually occurs ...Show All

• Anonomuys Eventlog

  Hello everybody, is it possible to add entries to Windows EventLog from Sql Server Trigger if yes, could any body tell me how Best Regards REQUIRES EXTERNAL_ACCESS or UNSAFE CAS Permission Sets on the assembly: catch ( Exception ex) { //log failure to local machine's event log EventLog oLog = new EventLog ( "Application" ); oLog.Source = "usp_ProcessResumes" ; oLog.WriteEntry( "usp_ProcessResumes failed to execute on " + System. DateTime .Now.ToString() + " The error message was:" + ex.Message.ToString(), EventLogEntryType .Error); //return error message to client SqlContext .Pipe.Send(ex.Message.ToString()); } ...Show All

• AndyJ_PS Calculated Cell

  Some calculated cells need to be migrated from Analysis Services 2000 to 2005. In 2000 we have them only on a single cube. In 2005 we are migrating the entire database as a cube and the cubes within 2000 are implemented as perspectives in 2005. Is there any elegant way to ensure that the calculated cells do not affect other cubes(perspectives) in 2005 ...Show All

• WQP Trying to return whole records with distinct fields

  Hi I am trying to write a query that will return a full record with a particular distinct field (the rest of the record being the first such record that includes the distinct field). For example, for the following: Fruit Like Colour Apple Y Green Orange N Orange Banana Y Yellow Grape Y Green Grapefruit N Yellow I would want to return (assuming Colour was the distinct field): Fruit Like Colour Apple Y Green Orange N Orange Banana Y Yellow How do I do this I've tried using a join (of all different kinds) with a subquery that uses SELECT DISTINCT but this doesn't seem to work. I've tried GROUP BY but none of the aggregate functions seem to just take th ...Show All