Answer Questions

• Sean A System.Transactions issues

  Hi Is it necessary to have the connection open code inside the transaction scope to be able to use transaction features. I wrote a code which has the connection.open outside the transaction scope and it wasn’t working correctly. When i moved the connection.open inside the transaction scope it started working fine. Apart from this is there any special setting i need to do (DTC related) while working with System.Transaction and SQL Server 2000. ...Show All

• TimDinh checking length of textbox value!

  Hi I was looking to check the length of a textbox then truncate it if it is graeter than some value and assign the that value for a textbox control in reporting service.How can i acheve this Thanks   I want to do the same thing as well as if the length of the field is shorted than the required length, I need to pad it with spaces. Can someone help with how to do that as well Thanks AY I do not know wh ...Show All

• ika Installation refused

  Really no good experience! After uninstalling every stuff regarding  : .Net, MSDN, Sql Beta version, etc. no way to finish the installation starting from this package "SQLEXPR_ITA.EXE". I lose any idea how to solve this Windows MisterY. I left installed Visual Studio 6.0. Please suggest me something new...I would avoid to eliminate everything   Thanks   Eibike Sorry for the long delay Enrico, this one slipped u ...Show All

• muko What accounts for this performance difference?

  As mentioned in a previous thread, I've got a single Transaction Scope style transaction surrounding a number of DDL style changes. This usually takes ~1.5 hours to complete. What I noticed is the same sort of query starts to take longer the closer to the end it is. I.e. Create Table after the first 1 min takes 150ms, after an 1 hr it takes 2 secs. Is this a problem with SQL Transaction handling or DTC To prove the point I set my root transactio ...Show All

• ManishPPPP Dynamic Prompts

  Hi All I'm currently trying to shift to the SRS 2005, (Mainly the report builder) My former report generator had a capability of popping up a list of pre-defined prompts that had a dynamic data in their dropdowns, I.E whenever I asked to choose let's say employee full name it had some sort of a SELECT DISTINCT command that pulled the data and showed it in the drop down. I have tried searching for a similar capability in the SRS but all ...Show All

• DBRGSS How do I use SQL Server 2005 Express for a backend to a web site forums

  I have installed SQL Server 2005 Express Advanced Edition. I wan to use it as a database backend for a Web Site I am building which will use the Snitz Forums ASP web. How do I se this up to work with the Snitz product Yes I am new to databases and have never set up one for use in a web application or site before. I am grateful for any assistance or tutorials which can be given to help me accomplish this task. Glen, First off, thank yo ...Show All

• Gregory_N Non aggregate case

  Hello, In the same fact table, I have real values and min/max values. The type of value (real, min, max) is a dimension. So, I want to aggregate value only for real value, because for min/max values, all the leaf are filled by my program. So, it's possible to say "I want the not aggregate value in the database" in MDX query Thank you, Guillaume. Thank you ! Ok, now I created 2 NamedCalcu ...Show All

• planetx Reporting Server error

  When I log onto the homepage of my reporting server I get a big RED "X" in the upper left hand corner with the word "Error" . There is nothig in the event viewer to indicate a problem. I have looked at the IIS permissions and they all appear to be set properly. Are you trying to connect to <servername>/Reports or <servername>/ReportServer What version are you using Hav ...Show All

• Cindy06 Materialized View Doesn't Materialize. (and queries on MVs ignore index hints)

  I am creating and indexing a view. The index does materialize physically (i think -- since sp_spaceused now returns values -- not nulls) But any query searching the view does NOT use the materialized index. Here's an example: -- Create/Populate test table create table test ( i int constraint PK primary key ) insert test select 1 union select 2   -- Create View set ansi_nulls , ansi_padding ...Show All

• T-H Wildcard SLL Certificates

  Does Reporting Services support wildcard ssl certificates ...Show All

• Qa Dept Restoring Analysis Services Database backup from SQL 2005 CTP June to SQL 2005 RTM

  Hello I need to restore a SSAS database backup from SQL 2005 CTP june to SQL 2005 RTM. Doing so, i get the error: the backup metadata is damaged ... I tried various SSAS databases. I am able to restore other databases like Adventureworks, Adventureworks DW. Kindly help. Thanks Try scripting your database with CTP and then re-create and re-process it using RTM version. Edward. -- This posting is provided "AS ...Show All

• vhawk Maintenance plans: online rebuilding of indexes...

  I'm using SQL Server 2005 SP1 Standard. On the Rebuild Index Task there is a checkbox at the bottom that says 'Keep index online while reindexing'. Great I thought, I'll check that. Later, when I tested the job, I got this error: 'Online index operations can only be performed in Enterprise edition of SQL Server.' Why have that checkbox available to check, if I'm running a version that doesn't allow it Where's the bug Thanks ...Show All

• COMGENXP T-SQL select performance

  Hi. I have in my databases the follow tables: Cliente: PK = cdCli. FoneCli: PK = isnFone. One client can have many fones (home, work, moblile, neighbor, father, etc) I need in a query, get the clients and yours fones home, work and moblile. I do this now with the follow command: select Cliente.cdCli, Cliente.nmCli,          (select nuFone from FoneCli where FoneCli.cdCli = Cliente.cdCli and ...Show All

• TungNguyen Problem in ERD creation in sql server management studio

  I have downloaded adventurework database intall it then configure the databases in managemnt studio and then make a ERD of the db all works fine. Then I have intall asp.net 2.0 starter kits. 1,Club Starter kit 2,Commerce Starter Kit 3,eBay Selling StarterKit 4,Jobs Site Starter Kit 5,Personal Site Starter kit 6,Time Tracker Starter kit install them and configure the databases in managemnt studio.all thing works fine but when I create erd ...Show All

• Rob McCabe SQL Express Minimum Requirements Warning on Windows 2000 Professional???

  The computers here at work run Windows 2000 5.00.2195 SP4. Everything checks out with the minimum requirements at http://msdn.microsoft.com/vstudio/express/support/sqlreadme/#_3462_setup_issues_238p However, one of the "Reports" from the installation says the machine does not meet the minimum requirements, but provides no details. It installs and I have Admin rights on this machine, but I can't even connect to the Northwind database ...Show All