Answer Questions

• Dudley SQL Mirroring Witness

  I have managed to set up mirroring on SQl 2005 however i have a come across a problem that i dont know how to resolve. Im running the mirroring with 'High Safety with automatic failover.' If i instagate a failover on the Principal Database, the mirror becomes the Principal, and vice versa ... great .. how ever .. i tried the golden test by making the principal server dissapear by yanking out the network connection, expecting the mirror to become the principal.....nope it just stays there in a disconnected / restoring state which isnt any good to man nor beast . I thought that the Witness should have dectected that the principal database had 'dissapeared' and would have made the mirror the Principal. Any pointers on where i might ...Show All

• saliq Connecting to Oracle 9i Server using ODBC from an SSIS package

  I am trying to connect to a Oracle 9i Server to execute a sql task, but the connection when tested seems to fail with the following error from the Integration Services Project: Test connection failed because of an error in initializing provider. ERROR [NA000][Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener ERROR[IM006][Microsoft ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR[0100][Microsoft ODBC Driver Manager] The driver does not support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). The connection was configured and tested from Oracle's SQLPlus session. Please note that the port that the TNS Server is listening is not the default. Is there somewhere I can sp ...Show All

• Chronusus time format

  hello to every one well i have a calculated member in seconds and i want to represent it in the format hh:mm:ss in analysis serveces. my problem is that if the hours exceed the number 24 i want to display the hours for example 350:50:10. how can i achive that thanxs Well, this might be a totally round-about way to achieve this, but could you create a few helper calculated members (and make them hidden) to calculate just the seconds, just the minutes, and just the hours, and then a formatted calculated member that produces a string that just concatenates the values back together again Just playing around with this a bit in a query, I came up with the following (relying on some of the VBA function ...Show All

• Jasper22 Strange problem with Delete

  Hi, i had been some a problem with the delete statement. When i try to delete X rows of a table in a transaction, it doesn’t work properly, some rows aren’t deleted. I’m working with one thread and concurrency. I tried before delete the same information with stored procedure and the same problem happened. Anyone had this problem before Any sugestions Maybe the concurrency I’m working with ASp.Net+VB.NET+SQL Server thanks Joao Paulo Lindgren You'll need to post your code and some sample data here, we can't just guess. If you get an error message it's probably a constraint (e.g. foreign key) Else it's probably a delete trigger   Do you get some error du ...Show All

• Alexnaldo Santos help with sql query returning last max record

  I am having problems with a SQL query. Table has 10 fields and I need to return them all. The three most importaint, at least for the filter I need are: id, studentid, date, canceled. I need to return the last max(date) grater than or equal to @dateparam which is not canceled for each studentid I have worked out some solutions but am not happy with them. Specially woried about performance when the table grows. I am expecting in full production a table growth of about 3 million records per month. what would be grate is if there where a way of returning a the coresponding id like in: select studentid, max(date), related(id) as ids from tablea where canceled=0 group by studentid then I could do: Select * from tablea inner ...Show All

• allison_h Attach database loses CLR

  Hi When I deploy a database (mdf and ldf) and attch the database I get errors when my stored procedures attempt to call CLR stored procs. Error regards database trust and assembly safety etc. This works on my development system/database so it's setup correclty there. Clearly I'm missing some additional setup when attaching the database to another server instance. Can't figure it out though. I'm marking the assembly UNSAFE (it requires network access) and the database as trustworthy when attaching but the error persists. Also making sure the server instance has CLR enabled. What am I missing Any ideas Andrea, Traditional, user instances don't suit the application. When attaching the DB to another server instance I ...Show All

• mobigital Proclarity and SQL Server 2005

  Hi All, We are starting on a tool called Proclarity, which is used on top of Microsoft SQL Server Analysis Services. Having this as the basic idea, I’m not clear on some information as listed below: Any clarification would be very helpful. 1 Having SSRS (SQL Server Reporting Service) available to perform reports, what is Proclarity for Reporting Services. What it does by integrating with SSRS and its advantages. How is it different from Proclarity Web/Desktop professional. 2 Having Business Scorecard manager from Microsoft, what is the purpose of Proclarity KPI Designer, its advantages/disadvantages over BSM Still proclarity has one more add-on Proclarity for BSM (not sure why we need this) 3 ...Show All

• MDesigner Need assistance with Duplicate Select Statment

  Any help would be appreciated here. My question is two part: 1.) Select duplicates that match any of a number of columns for example... The email is the same OR The homephone is the same OR The mobilephone is the same OR The address1 is the same The uniqueID is ConsIntID My Select Statement: (Which does not work) SELECT CONSINTID , FIRSTNAME , LASTNAME , EMAIL1 , ADDRESS1 , HOMEPHONE , MOBILEPHONE , CREATEDATE , USERIDS FROM CONSULTANTS WHERE CONSINTID IN ( SELECT CONSINTID FROM CONSULTANTS HAVING COUNT ( HOMEPHONE ) > 1 OR COUNT (MOBILEPHONE) >1 OR etc.... ) ------------------------------------------------------------------------------------------------------------------------ ...Show All

• Tomasz K. Excel pivot table. Any language you like as long as its US English

  Hi, I have created an OLAP Cube in SQL Server 2005 CTP2 and can browse it fine in the Analysis Studio / Browse tab. When I use the pivot table feature in Excel (2003) I get: XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a value. Any help is appreciated. Cheers, Adam Was: Excel pivot table. Any language you like as long as its US English I have this message appearing in Excel when connecting to Analysis Services 2000 and 2005 cubes. I have never used languages other than English in the application and the locale settings were NOT changed. Installing the the latest version of Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider does N ...Show All

• ghw123 print from toolbar

  Hello, I have created an asp.net application using VS .Net 2003, which has a Report Viewer to include reports from my report manager. The reportviewer has been set to include the standard toolbar, which includes the print button.  However, when I use this option, the system prints more pages than it should.  If the report is 2 pages long, I end up getting 6 pages, the other four having just the header and footer...(2 blanks pages after each page when port. ana 1 black after each page if landscape) Any1 know the solution to this problem I have not coded anything for the print option.... Thanks :) Check the width of your reports. If it is too wide then printing it will create extra pages ...Show All

• percent20net Package fails when I schedule it.

  Two scenarios, 1 worked, 1 didn't: First package I execute SQL (select top 10 * from MyTable) in my SQLServer2005 database. I scheduled it and it ran sucessfully. I changed the execute SQL to run against an external Oracle database. (Select * from SomeOracleTable where rownum <= 10). I preview to make sure the query works and it does return a result set. I execute the package in the Visual Studios IDE and it works. I save with encryptAllWithPassword to the SQL server. I go into the scheduler and select the package from SQL Server (as opposed to the file system). I set the step to execute the package off the server. I enter the security key by clicking on the configuration tab. I assume it saves the password to the package. I cl ...Show All

• espelly predict product with sex and age of customer.

  i have table: customer(customerid, age,sex....) orderdata(orderid, customerid,day) orderdetails(orderid, productid, quantity) products(productid, productname,...) now, i want to show some product for customer when i now him age and sex. e.ct: if he is a man and age =20 i show product : ball, pull, sport close....... if man is a woman , i show lips, babara, t_shirt, skirt.... if man is a chirdren, i will show joy, story for chidren.... how i create my mining model. and how i query for result in DTS The easiest way would be first to create a view containing the customer information along with the order id, e.g. orderid, age, sex, ... Then you would create a model using that vi ...Show All

• Catherine Parkhouse How to select only the first record from a group

  I have a question about selecting only the first record in a group. Example: I have table A with primary key = 999. Table B has multiple records with primary key = 999. How can I match Table A 999 with the first occurrence of 999 in Table B, and then extract other field data (such as street address) from the Table B record. I have tried using the Count() function, but it seems that I can only do this using cursors. Thanks, BobD hi take a look at this with northwind database use northwind select * from orders select * from [order details] now here's the query to simulate your needs use northwind select a.orderid,a.productid, od2.* from ( select o.orderid, min(productid)as pr ...Show All

• Scott Boyd Is ProcessAdd done within a transaction mode?

  This question is very basic. When you do a ProcessAdd, is it within a transaciton mode I mean, if the ProcessAdd fault and stop when it meets a mistake, the records before the midstake will still be in the cube or not. Thanks. ivanchain wrote: This question is very basic. When you do a ProcessAdd, is it within a transaciton mode I mean, if the ProcessAdd fault and stop when it meets a mistake, the records before the midstake will still be in the cube or not. Thanks. This sounds like a SSAS question to me. Wrong forum. [Having said that - I think everything will be rolled back. But don't quote me on that. Ask someone who knows] -Jamie ...Show All

• Bruce Baker DB Access from different m/c

  when i access the database from different DB server getting the following error Msg 18452, Sev 14, State 1, Line 1 : Login failed for user ''. The user is not associated with a trusted SQL Server connection. [SQLSTATE 28000] Thanks, Ravinder Your SQL Server is set to Windows Authentication only. You need to logon with a user which has granted access to the server. You can’t provide a userId and passwort in the connecting string because this will be ognored in the case of Windows Auth. only. Another option would be, if feasable for your to switch the authentication mode to mixed. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All