SQL Server

Page 954




  • Topics
    Replies
    Last post
  • Inherent Performance: Materialized Referenced Relationships
    by DanUp
    3 Replies
    Last post by Darren Gosbell
      • Suppose that I have a data-mart design choice of either creating one or two (related) fact tables. As a note, although the fact granularity is the same (one-to-one), the tables would not contain any of the same fields. I prefer separating the two tables (into fact_a and fact_b), in order to avoid the many null measure values in the combined table, which I expect would hurt query performance.
  • cannot install integration services
    by Mathias Raacke
    14 Replies
    Last post by Ingo
      • Hi! During the installation of integration services (SQL 05 Developer RTM) I get the following error: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ Failed to install and configure assemblies C:\Programme\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error description: Faile
  • Rebuilding a huge clustered index
    by Andy Fordyce
    3 Replies
    Last post by Marcel van der Holst - MSFT
      • I have a client that has a 800GB table. The current clustered index on this table is of low selectivity and is causing index scans on queries. I wish to drop the current index and create a new one that is of more use. What i really want to know is, what is the fastest method of rebuilding such a huge index What would be the storage requirements to process this
  • com plus catalog requirement?
    by subhaniG
    2 Replies
    Last post by Emanuel Peixoto
      • Hello, this is Subhani . I am installing Sql 2005 standard version. The problem is that while I am installing Sql 2005 the two warning messages are given that ¡°com plus catalog requirement¡± & ¡°minimum hardware requirement¡± So please suggest me, what I have to do to install successfully
  • SQL Server 2008 : Merge T-SQL Command
    by Dinesh Asanka
    4 Replies
    Last post by Umachandar Jayachandran - MS
      • Declare @Code varchar ( 3 ) Declare @Description varchar ( 15 ) Set @Code = 'ABC' Set @Description = 'Merge' Merge into tblData T USING TblData S ON S . Code = @Code WHEN MATCHED THEN UPDATE SET t . Description = @Description WHEN NOT MATCHED THEN INSERT ( Code , Description ) VALUES ( @Code , @Description ); selec
  • Run scripts on multiple servers in SQL Management Studio
    by RMarmion
    4 Replies
    Last post by Dan Ward
      • I have a number of scripts that I need to run on multiple servers and databases. Once I have created a Solution with them all in, how do I make them run in a specific sequence, and how can I switch the focus of the entire set of scripts to the other databases I want to run them on Thanks, -Rob
  • single node cluster
    by hmayer
    5 Replies
    Last post by Arfur
      • Is it possible to setup an cluster with sql server 2005 as single node cluster - and lets say in 4 month we add the second node to the cluster - its because of budget and we do not want to setup then again. Thanks for your help, HANNES
  • Microsoft Access Database Synchronizer (ADS) RTW
    by Laxmi Narsimha Rao ORUGANTI MS
    14 Replies
    Last post by Manish Agnihotri
      • Hi, Today we are very pleased to announce the RTW release of Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Compact Edition database on a device. The salient
  • Is it possible to write If/Then Else within SQL Select Statement for vb.net?
    by nbk5533
    1 Replies
    Last post by Arnie Rowland
      • I'm running a select statement from within my VB.net code. However, if the software package name that I chose from a drop down list in my form is not available in the search (in the Table\Column called Software.Package_Name), I would like to be able to write the message "Record Not Found" to the Package_Name "ListBox" column. Here's the select statement: "SELECT
  • IIS and SQL Server 2005 Express Edition
    by TimR_246
    6 Replies
    Last post by Mike Wachal - MSFT
      • hi Currently have SQL Server 2005 Express Edition installed. Wanted to install reporting services, but wouldn't let me re no IIS as I only have Windows XP Home Edition. My question is therefore: Is there any way of installing IIS to allow me to install Reporting Services for SQL Server 2005 Express Edition Many thanks Tim Leicester, UK
  • How to determine min. datetime in mdx
    by pmak
    1 Replies
    Last post by hmayer
      • Say I have 2 columns, id and date as follow: id date 1 11-Jan-2007 1 18-Jun-2007 2 21-Mar-2007 2 19-Sep-2007 How to write a mdx function to filter out on each id with the min date as follow: id date 1 11-Jan-2007 2 21-Mar-2007
  • Sum Function
    by kj577826
    14 Replies
    Last post by Deepak Puri
      • I have a cube which as a time dimension by year (2001 through 2007). I have set up a report that allows user to select which years to see...However, I also have some additional calculations that require that I sum the number of accounts over the time period that they selected. Sum([Time Dimension].[Close Year].[All],[Measures].[Number of Accounts])...If the user selected years 2003 through 2006, I
  • Error while merging snapshot containing a CLR assembly schema at the subscriber
    by sixthowl
    2 Replies
    Last post by sixthowl
      • Hi , I urgently need a solution for this. I have configured merge replication between a webhoster and a local machine and it is working perfectly but when I am adding an article (table) which has a CLR assembly associated with it, the merge replication is failing saying it cannot apply the schema of the CLR assembly at the client. I think Microsoft supposedly says in it's documenta
  • SSIS - Turning Unicode OFF
    by Rohan - RSRK
    3 Replies
    Last post by Jia Li MSFT
      • All: When creating a package, SSIS assumes varchar columns as Unicode (DT_WSTR) so before loading data into the target tables, I have to perform a data conversion from DT_WSTR to DT_STR. Is there any way to turn UNICODE off So I do not need to do the conversion Please advise... Rohan
  • Report Server issue
    by mcssnt
    5 Replies
    Last post by GregSQL
      • Hi, when I open my report server ( http://localhost/reportserver ) in IE doesn't show the option to delete, new folder, new data source, etc, IE shows all like a FTP explorer with flat text and hyperlinks, I can't delete a deployed solution, how I can install, reconfigure or fix this issue Marcos
  • Help, index out of bounds error
    by sadie519590
    5 Replies
    Last post by sadie
      • Hi, I really don't know why I'm getting this error! Index was outside the bounds of the array. I am reading a comma-delimited flat file, line by line. This is part of my script component: Public Overrides Sub Input0_ProcessInputRow( ByVal Row As Input0Buffer) Dim rowValues As String () rowValues = Row.Line.Split(columnDelimiter) 'parse rows by comma
  • Queried parameters
    by phorest
    6 Replies
    Last post by phorest
      • Hello, I need to be able to set the date parameters of a report dynamically when it is run based on system time. The problem I am having is being able to compare the dates (StartDate & EndDate) against [Service Date 1]. Essentially this report will only pull the current month's data. The date fields being created with the GETDATE, DATEADD & DATEDIFF functions are working correctly. D
  • How to return multiple values from stored procedures
    by Raju1260
    3 Replies
    Last post by Raju1260
      • How to return multiple values from stored procedures to reports in sql server 2005
  • how to set permission for a database
    by sridhar_msd
    4 Replies
    Last post by Raul Garcia - MS
      • hi, I need to do a security setup in SQL server 2000. the scenario is as follows: In a team, only one person(Team Leader) should access the particular DB (through Enterprise Manager and rest of the persons in the Team(developers) should access through code. How to do this. Thanks and Regards
  • Can you rename a namespace?
    by Bobinazee
    3 Replies
    Last post by Bobinazee
      • I recently restored an entire database hosted on a remote server onto my local PC. These are tables I created for an ASP.NET project I'm working on. Unfortunately, the tables are restored with a different namespace (I think that's what it's called). So, dbo.Authors restored as dbo19738468.Authors. The 19738468 is the customer number that was assigned to me by my Web host, where I backed up
  • accounts passwords not changed greater than > 90 days
    by Anand Tailor
    0 Replies
    Last post by Anand Tailor
      • I am trying to determine all of the accounts on a sql 2000 box which have not had their password changed beyond 90 days, specifically the SA account. I ran this query on a local box: SELECT * FROM sysxlogins WHERE datediff(day,xdate2,getdate()) > 90 The problem is I belive that I am getting remote server and linked server hits. I only want to check the SA password on the box
  • Skipping leading rows in Excel
    by Dhanasu
    6 Replies
    Last post by Brent Mitchell
      • Hi All, While we are loading the text file to SQL Server via SSIS, we have the provision to skip any number of leading rows from the source and load the data to SQL server. Is there any provision to do the same for Excel file. The source Excel file for me has some description in the leading 5 rows, I want to skip it and start the data load from the row 6. Please provide your thoughts on this
  • patindex with nvarchar
    by HarshalChoksi
    14 Replies
    Last post by Manivannan.D.Sekaran
      • Hi Microsoft, My Name is Harshal Choksi. i am working in microsoft technolgy in .NET and SQL Server 2000. we are storing some unicode data in database in table which has a nvarchar data types. i have written one function in SQL which contains some T-Transact function like SubString, Len & PatIndex. in which i m not getting any value with PatIndex, it shows me always column with 0 value.
  • Problem in Chart
    by V.M.Senthil
    1 Replies
    Last post by GregSQL
      • Hai all, I am generating chart using the Sql Reporting services.I have done 2 charts. when i am clicking one chart it will navigate to another chart.It is happened in reports. when i used in UI page(web Page). when click the chart it is not navigating to another chart.The same chart will appear when i click the chart. Can u guys help me soon to solve this problem.. Thanks In advance.
  • Selected value of dropdown
    by YWLMB
    6 Replies
    Last post by Mr.L
      • How would I reference the selected value of a dropdown parameter in SSRS using VS2005 For instance, the city Miami is selected I want to find out if both dropdowns match eachother... iif(dropdown1.selected.value = dropdown2.selected.value,false,true)