Answer Questions

• danych What permissions to give Cluster account in SQL

  Hey guys. I'll have an active/active cluster and seperate accounts for SQL Services and Cluster service. The question is what rights should the cluster account have in SQL if I've removed the 'builtin admins' from SQL Thank you The cluster account must be in a domain group, which will automatically have previlege of "builtin admins". This is due to a security problem as "builtin admins" still not strong enough to protect cluster services. See BOL for more details. ...Show All

• xavito Cube deployment issue SSAS 2005

  Hello all, I got an issue with deploying my cube. I am new to SSAS 2005, and I cannot find the option to define which account to use with deploying. I managed to choose the server for deployment, but strangely enough, no user can be selected, so when it deploys, it throws an error stating the standard windows login isn't valid (wich is correct, but I do not want to use standard windows login). Thanks, that answers my question about how these cubes are being stored. :-) Is it suffice when I get those rights only on that particular directory where the cube is stored Well, I made an account in SQL Server 2005 with the same name (as windows login) to my network account, and ...Show All

• bm0061 How to conditionally create Flat File Destination for Lookup Redirects

  Hi all, I am redirecting the critical lookup errors to the flat files. These flat files got created regardless if there are lookup errors or not. Is there a better way to conditionally create them only when there are lookup errors Thanks. Its not really possible, no. What you could do is count the number of records (using a ROWCOUNT component). Then, probably in the OnPostExecute eventhandler for the data-flow, delete the file if the rowcount is zero. Or you could push everything into a recordset destination and then, in the eventhandler, push the stuff into a flat file IF the rowcount is greater than zero. -Jamie ...Show All

• Douglas Nakamoto Vertical Line in a bar chart--Urgent

  Hi, I have a simple bar chart in which i need to draw an average line vertically across all the bars. Is this possible in RS 2005 Do i need any other components Thanks in advance. the only way that i know how to do this is with vertical gridlines http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=627824&SiteID=1 but its not very easy and comfortable if ur chart is a horizontal barchart, you could use a new Datafield with your average value and draw it as line ...Show All

• kangalert populate catalog Full Text Search SQL 2005

  Hi To All I'm trying to populate catalog in SQL 2005, but it doesn't work because in tables there are ntext fields. In SQL 2000 it works normally. I've made some test in both sql server. Why Is there something to set in sql 2005 Thanks Bye Is the problem that the catalog is not populating or you are getting an error when creating Can you post the script Yes ok ... the problem remains ....I can't change the columns in nvarchar(max) tnx for answers. I can't find the menu option (properties) from where I can populate an existing catalog in SQL Server 2005. I had a similar problem when I was c ...Show All

• Elishky Indexing XML

  I have an table-valuated function with XML as parameter. I generate table from that XML. Here is an example of parameter: <root> <an> <anid>5433</anid> <tix>64</tix> <dataid>43</dataid> <datavalue>bc84</datavalue> </an> ... </root> function body begins with: WITH X(anid, tix, dataid, datavalue, cnt) AS ( SELECT new.col.query('./anid').value('.', ' nvarchar(100) ') as anid, new.col.query('./tix').value('.', ' nvarchar(100) ') as tix, new.col.query('./dataid').value('.', ' nvarchar(100) ') as dataid, new.col.query('./datavalue').value('.', 'nvarchar(100)') as datavalue, cnt = ( SELECT count(*) as cnt ...Show All

• shareeef Using OPENROWSET for csv files

  I have 2 instances of SQL2005 running on the same server. I'm trying to use openRowset to get data from a csv file. This is the query. SELECT * FROM OPENROWSET ( 'MSDASQL' , 'Driver={Microsoft Text Driver (*.txt; *.csv)}' , 'SELECT * FROM \\share\file.csv' ) The query works fine on one instance, but not the other. On the other instance I get this error. OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Text Driver] System resource exceeded.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)". Any help would be greatly appreciated. ...Show All

• TechNoFear Setting width of parameter text box?

  Is there a way to set the width of the parameter text boxes in the Report Server UI As luck would have it, I need it to be just a few characters wider. Thank you, Dick Campbell Thanks Mike, That's correct, I am referring to the parameters at the top of the screen when you run the reports. It looks to me as though you cannot change their width. In general, it would be nice if we had more control of the size and position of the parameters. At the moment all you can change is their order. Because this is a UI, more control over the layout would be a big plus. Dick Campbell Thanks Andy, My problem is that I can't find anywhere to change the width in Visual S ...Show All

• Philippe Cand open an ODBC connection to a DB and must use a connection that looks like this: "DSN=myDSNname".

  In my ssis package, I have a DSN connection like this: "DSN=myDSNname". Which decide from i have to pull the data. By using OLE DB Source Editor, I want to assign that ODBC Connection to it. By data source Reader i can achive this but where i have to pass the hard-code SQL Query that i don't want. i'm using the variable for dynamic SQL command. Thanks. Manoj Manoj; You can use an expression to build dinamically the SQL statement at run time. The explanation on this trhead is for an OLE DB Command transform; but the procedure is the same for a data reader: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1005847&SiteID=1 I hope thsi helps Manoj Verma wrote: I hav ...Show All

• JohnWiel Havent been able to execute a package on the server

  Hello, I created a package on my machine, it deletes some files, then delete some rows, then copy files from a destination to a source and then process all those files and insert rows in a table, really simple. When I click execute in VS 2005 it executes perfectly. (it took about 45 seconds because there are many files) I connected to integration services and imported the package then I did the two following things. 1-Right click run package and it executes normally but it took less than 1 second, and when I saw the destination folder there were no files in there so it didnt do anything) 2. I created a job and on the first step I put to execute that package. I then executed the job and the same thing happens, it execute ...Show All

• Shaik Habeeb Same cube, different answers.

  I have built a cube that consists of three tables. The first table consist of childcare facilities and is historical. The second table consist of their licenses to operate and is also historical. A facility typically has a group of licenses such as infant, toddler, schoolage, ect. and the license has an assigned maximum capacity. The third table is used to resolve the many to many relationship that exist since both tables are historical. For example, a facility's record may change over time but still have the same set of licenses. The dimensions of the cube consist of the facility dimension, the license dimension, and a fact built on max capacity. When I browse the cube from the cube designer I get one set of answers. When I built a piv ...Show All

• SONAL N. SATPUTE Report Paramert problem

  I am trying to put a parameter on my report to select a field from my query but keep getting this error. What am I doing wrong [rsInvalidReportParameterDependency] The report parameter ‘Program’ has a DefaultValue or a ValidValue that depends on the report parameter “Program”. Forward dependencies are not valid. Build complete -- 1 errors, 0 warnings Hi, For the report parameter 'Program',On the Data tab Select on the Dataset name through which you are sending this 'Program' parameter to the database and click on this symbol "..." adjacent to the dataSet selection drop down list.Now a dataset window opens,From that window click on the Parameters tab.Parameters: Name Value If the parameter Name:@Pr ...Show All

• Pooja Katiyar consuming sqlserver 2005 webservice from asp.net 1.1

  Is it possible to consume the sql 2005 web service from 1.1 When I try and do so I receive the following error: Type 'http://schemas.microsoft.com/sqlserver/2004/sqltypes:varchar' is not declared or not a simple type. An error occurred at , (1, 2452). Thanks, Olja Yes, but if you are using the WSDL to generate stub class code, then you will need to retrieve the simple WSDL (ie. http://server/url wsdlsimple ). For additional information regarding simple WSDL please refer to MSDN article http://msdn2.microsoft.com/en-us/library/ms175476.aspx If you are using a .Net Frameworks 1.1 DataSet object to serialize the result from a SELECT statement, please note that .Net Frameworks 1.1 DataSet XML se ...Show All

• Chidu UDT - SQL Server 2005 - How to add custom properties in C# ?

  Hello to everyone, I've a question about UDTs and the way I can use them to access tables and columns where they are applied in a SQL Server 2005 DB . I've already spent 2 days googling and MSDN reading but nothing helped me to solve my problem, thats why I'm posting it here (this is the second post, maybe the last one was in the wrong Forum). The scenario follows: I've created a UDT called MyUDT that exposes 2 properties MyTable , MyColumn , here its the code: [Serializable] [SqlUserDefinedType(Format.UserDefined, IsByteOrdered = true, MaxByteSize = 8000, Name = "MyUDT")] public class MyUDT : INullable, IBinarySerialize {     private string _myTable;     private string _myColumn; .. ...Show All

• zd84 Infinite Loop in cursor

  Hi I have an infinite loop in a trigger I and I cant reslove it. In my system the user updates a stock table from the GUI and on the update I need to check values to see if I need to add records to a StockHistory table.  For Example:  If the user changes the grade of Product X from A to B then I need to add a new line in StockHistory for product X grade A that decrements the total number of products in the warehouse.  Similary I need to increase the quantity of stock for Product X grade B. I had the trigger working for single updates but now when stock is added to the database (from another db) it has status of 'New'.  This isn't actually 'in stock' until the user sets the status to 'Goods In'.  This proces ...Show All