Answer Questions

• tinaM Fore Color Expressions

  Hi all, I can't seem to find an example anywhere on the net or BOL on this one. I assume you can set the color of a calculated members dynamically in the Fore Color Expression property but I can't find any code samples for that. Can someone provide me a simply one for changing the color to red if a condition is met I really appreciate it! Brian Thanks, so it sounds like I'd want to do something like this at runtime in the OLAP clie ...Show All

• funwolf Store Ranking & Security

  I have what is hopefully an easy question. The set up is as follows: A store hierarchy dimension for a retail company that has national, regional, area and store levels. The users are secured by AD groups, and everyone at an Area Level on down can see the data for their area. Users above an area can see the entire company's data. A calculations that rank each Region, Area & Store in the context of the whole company. This calculatio ...Show All

• Sajid Saeed Problem to connect Access 2003 to SQL Server 2005 Express

  Hello, after successfully connect Access to the Server I want to add a table. I got an error message: With this version of MS Office Access you are not able to make any drafts because this version of SQL server you are connected to does not support this. Check the MS Office update website for the newest downloads. You habe connected to a version of SQL server which is newer than SQL server 2000. Versions: SQL Server runs ...Show All

• Praveenk_RS Openssl with the Report Server

  Hi, I am involved in a project with the aim of creating a web reporting application. A majority of the system works and is complete. The time has come to secure the system. Initially I created an SSL certificate using Openssl (signed with a root certificate that I had also created) - this worked fine for securing the Reports and ReportServer virtual directories but does not work for securing calls to the web service. The error message states ...Show All

• BhavinG msdb..backupset.backup_finish_date -- changes from SQL2000?

  It appears that the behavior has changed for the backupset table in the MSDB database between versions. In SQL2000 backup_start_date & backup_finish_date were populated correctly. In 2005, backup_finish_date is the same as the backup_start_date value. Is this a bug or should I be looking for my backup timing elsewhere in 2005 Thank you. I can't repro the problem. It works fine for me. I use th ...Show All

• jwlc76 SQL Server 2005 won't install

  I have followed the steps on this page but keep getting this message. SQL Server 2005 CTP Setup has detected incompatible beta componens from Visual Studio or SQL Server. You must run the build cleanup wizard from the CD to remove previous SQL Server 2005 components, and then run SQL Server 2005 CTP Setup again. For detailed instructions on uninstalling SQL Server builds, see the SQL Server 2005 CTP readme file. Any assistance would be apprec ...Show All

• Bob-12 script problem with POWER(x,y)

  hi, i can't see why the following field is not working correctly, ie: it's always coming up with 0: ((POWER((1+((((((POWER((1+(dbo_table1.APR/100)),(1/12)))-1))*12))/12)), dbo_table1.FREQUENCY)-1)*(12/dbo_table1.FREQUENCY))*100 AS YIELD breaking the code down to a smaller formula it does work. it looks like i can't have more calculations/references inside a POWER(x,y) function. any comments would be appreciated. thank you ...Show All

• Dan Straw Some users cannot view report in IE 6.0

  Some users get the error The page cannot be displayed The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings. when they click on one of the reports in report manager. It does not seem to matter what user logs in. Thanks in advance for your help. It looks like a 401 error. Are you seeing this whe ...Show All

• P_a_u_l text variable in TRIGGER

  recently I wrote a TRIGGER , but I found the text is not allowed to be used. such as: in the trigger: declare @content text Is it illegal   And why thank you! Thank you, Louis Davidson - SQL Server MVP I just want to use the text variable as a container of messages, but Iusing varchar(1000) is more expensive to the system, as the text variable is only 16 bits. maybe I should just adopt the varchar variable. ...Show All

• Laurent Chesnais Cannot set Default value for column using "Alter column"

  Well here's one of those excruciatingly simple obstacles: In SQL Server 2005 (Mgmt Studio): according to BOL, the syntax to set a default value for an existing column is: ALTER TABLE MyCustomers ALTER COLUMN CompanyName SET DEFAULT 'A. Datum Corporation' However, when I Check: alter table CommissionPayment alter column Amount Set Default 0 I get the error message: "Incorrect syntax near the keyword 'Set'." No other combinations o ...Show All

• bool007 semicolon terminator

  Can someone define for me what is a statement when it comes to having to use semicolon statement terminator This is absolutely undocumented in BOL. Googling only finds this incoherent article which is far from official documentation. TIA >> why is this considered a statement that requires termination >> Use dbo.MyDatabase; >>   Why do you say that this statement requires ...Show All

• Vicki Maxon dynamic SQL

  I have a problem on dynamic SQL: ... set @SQLString = 'use @dym_commonDB select @dym_out_proj_name = proj_desc from proj_mstr where proj_code = @dym_proj_code' exec sp_executesql @SQLString, n'@dym_out_proj_name nvarchar(50) output, @dym_proj_code nchar(6), @dym_commonDB varchar(50)', @dym_out_proj_name = @out_proj_name output, @dym_proj_code = @as_proj_code, @dym_commonDB = @commonDBName ... the error is: Line 1: Incorrect syntax ...Show All

• Johan Nyvaller OLE DB or ADO?? plz give me a suggestion!

  i am learn database access with native vc++, so ADO.NET is not electable for me. i wonder whether i should study OLE DB first or ADO. i've been working with ADO under VB for some time, it's very simple to use. but i dont think it's the best choice for vc++, i think it's OLE DB. but OLE DB is really difficult, too many interfaces, and properties!!! could u give a suggestion should i learn ADO with vc++ first and then OLE DB, or sould i  ...Show All

• Rodrigo Harambure Equality comparison of xml fields

  I have a stored procedure that has an xml input parameter, and the routine will proceed only when the inputted xml is equal to the stored xml field. Is there some sort of equals comparison for this * The xml field is typed DOCUMENT. Thanks Shankar for the reply. What I would do is break down this xml chunk into smaller content and perform the above as you suggested. XML data t ...Show All

• Chris Powell Merge Replication - Weird Conflicts for no reason

  Hi. I am using Merge Replication on Sql Server 2005 (which works much better than 2000 by the way) and everything is working great except occassionally I will get some conflict rows for no reason. The same column(s) of the same row was updated at both 'PublishingServerName.DatabaseName' and 'SubscribingServerName.DatabaseName'. The resolver chose the update from 'PublishingServerName.DatabaseName' as the winner. I checked our audit table a ...Show All