Answer Questions

• StuartLodge ScriptComponent with multiple ReadOnly variables

  I'm having trouble with a script component in which I'm trying to use two ReadOnlyVariables. If I use only one of the two variables, everything works without issue. If I use both of the variables (as part of a comma-delimited list) I get the following: The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created. I don't believe the variables themselves are the problem. Both are scoped to the package level and I can use either of them if I have it as the only variable. Seems bug-like, but thought I'd get some ideas before pursuing t ...Show All

• Emanuel Dejanu Does Graphics Card affect preformance of rendering?

  I have a feeling that this is an urban legend, but I'd to verify: Will the graphics card installed in the RS machine affect performance of any of the rendering laternatives If so, significantlly An RS machine is typically a server, and such tend to have low-end graphics cards. Two of my customers insists that they have "heard this somewhere"... RS uses GDI internally for some rendering operations. In theory, a video driver can hook GDI and perform some of the operations more efficiently. In practice, I don't think we have seen anyone report any performance boost because of this though. ...Show All

• Pradeep Gupta Grouping problem

  I am working on a report for a small POS. The report should allow the user to choose the time interval to group sales records, e.g. 1 hour, 2 hours or 4 hours. I believe I can setup this by the DiscretizationMethod and DiscretizationBucketCount of the Hour attribute in my DimTime dimension. However, the problem that I am facing is this POS will support multiple branches. Each branch will have their particular opening and closing hour. So, how can I group all the transaction into groups, said "Before Shop Open" and "After Shop Closed" This sounds strange but will happen quite often as overtime work is always expected in my living place. If this is infeasible, is there any workaround I think the business user certainly want to know how many ...Show All

• abs MDX equal to the SQL EXISTS Statement

  For an MDX Query, I need something like EXISTS does for SQL. Imagine a Customer - Order relationship. Show all Orders for DVDs would be something like this (pseudo-SQL): SELECT [ ] FROM [ ] JOIN [ ] WHERE Order = 'DVD'. Now this would give you orders, but for each order only the DVD ordered, not the whole order. I can do such queries in MDX, but that is not my goal. I want to see all details of those orders where a DVD was included, so I go (SQL again): SELECT [ ] FROM [ ] JOIN [ ] WHERE EXISTS (SELECT [ ] FROM [ ] WHERE id = id AND = 'DVD'). If someone ordered a DVD and 3 Books, I would see those 4 results. Now: Does MDX offer such an option too Can I make a query that uses a dimension entry as "hint" to only work value ...Show All

• BilalShouman 1434, 1433 - the big taboo...

  Security question regarding opening of port 1433, 1434 (or whatever SQL 2000/2005 port one assigns to SQL services to listen on). I'm running in what appears to be paranoid sys admins when it comes to opening up port 1433, 1434 for MS SQL servers. When I ask why, they say it's a big security risk and then reference a SQL worm/security bug in SQL 2000 that happened about 2-3 years ago which has since been patched in SP3 onwards. So I say ok, so it's been patched so why can't the port be open now Cause it happened once and only compromised very few SQL servers and as of todate, no one can positively suggest that the bug even exposed any useful/sensitive data But what I can't really understand, is that sys admins will be ok with openin ...Show All

• Claire O Document Map

  Problems with Document Map creating a side scroll to get to Up/Down Scroll for the Map itself. There are two scroll bars once you side scroll over in the map window. Anyone seen this or know how to fix Or Anyone know how to change any of the properties on the Document Map or map window Thanks!!!!! Can you try posting a screen shot of what you are describing seriously ! ! ! So no one knows how to change any configuration on the Document map or why it creates a side scroll and a seperate vertical scroll from the main report It is a known issue for which we have a repro for. Unfortunately there is ...Show All

• Steve1999 SQL Express Management Setup Error on Windows Vista Beta 2

  Miscrosoft SQL Server Management Studio Express (SQLServer2005_SSMEE.msi) don't complete setup on Windows Vista Beta 2 with Sql Server 2005 Express installed. Error Code 29506. C:\Program Files\Microsoft SQL server\\90\Tools, Alberto What mean (Alberto is my Windows account) 29506 is "SQL Server Setup failed to modify security permissions on file %. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that % exists on the destination drive." To debug this further, look through the setup log files located at %Program files%\Microsoft SQL Server\90\Setup Bootstrap\Log. You ...Show All

• angrylala Dynamic PIVOT quey challange

  Hi I have following Table A In which values of LotNo field is not fixed so we cannot write these values to our PIVOT clause in Select statement. Now can any one provide me sucha a query which can generate this PIVOT result in Table B. Not there is a distnict list of Lotno. is availble from a view. Table A LotNo. Pcs Wt. 12 200 12.212 13 21 16.214 17 23 21.211 18 27 32.212 Table B LotNo 12 13 17 18 Pcs 200 21 23 27 Weight 12.212 16.214 21.211 32.212 So I want to write a select query wth PIVOT clause which takes Lotno. which is not fixed values (As given in Adventurewo ...Show All

• rrayfield MDX Query

  Hi, Before I start, all the queries here have been used for my learning process and they may don't make any sense. I've got a little bit confused about the way a specific MDX query executes. Underestanding the following query is simple: (I used AdventureWorks sample database and DW) WITH MEMBER MEASURES.PROFIT AS ([Measures].[Internet Sales Amount]-[Measures].[Total Product Cost]) SELECT MEASURES.PROFIT ON COLUMNS, [Customer].[Country].MEMBERS ON ROWS FROM [Adventure Works] for each member of country hierarchy in customer dimention it calculates the profit. but I don't get how the following query is executed: WITH MEMBER MEASURES.LOCATIONNAME AS [Customer].[Country].CURRENTMEMBER.NAME SELECT MEASURES.LOCATIONNAME ON COLUMNS, [Customer]. ...Show All

• goldstei with new hard drive- Error 3: the system cannot find the specified path

  Installed SQL Server 2000 Enterprise trial a week ago on XP Pro. Installed new Seagate 80G HD; used Seagate's utility to copy old C: to new drive as new boot drive. All seems to work fine, except, when booting up, SQL server doesn't start. When I try to start it manually I get the following: Could not start SQLSERVER service on the local computer. Error 3: the system cannot find the specified path. 1. What could be wrong 2. How do I fix it The problem seems not in sql server as we see "SQL Server is terminating due to 'stop' request from Service Control Manager." Run 'eventvwr' from cmd windows to check the event log. Hi all, Was there any answers to this Same error, still no ...Show All

• Ravencraft recovery a SQL Server db from mdf/Ldf files

  hi to all, I'm newbie with Sql Server, I've a serious problem. After a crash of one of my disk I loose all the data about the SQL Server db but I've the mdf and ldf files because were placed on another hard disk different from the SQL Serve Installation disk. I reinstalled the Sql Server (in a new path, a new hard disk letter) but I don't know how to rebuild the db starting from the mdf/ldf files. Is it possible Please help me, I'm in a ugly Situation. Open Books Online. Do a search for Attach. It will have instructions and sample code. What version are you using...SQL Server 2000 or 2005 If you can access the mdf/ldf files, simply doing an attach will do the trick ... sometimes can you teach me how to at ...Show All

• Mystagogue Can't run dts package job

  I setup a job which call a dts package (I try to call it from file system and from SSIS Package Store with the same result) and it doesn't run. If you take a look from the SQL Server Agent you could see this --->> 2012-06-17 09:01:02 - ! [LOG] Step 1 of job 'prueba' (0x85B4D5E843DB3145A6A1A6A0A43D04F3) cannot be run because the DTS subsystem failed to load. The job has been suspended Any ideas This was a dts in SQL 2005, right If so, how did you get to the dbo.syssubsystems table I know its in the MSDB but I can't get access to that table, even as an admin of the box. Any ideas Hi, I have a similar situation. We have program files on C:\ and Data ...Show All

• Dangerous Dan xp_cmdshell and activation

  We are trying to use xp_cmdshell commands in service broker. If I kick off the process without activation, the process succeeds. If I enable activation, the tasks with xp_cmdshell fail. The xp_cmdshell task is either a echo command so that users know that we are processing a database, or a file copy. I used the TechNet article by Roger Wolter to create the queues and stored procedures. We will be working across domains that have one-way trusts. Wayne Yet another manifestation of the database Execute As context, as described here: http://msdn2.microsoft.com/en-us/library/ms188304.aspx . See thse series of articles: - http://blogs.msdn.com/remusrusanu/archive/2006/01/12/512085.aspx - http://blo ...Show All

• 5rewesh Proxies: What is it for?

  Let me know any link for that. tia I'm not sure I understand the question. What proxies are you refering to Thanks, ~ Remus If you mean the proxy account SQL Server can run under, that is just a security impersonation for the case that you want to run xp_cmdshell with other priviledges than the Service Account. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• dev_bih CTE Error: Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause,

  I am having this error when using execute query for CTE Help will be appriciated So your suggestion to check the compatability level led me to the answer. The database server I was trying to run the query against is a SQL2000 server. We have many instances of SQL Server running for development purposes, and I didn't realize I was working against a SQL2000 instance. That database has the data I need in it, so I will have to move it to another machine. A silly mistake, but I wouldn't have realized it, Thanks for your help! I was able to run that batch on my end with no errors once I uncommented the insert line...   -- Adam Mach ...Show All