Answer Questions

• FernandoLeite SQL Server 2005 Install fails on Vista

  During the install, I get the following message: Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt. I cannot uninstall 2.0, as its part of the Vista. I have tried repairing it. I tried downloading 2.0 and installing it, but it says that its allready installed. I was able to install Visual Studio with Sql Server 2005 express. I am stuck. Is the case that Sql install dosent know about the latest version of 2.0 that came with vista It looks like this machine has the SP2 version of SqlSupport installed. Are there any instances already installed If not, I would uninstall SqlSupport and try agai ...Show All

• Thrix OLAP 2005 Calculated Measure using Field/Dimension

  I am building an OLAP Cube off someone else's data model, so i am a bit stuck trying to decision off model decisions already made and being used. They have a field for Satisfaction which has the value Yes, No, and Blank when no survey result was received. I need to make a satisfaction percent based on (count of Yes) / (count of Yes + count of No). So i do not count blank when no result was received. I need the caculated measure to work against all of the dimensions, so i do not want to build such a specific MDX code that it only works with Time, for example. Help will be extremely Appreciated *A If there is a Satisfaction dimension/attribute, with the members above: Yes, No, and Blank, and ...Show All

• SK_Rajdev Match numbers

  I have a problem using the sql builder since i am trying to match a list of 5 numbers in TAble A with other 5 numbers in Table B All i want to know is when there will be a match it will indicate in the report. Example code of what i tried: SELECT     DBA.*,DBB.* FROM         (DBA INNER JOIN                       DBB ON DBA.[ 1] = DBB.[ 1] OR DBA.[ 1] = DBB.[ 2] OR DBA.[ 1] =DBB.[ 3] OR                       DBA.[ 1] = DBB.[ 4] OR DBA.[ 1] = DBB.[ 5] O ...Show All

• c_f_p report on two database

  hi all i m facing a problem in reporting services. i have a global database, in which i m mainting user inormation like database name, server name and all credentails about user database. i want that when my report is open a user parameter will display, on the basis of that users id report will display data from his database. server name can be different, database name can be different but schema of database will be same for all user. so pls help me The DataSource string of the dataset is dynmaic which means that you are able to use Expressions within the Data Source, using the syntax ="DataSource=" & Parameter!SomeParameter.Value HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Rhubarb ExternalActivator sample - documentation

  Hi! Where can I find some documentation about the ExternalActivator sample available on gotdotnet.com I'm looking for a tutorial how the sample can be set up and used... Thanks Klaus Aschenbrenner www.csharp.at http://www.sqljunkies.com/weblog/klaus.aschenbrenner Uploaded to the codegallery . Hi! You can download the whole source code for the samples from the Apress website. If you need further information don't hesistate to contact me at Klaus.Aschenbrenner@csharp.at HTH Klaus Aschenbrenner http://www.csharp.at http://www.csharp.at/blog We don't have any documentation on the External Activato ...Show All

• Cory6132 Dynamic Columns & Dynamic Grouping ???

  Hi, We need to design more than 500 Reports for our ongoing project and we are dealing with MS SQL Server Reporting Services first time. We are currently confused in 2 things 1) How to manage Reports I mean we should store entire report in database and load at runtime or simply store as a report file 2) Most Important is Dynamic Columns & Dynamic Grouping . We need something like Microsoft Office Accounting 2007 Reports. Header part of form has some parameters for filter and right part has some parameters for showing or hiding and reordering columns and groups. We are not getting clue for this dynamic stuff. Can any one post working sample or at least necessary basic code with some idea ...Show All

• VBScriptor Merege Replication Failed

  Hi Guys im newbie but need to learn more of it so please cooperate with me and slolve my problem. my Sql Server starts merging and it starts dumping the scema and data after some time it the status shows failed, it doesn't give any error message also. please let me know what to check and how to resolve this. yeah there is an error saying that " The process could not deliver the snapshot to the subscriber. Note:The step was was retried the requested number of times(10) without succeeding. the step faild." So please let me know wht to do on this. Thanks and Praises in advance. The merge agent must be saying something Are you looking at the SQL Serrve ...Show All

• Gwindor Snapshot isolation

  I have a online  shopping cart system. I have been getting this message from time to time. I am exec a stored proc that updates and inserts records. Has any body ran into this error. An order was not added to the database due to the error: Snapshot isolation transaction failed in database 'databasename' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction.  It is disallowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation.  I am running sql 2005 standard 64 bit   declare some input variables @cust,@packge as set nocount on ...Show All

• Fabio Scagliola Performance problems with SQL commands in data flow task

  SQL statement within an OLE DB Command component is extremely slow (hours, days). Same SQL statement executed within a query window of SQL Server Management Studio takes only a few seconds. Using a fairly simple SQL UPDATE statement against a table with only 21,000 rows. Query: UPDATE Pearson_Load SET Process_Flag = 'E', Error_Msg = 'Error: Missing address elements Address_Line_1, City, and/or State' WHERE (Address_Line_1 = ' ' OR City = ' ' OR State = ' ') AND Process_Flag = ' ' Any suggestions on how to improve the performance of this task or an alternate solution are appreciated. Thank you. Thank you Phil! I just moved the queries (I actually had 4 separate queries) that I was exec ...Show All

• Noam Lewis Simple flat file import

  Boy, do I need HELP! Have a simple csv file that I need to import. Worked fine in sql2000; I put it into dts to execute on a monthly basis. Makes connection, db connection, table creation fine, but stops at validation of flat file Basically, I want to go out and get a flat file, drop the existing table, and create the table, and import the information from the flat file. Not a complicated table of about 30,000 records. Create table [db].[dbo].[tblPatient] ( [patientID] into not null, [chartID] varChar(15) null, [doctorID] int null, [birthdate] datetime null, [sex] varchar(1) null, [raceID] int null, [city] varchar(100) null, [state] varchar(2) null, [zip9] varchar(9) null, [patientTypeID] int null, [patName] varchar(100) null) Be ...Show All

• John Bock Installing SP 1 for SQL server 2005

  I am getting ready to install SP 1 for 2005 on two servers. Are there any outstanding issues with SP 1 that I should prepare for Paul, you should take this to the Setup forum, rather than the SMO forum. Be sure to apply the post hotfixes after installing the SP1, they fixed many problems of the different components. More on: http://sqlserver2005.de/SQLServer2005/MyBlog/tabid/56/BlogID/1/Default.aspx HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Nope SP1 should work for you just fine. Michelle Moved to the setup & Upgrade ...Show All

• JacksonJones sql2000 on win2003 server

  Hi, I want to install SQL 2000 Server on Win-2003 STD Server and transfer the database that has been running on SQL-2000/Win 2K server. Win-2003 Server has Apache services and TrendMicro AV Server running. After installation the SQL service starts automatically. But I am not able to see the database from Enterprise manager. It gives error 'A connection could not be established to <local>. Reason: Login failed for DOMAIN/USER. I am logged into Win2003 server as 'Administrator' for installation. SQL Server authentication in Mixed Mode and connect using Domain user account. While applying update(SP3) also the same error comes after trying to validate password and the Sql service automatically stops. I tried using bo ...Show All

• Timotei Date in String doesn't work

  Can anyone please tell me why this query works: DECLARE @valuation_date smalldatetime, @non_admit_date smalldatetime SET @valuation_date = '2006-03-31' SET @non_admit_date = DATEADD(dd, -90, @valuation_date) SELECT SUM(Premium) FROM Reserves WHERE Reserve_Paid_to_Date >= @non_admit_date And this one does not: DECLARE @valuation_date smalldatetime, @non_admit_date smalldatetime, @arc_sql nvarchar(4000) SET @valuation_date = '2006-03-31' SET @non_admit_date = DATEADD(dd, -90, @valuation_date) SET @arc_sql = 'INSERT INTO Results SELECT SUM(Premium) FROM Reserves WHERE Reserve_Paid_to_Date >= ' @non_admit_date SELECT @arc_sql exec sp_executesql @arc_sql The second one gives me this error: "Syntax error converting ...Show All

• filson partition switch and non unique index

  I have a table partitioned by month. There are no primary key. There is another table with the same structure that I use to load data for the current month. I can perform partition switch with no problem. I created non unique index on integer field in both tables. After this change partition switch does not work anymore. Here is an error that I am getting: 'ALTER TABLE SWITCH' statement failed. The table 'dbo.test' is partitioned while index 'IX_test' is not partitioned." Any help what if i just drop my composite index from the table that needs to be switched but maintain the partitioning index Since the destination table  has its own composite index ...Show All

• David Parreira Replication between SQL Express 2005

  Hi All, I am trying to do a Replication between a network SQL Server Express Edition 2005 DB with a client SQL Server Express Edition 2005 DB. My question is 1. Can we do replicaiton between SQL Server Express Edition 2005. (No SQL SERVER present) 2. If yes can any of you provide me some guidance or some pointers on how to achieve it. Thanks Suresh Quick answer is no. Check out the following posting for more info. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=941980&SiteID=1 Gary ...Show All