Answer Questions

• vinclaro001 how to find vacant slot of rack

  Dear All, i want to find no of empty rack(two dimensional ) . i am using sql2000 i have a rack of two dimensional where every slot is recognized by rowno and columnno now in every slot i placed item (captured by itemcode). nOw i want to find slot do not assing any item please give me some idea there is rackmst( where i define max_no_row and max_no_cols). Please help thanks Perhaps something like this would help: CREATE TABLE MyRack ( RowNo int, ColNo int, Slot varchar(10) PRIMARY KEY ( RowNo, ColNo ) ) INSERT INTO MyRack VALUES ( 1, 1, 'a25' ) INSERT INTO MyRack VALUES ( 1, 2, 'a24' ) INSERT INTO MyRack VALUES ( 1, 3, 'a23' ) INSERT INTO MyRack VALUES ( 1, 4, 'a28' ...Show All

• JHagan A Problem with Processing a datamining structure

  Hello : I have tried to process a datamining structure in SQL Server 2005 (Developer Edition) but I receive these messages from Sql Server : "Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dbjao', Name of 'Dbjao'." "Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'MCredito ~MC-Id', Name of 'MCredito ~MC-Id' was being processed." "Errors in the OLAP storage engine: An error occurred while the 'Class' attribute of the 'MCredito ~MC-Id' dimension from the 'CreditoAleman' database was being processed." I generate this model from a relational table and can explore this table and build and deploy the pr ...Show All

• Roxanne163 Capturing ISS Log data

  I am quite new to Reporting Services and need some help figuring out why i can't correctly capture the referrrer information in the IIS Logs. As far as i know when you run the data extraction tool provided with RS it copies the logs into the staging db, from there it then copies all the data into the WSSFact table in the actual db. I thought that if i entered a URL into the referrer table that when it populates the WSSFact table it would check to see if the referrer URL matches any of the entries in the referrer table and if so enter its id, otherwise enter the id for No referrer. This seems to work fine for all existing entires in the referrer table but it ignores the new one i have added. Does anyone know if there is something else that ...Show All

• Ashish Chawla Licensing query

  We are in the process of ordering Sql Server 2005 for a client application and I am interested in more detail about the various licensing models. Our application is essential a web application which stores answers from users to a questionnaire. These answers are then processed by an application running on the server and a report is produced. I have seen that for the workgroup edition, a "Server + 5 CALs" licence is quite affordable, but am not sure whether his is legal for our purposes. Given that all internet users connect through the same account on the windows server do all the users count as one user Or would we need a CAL for each potential user Since we can never know the number of users for the system we would then need th ...Show All

• Kaos How to attach network file when send email with msdb..sp_send_dbmail, thanks

  I need attach file on other server on the same network. My sql is on a server named sql8, so I send email like this execute msdb..sp_send_dbmail @recipients='wyx1999@hotmail.com',@subject='subject',@body='body', @file_attachments='c:\header.gif' it works fine, but if I send execute msdb..sp_send_dbmail @recipients='wyx1999@hotmail.com',@subject='subject',@body='body', @file_attachments='\\sql8\header.gif' it gives me error Msg 22051, Level 16, State 1, Line 0 Attachment file \\sql8\header.gif is invalid. Any idea DECLARE @Message VARCHAR ( 2000 ), @Subject VARCHAR ( 500 ), @FileName VARCHAR ( 500 ), @File_exists INT SET @Message = 'These are the files ...Show All

• barn Replication Trigger Problem (SQL 2005): Assistance Please

  Our company is wanting to replicate a bunch of data down from our central server to tablet PC's. We really do not have anyone on staff with solid experience in replication, and have hit an error that we cannot seem to find any information whatsoever on. Here is the problem: When setting up a publication to replicate certain tables, we stop being able to do any updates on the tables. After some research, we were able to narrow the problem into the msrepl triggers the publication places on the table. In the update trigger of the table, the following line is being placed by SQL Server: execute sp_mapdown_bitmap 0x0000000040, @bm output The sp_mapdown_bitmap call, passes through to a xp_mapdown_bitmap call (limited documentation I ...Show All

• nhaas Unable to access the report server

  Hi Guys, After installing SQL Server 2005 Reporting Services, I got the following errors: 1. When I tried to open http://localhost/reports/ , I got the following error message The report server is not responding. Verify that the report server is running and can be accessed from this computer . 2. When I tried to open http://localhost/reportserver/ , I got the following error message The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied. Is there any clue for this technical problem Immediate resp ...Show All

• Steve Whitley Measure group related question

  I have a cube with two fact tables, two measure groups. I also created few calculated measures. On client side I see two measure groups and below the calculated measure. Is there any way I can show that calculated measure in one of the measure group. It's easy for end user to see number measure and % measure both next to each other. I hope this can be possible using MDX some how update mdx for measure group or some thing... Thank you - Ashok Ashok, moving a measure from one measure group to another is not currently supported in AS 2005. --Artur Ashok, You can easily associate your calculated measure with any existing measure group. To do this, ...Show All

• netpicker9 Refresh Linked Server without restart?

  Hi All, Firstly, apologies if this isn't the correct category for this posting but I couldn't see anything more appropriate! I have an alias set up on my server which I want to change to point to a different server. However when I do this, the original info seems to be cached within SQL Server so any connections that were open before the change continue to use the original server. The only CONSISTENT way (that I can see) of ensuring the new attributes are picked up is by restarting the server which is a little more extreme than I would have hoped. It's worth mentioning that on a couple of occasions the updates have seemed to have filtered through without a restart which has only caused me more confusion due to this inconsistency ...Show All

• Khalid1 SSIS Data Flow task fails to load all text from flat file

  Hi Guys, I have a flat file which is loaded into the database on a daily basis. The file contains rows of strings which I load into a table, specifically to a column of length 8000. The string has a length of 690, but the format is like 'xxxxxx xx xx..' and so on, where 'xxxx' represents data. So there are spaces, etc present in the middle. Previously I used SQL 2000 DTS to load the files in, and it was just a Column Transformation with the Col001 from the text file loading straight to my table column. After the load, if I select len(col) it gives me 750 for all rows. Once I started to migrate this to SSIS, I allocated the Control Flow Task and specified the flat file source and the oledb destination, and gave the output column ...Show All

• SimonOng Auto Updates for SQL Server?

  Our IT guy insists that he must be present anytime the SQL Server automatic updates from Microsoft are installed on the server or the server will crash. What has he been tinkering with to cause this to happen or is he just giving us a line I'm not sure this is a productive discussion for this forum. No one here could (or should) offer any suggestiona as to what your IT guy might or might not do to a computer to make it crash. If you have significant concerns about one of your employees, you need to take it up with your boss. If you feel it is a real possibility that your IT guy might do something maliceous to your server, you should have a qualified computer technician take a look at it. Regards, ...Show All

• Large_Goose What's the best way to deploy CLR Extensions to SQL Express?

  The project I'm working on has been developed using SQL 2005 Developer Edition and VS 2005, so up until now VS has been handling the task of deploying my C# managed code stored procedures to the database. Now it's time to deploy a beta of the product, and we want to use SQL 2005 Express, and take advantage of it's new XCOPY deployment mode which in turn means we can also take full advantage of Click Once for our software updates. The idea here is that we can deploy new or updated stored procedures in a managed DLL using Click Once, making updates presumably more simple and robust. So the steps we need to complete at runtime are: 1. Dynamically load and access the database MDF file using SQL Express (done). 2. Enable CLR Integra ...Show All

• epsilon_ro Not trivial calculated member in MSAS

  Hello all, I need to create a complicated calculated member that a similar as an SQL statement “select where in”. So there are two dimensions errors and products. Each product is assigned to an error or has no error. Each product has also some amount. For example, say we have errors E1, E2, E3 and N/A is for no errors and we have also three products P1, P2 and P3. For instance we have following situation: Product Error Amount P1 E1 10 P2 E1 20 P3 E2 30 P1 E2 10 P1 E3 10 P2 E3 20 P2 N/A 20 P2 N/A 20 P1 N/A 10 And I need to see following in the cube Error Amount Failed Amount total E1 30 120 E2 40 70 E3 30 120 N/A 50 120 Amount failed is amount for each error. So for E1 these are products P1 + P2 -> 10 + 2 ...Show All

• Sniper167 sql 2005 install

  Hi, Installed sql server 2005 full version. Now in the start menu there is no management studio. Only the following are present; configuration tools sql server 2005 upgrade advisor documentation and tutorial Any thoughts please Thanks Which edition did you install Management studio does not come with some of the editions (such as SQL Express). Here is the support matrix. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Thanks, Sam Could it be because IIS is not allowed to be installed on the PC (Company regulation) How did you install SQL Server 2005 Check this out for a guide http://msdn2.microsoft.com/en-us/library/ms143516.aspx ...Show All

• user11 SSIS and SAP BW link - How to call OLAP BAPI?

  Hi, I'm trying to link SSIS (Microsoft SQL Server 2005 Integration Services) with an SAP Business Warehouse to extract data from a QueryCube. I'm thinking about using the OLAP-BAPI but I don't know how to access it via SSIS. Are there any ideas or comments how to accomplish this Thanks in advance! Markus Thank's for the link. I've been on the page before but I thought there are other ways to link to the Business Warehouse too. The issue with the ".NET Data Provider for mySAP Business Suite" is the fact that it needs two RFCs on the server. On most installations it won't be possible to install RFCs "just" for data extraction. Currently I'm on the ...Show All