SQL Server

Page 1979




  • Topics
    Replies
    Last post
  • Attribute Hierachies
    by Van Dieu Thai
    4 Replies
    Last post by dev88
      • Hi there. I have a problem that I have been struggling to understand. Here is the situation. I will use a time dimension just as an example. If I build a time dimension containing 2 Years of dates from 2005 to 2006 with 3 attributes: Year, Month, Date and set my attribute relationships as Date ->Month and Month -> Year. In management studio I can drag over Month and then Year (in that par
  • Dynamic Lookup .... is it in SQL 2008?
    by MichaelT
    7 Replies
    Last post by Jamie Thomson
      • I'm finding that not having the ability to dynamically change the contents of the query in the lookup transform is a major, major problem. Has anyone looked to see if this is in the SQL 2008 CTP Does anyone have any good work arounds Thanks, Michael
  • Conditionally CREATE a VIEW in a script
    by Smoc
    9 Replies
    Last post by Ennor
      • Hi, I would like to create a view depending on a condition check first. However, I do not seem to the able to put a 'CREATE VIEW' within an IF statement. The following example demonstates what I am trying to achieve (please excuse the triviality of the example): IF NOT col_length('authors','city') IS NULL BEGIN CREATE VIEW TestView AS SELECT (au_fname + ' ' + au_lname) as
  • SQL 2005 merge replication extended logging
    by ArronBrice
    5 Replies
    Last post by Grant_csi
      • Hello, I'm trying to enable extended logging to resolve some conflicts. After doing a google search, I found KB312292 which says to follow what's in books online on modifying the merge agent. I tried to add the following parameters in the agent profile: -Output x:\merge.txt -OutputVerboseLevel 2 When I save the profile I get an error saying that SQL was expecting an integer for -Output.
  • SQL Express reinstaling
    by stefanko
    2 Replies
    Last post by stefanko
      • Hi all I have installed SQL Express and later downloaded newer version. After I have uninstalled older version, when I have tryed to install new one, I saw that older instance of SQL Express is not removed and I must choose some different name for new instance of server. Even system restore could not help. Is there a way to completly remove everything related with SQL Express server
  • Exporting the roles from the cube to CSV file
    by NarasimhaG
    1 Replies
    Last post by Darren Gosbell
      • Hi I wanted to export the roles into CSV file from the Cube. we are usign SQL Server 2005 Analysis Server (9.00.3186.00). We wanted to compare the CUbe roles versus Database. The check is due to corruption of the cube while updating one of the user. I have tried to export the roles. Can any one guide me regarding this, How can i achieve this . Is there any approach .. Thanks
  • Null Left Join
    by Lawrence Carvalho
    4 Replies
    Last post by Lawrence Carvalho
      • Hi guys, I need to get data from a join between two tables, but I just want the data that exists in first table and not in second one. It's like: SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.col1 = t2.col1 WHERE t2.col1 IS NULL I'm using the merge join transformation, but I can't find no options to put the WHERE code in the join. How can I do that Anyone can help me Cheers!
  • Get the tool for the database comparasion
    by Jodie15
    4 Replies
    Last post by Joe Webb
      • Hi All, Do you know any good tool to compare the content of two database. Thanks, Jodie
  • Error 5180: Could not open FCB for invalid file id : 120
    by Anonymous1022
    2 Replies
    Last post by Sheila_bfw
      • '"Error 5180: Could not open FCB for invalid file id : 120" When we attach the mdf and ldf files we get this error, what can we do to restore the database
  • SQL Server 2005 SP2 CTP web parts and Sharepoint integration mode.
    by LuisRH
    2 Replies
    Last post by Teo Lachev
      • My question is related to the setup of this environment when you are starting from scratch.. It seems that the report list web part takes an reporting services ReportManager URL, but since the reports I added end up in a sharepoint store, it seems there is a disconnect. I am missing something or are these web parts specifically geared towards non-sharepoint mode usage Another question is rela
  • Can someone help me in understanding the output of this TSQL script
    by lndsouza
    6 Replies
    Last post by lndsouza
      • declare @startdate datetime declare @enddate datetime declare @testvalue datetime set @startdate = '2005-12-31' set @enddate = '2006-12-29' set @testvalue = '2006-05-17' if convert ( varchar ( 20 ), @testvalue , 102 ) between convert ( varchar ( 20 ), @startdate , 102 ) and convert ( varchar ( 20 ), @enddate , 102 ) print 'yes' else
  • Creating an Windows Rdl on the fly using .net programming
    by p4Pratik
    14 Replies
    Last post by GregSQL
      • Hi, I would like to know that can I create an .rdl file programmatically based on the user selection (USING .Net programming) . Please help with some link / examples. P.S: I am giving very less number of static reports to the client. I want to give a more of a dynamic report , wherein in each case, I will give the user a selection criteria to select the fields fro
  • SQL Server 2005 Workgroup - no Local Publication tab
    by iversona
    5 Replies
    Last post by dfdsfsaf
      • Hi I've recently gone through installing and setting up merge replication on Server 2005 Standard. All working. I am now setting up a different box with SQL 2005 Workgroup with SP2. When I go to the Replication tab in Management Studio there is only Local Subscriptions - No Local Publications. I've re-run the installation but I can't see how Publications is not getting install
  • How to keep header remain visible while scrolling
    by adb96hxo
    1 Replies
    Last post by Vronsky
      • Hi, I have matrix which has many rows. Is there any way to keep header remain visible while scrolling I tried to set "Group header should remain visible while scrolling" in my columngroup property but got the error: [rsFixedHeadersInInnerDataRegion] The matrix ¡®matrix1¡¯ includes a table header or column with FixedHeader set to true. This is not allowed on data regions in
  • Global expression apply to all fields in report
    by Nick Sheng
    4 Replies
    Last post by Nick Sheng
      • Hi All, I got a situation that need to write a expression for doing if the value is negtive then display () around this value, and this expression should apply to 30 fields in my report. so i just wonder is that any way that i can create this expression as global variable , then i can use this expression in each field, instead of i write IIF function in every field expression area.
  • Saving Queries
    by bar_flyz
    6 Replies
    Last post by Lisa Nicholls
      • I just started using Visual Studio 2005. How do you actually save your queries to use again Also, is there a way to export results in a user friendly format thanks!
  • SSIS configuration option
    by TPK1216
    2 Replies
    Last post by Rafael Salas
      • Hi, I would like to know what is the difference between XML file and Database in SSIS configuration option. Thanks, K
  • Truncation errors
    by windthorstking
    6 Replies
    Last post by EWisdahl
      • We use SQL Server 2005 x64 Enterprise and I have created a SSIS routine to replace a legacy DTS routine that reads from a Data Reader Source and writes to a SQL Server 2005 database. The field I am receiving the truncation error on is "Description" and it is set as nvarchar(50), which it always has been, and the old DTS routine works fine on it. I checked the contents of description and
  • update statement
    by Badpig
    14 Replies
    Last post by Badpig
      • Newbie Question: Im trying to update a table column to a new value and I receive an error, here is my statement: USE PD51_Data; GO UPDATE CASENUMBERS SET CaseNumTypeID = 130 WHERE CaseNumTypeID = 101 AND CaseNumber BETWEEN 199999 AND 600001; GO I receive this error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '9368----' to data type int.
  • What is Table Scan, Index Scan and Index Seek??
    by prashant_victory
    4 Replies
    Last post by prashant_victory
      • Hi, I want to know wht is a TABLE SCAN INDEX SCAN INDEX SEEK and When they are used, Wht is the difference between all these.
  • The RPC server is unavailable exception - while performing web farm installation
    by mikelyc
    14 Replies
    Last post by gcolton
      • Hi I am trying to create a scale-out deployment of Reporting Services 2005 on a NLB cluster web farm by following the instructions in: http://technet.microsoft.com/en-us/library/ms159114.aspx However, when I install and configure Reporting Services on the second node, and then go back to the first node to join the second node to the scale-out deployment (as described in step 11 under '
  • Grouping in Table
    by Samtadsh
    14 Replies
    Last post by Samtadsh
      • Your help on this could make my day a better one .... I was trying to create groups on a table report item in SRS 2005 report. The criterion I'm using in one group is exact opposite of the criterion I have in the next group. My dataset has records which fulfill both criteria but my table displays only records for the first group. Is there a limit on the number of groups we can use in
  • Log File size increase
    by shah_hs
    1 Replies
    Last post by Satya SKJ
      • I have set up an alert for Percent log used and i get this message every now and then: The SQL Server performance counter 'Percent Log Used' (instance 'TelehopBilling') of object 'SQLServer:Databases' is now above the threshold of 90.00 (the current value is 95.00). My database settings are: Transaction log files space allocated file1 1 mb file 2 3 mb
  • Chart legend returns incorrect colours as compared to the bar chart
    by Thulz
    0 Replies
    Last post by Thulz
      • Hi there, If anyone can speedily assist here I will be so greatful. Ok, here's the problem: Bar chart has been customised to diplay "Red" - None, "Yellow" - Partial, "Green" Fully. The bar graph legend does not display correct colours that correspond with the colours on the bars. It sometimes returns the 'old' default colurs of the chart depending on whether the b
  • How to use the split function
    by Downforce
    7 Replies
    Last post by Downforce
      • Hi everyone, i need to split a string in different columns in my database. But now i m using the len method to seperate my data, this works well with date and time function cause its static. But when there's a name in the string it will give problems cause the LEN method is not flexibel. So i try to use the split function, but i dont know where to put in my following query: