Answer Questions

• Muna Header Rows to Skip on Flat File Import/Export

  Just attempting to import a simple tab delimited text file into my SQL Server 2005 database using the SQL Server Import and Export wizard. Column names are specified within the first line of the file. The Header Rows to Skip field value is listed as 0, but the wizard indicates that "The field, Header rows to skip, does not contain a valid numeric value". Why isn't zero (0) a valid numeric value I don't want to skip any rows. PLUS, I get the same error when trying to export to a text file although the header rows to skip field does not exist. I can increase the number to 1 or more, but the wizard will skip part of my data .. unacceptable. What am I missing here I installed SP1 of SQL server 2005, but that did not help. ...Show All

• SanthaMind Can see Service Broker queue with SQL Server Login

  I have an application that is reading a message from a Service Broker Queue. When I use integrated security with an NT account it works fine. When I use a SQL Server User through Management Studio I can select from the Queue however, when I use this same account through the web app with the SQL Server User, I cannot see the Queue. Is there a grant that I must do to this account to get it to see the Service Broker Objects Gary Service broker doesn't use any special security/access checks other than the normal SQL Server security/ access restrictions. If the queue is visible from the SSMS, but not from the Web app, it means that the Web app it connects with different settings/credentials than the SS ...Show All

• danskcarvalho Select problem

  hi ppl, is there any way to make a variable query i mean something like this: UPDATE Productos SET existencias = ' select existencias from Productos where codigo = 014633148411 ' -5 ' i want to update the column existencias by selecting a qantity and susbtracting 5,,, i mean,,, i have a coluumn with a number, and i need to substract and add constantly, so i dont want to make 2 querys,, 1 for select and get the qantity, the process data and then updating the table with the new value,, i want to do it on the same query mig16 I am not quite clear of your explanation, perhaps you can define your problem a bit more detailed, the above query would be syntax corrected something like this [1], buit I don’t know ...Show All

• maddinthegreat When To Use A Function And When To Use A Stored Procedure.

  Hi, I thought that procedures do not return a value: well they only return a 1 or 0 depending on whether the procedure executed correctly. Functions are what you're supposed to use when you want to get a result set of some sort: ie a table or a scalar value. Apparently that is not the case becuase you can return values from procedures. I've attempted to find out what the differences are between the two and when it is appropriate to use a procedure and when it is appropriate to use a function but I'm still unsure. Can someone please tell me the difference. Thanks. Przemek Yes not for performance but usage. So it sounds like to me that this is not a performance ...Show All

• Perley Built-in db_execute right

  I noticed you are taking suggestions for SP2 release of SQL 2005.  One thing that would be nice would be a built in security role of db_execute that would give execute rights to all stored procedures in a database and/or db_executeUser to execute only user stored procedures in a database.  It would simplify releasing for me.  I always seem to forget to give the user account rights to execute everytime I add a new stored procedure.   Thanx, Actually, there is a way to do this in 2005. I missed it through several passes of learning the security infrastructure and it's a pretty neat capability. The first thing to understand is that you grant permissions on a securable to a principle. Once you've gotten the ...Show All

• thukralz Incorrect error Message while updating partition key of a Partitioned table that has indexed view

  Hi all, I have a Partitioned table like this base_table( id int identity(1,1) primary key, .. ... topparentid bigint , ... ) I have a range partition with partition key as topparentid. I have a clustered index on topparentid. Note that indexes are not partitioned in this table. we have a Indexed view like create view indexed_view as select id,.... topparentid ... from base_table there is a unique clustered index on the id coulmn of the view. Now, when I tried to update the base_table topparentid value i get a following error cannot insert a duplicate row in view "indexed_view" with unique index "<index name>" This error does not happen for a ...Show All

• CarlDemelo Is it possible to prevent user to edit parameters in adress bar?

  I have reports in report server which are accessed by url access with parameters. When the report is generated the whole url string is displayed in the adress bar with parameters. Is there any way to prevent the user to change the parameter value Any ideer whould be very appreciated! You could use a html form and use POST instead of using GET via the url. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=301748&SiteID=1 ...Show All

• CJ Patrick Display a KPI need the same Dimension on its Value and Target?

  I mean, I have a KPI, it's value is set to a measure of a measuregroup based on a facttable A. and it's Target is set to a measure of another measuregroup based on another facttable B. Now I want to display the KPI, with a given dimension's slice. My question is, is it needed that the dimension I chose must be shared by both the measures of KPI's Value and Target For an example, If I dispaly the KPI with the Promotion Dimention, and the Promotion Dimention has a relation to the KPI's Value's related measure(There's a PromotionKey column in facttable A; ), but it has no relation to the KPI's Target's related measure(There's NOT a PromotionKey column in facttable B). Could I do so I think this is SSAS question. I moved ...Show All

• Freakazoid Dropdown won't show values if only one item is available

    ...Show All

• Michael Morris Passing Command line arguments from Visual Studio

  Hi all, Is it possible to pass command line arguments to a package when running it from within VS I want to set the value of a variable via the commandline, and found that you can to this in DtExec with the "/set \Package.Variables[...].Value;..." syntax. According to the docs, you should be able to pass the same argument via the 'CmdLineArguments' property in the 'Properties' dialog of an SSIS project in VS ( CmdLineArguments . Run the package with the specified command-line arguments. For information about command-line arguments, see dtexec Utility ), but unfortunately, this doesn't seem to work (even though the exact same argument does work when entered in DtExec) Any help would be greatly appreciated :-) Steven ...Show All

• ejm3 Unequal operator with GUID

  Hi, Trying to create a conditional split on GUID. As simple as GUID1 != GUID2. According to BOL this is supported: (Quote) The expression set, expression1 and expression2, must follow one of these rules: .... - GUID. Both expression1 and expression2 must evaluate to the DT_GUID data type. (End quote) However, when I do this, I get yhe following message: (Qoute) The data type "DT_GUID" cannot be used with binary operator "!=". (End quote) So, in BOL it's explicitly possible, the error message says not. Of course I can work around it by converting to string, but I need to use this pretty often and would prefer not to convert to string every time. What's the story here BTW, I am on 64-bit ...Show All

• YvesR dmp file to mdb

  Can anyone possibly tell me how I would go about importing a database from a dmp file Hi Kevin, As far as I am aware the file is a SQL .dmp file but how do I go about doing the restore. I tried yesterday with the restore tool supplied with SQL and recieved an error as a result Thanks for your help, Graham What is the source of the dmp file If it's a SQL backup, you just do a restore. Otherwise, I'll need to know more about where the file came from. Hi, can you give more info: [1] WINDOWS VERSION [2] SQL VERSION/PATCH [3] dmp exact filename [4] Exact steps you perform [5] Complete error description also do you know with what version/patch was the dmp file made Hi JD, I ...Show All

• Dennis Mulder - dennismulder.net Parse dataset in report

  I am using a "jump to report" that accepts multivalue parameters for fiscal periods. It works fine, returning the correct data. However, I want to add the chosen fiscal periods to the report header in a textbox. When I use =Join(Parameters!DATEfiscalperiod.Value, ", " ) the results in the textbox show as: [DATE].[fiscal_period].&[5], [DATE].[fiscal_period].& When using:: =Parameters!DATEfiscalperiod.Value results in [ rsInvalidExpressionDataType] The Value expression used in textbox ‘textbox5’ returned a data type that is not valid. Is there a way to parse the dataset to only return "5, 6" in a string TIA ...Show All

• David J. Roh How to show no rows on a table populated by a mdx query?

  Hi, I have a multidimensional dataset (mdx) that is populating a table... the mdx has a TOPCOUNT statement and there are some parameters that doenst return rows so the dataset gets created on runtime and some of my output columns tend to disappear... My table has the No Rows especified but the problem is that in the table rows i use fields that normally would be there but if no rows detected then the dataset doesnt create the column... How do i resolve this issue Best Regards, Luis Simoes ...Show All

• mrmckeb update variables with scripting task

  Helo, I'm using a simple scripting task to update the value of a variable: Public Sub Main() Dim EndeJahr As String EndeJahr = InputBox("Text") Dts.Variables("EndYear").Value = EndeJahr MsgBox(Dts.Variables("EndYear").Value) Dts.TaskResult = Dts.Results.Success End Sub The Package is working fine and the message box shows the actual value. My problem is that when I change the of value of my variable, the value of variable is not changing, when I restart my package!!! What's the problem any ideas Yes, the message box shows the new correct value. If I close the message box and then right click==>variables I see the old value again. strange... I was abl ...Show All