SQL Server

Page 2121




  • Topics
    Replies
    Last post
  • Creating Dynamic dimension Security with Custom Procedure
    by JNHL
    2 Replies
    Last post by JNHL
      • Hi All, We are trying to implement dynamic dimension security using a Custom procedure written in C#. If we create a single entry in the return set everything works fine (See Below) Microsoft.AnalysisServices.AdomdServer. Expression Expression = new Microsoft.AnalysisServices.AdomdServer. Expression (); Expression.ExpressionText = "[Sub Branch Id].[All Branch].[4]" ; Mic
  • Invalid Character in Flat File or Turncate problem
    by mariap
    14 Replies
    Last post by mariap
      • My source is a csv flat file. Currently I use that same flat file on SQL 2000 and SQL 2005. On SQL 2000 it runs fine and it inserts that character as part of the string (varchar), however, it gives me truncate error on sql 2005. I already use the "Suggest Types...." and my Output columns have the correct lenght (specially that lehght of that column is only 30 char which is less than
  • Checksum transformation is not detecting my change
    by LuCarD
    9 Replies
    Last post by cborden
      • I am using the Konesans Checksum transformation ( http://www.sqlis.com/21.aspx ) to detect changes in my big (many columns, type 2 SCD) dimensional table. But I am running into collossions The checksum transformation, sometimes misses a small change in the record, for instance when a certain flag is set or unset. Is there a more robust checksum generator Of any other suggestions on to solve this
  • Hiding a table row depending on page number?
    by Palmie
    14 Replies
    Last post by Lisa Nicholls
      • Hi, Everyone. i am wondering if there is some way to hide a table row depending on the page number. I have tried to find a way to access the global page number to use it in an expression for the visibility property on the table row, but i havent found anything useful.
  • SQL Server 2005 remote connection failure
    by Prabal
    9 Replies
    Last post by oj
      • I'm having a big problem with a SQL 2K5 cluster (using standard edition). I can get onto the box and connect to the sql server locally fine. However when I try to connect remotely I get errors. Let's call the two sides of the cluster, CL1 and CL2 and the "virtual server" is CL3. Locally I can connect without any problem at all to the SQL server, but I just can't connect to it from
  • ads wizard: Failure to open SQL Server with given connect string
    by Roger Ellingson
    5 Replies
    Last post by Roger Ellingson
      • Hi, sorry but I am just getting my feet wet with the ADS wizard. I have managed to get the PPC emulator running the ADS wizard and have the emulator ActiveSync connected with desktop. Port 1024 opens from the emulator to the desktop. On the ADS wiz I can connect to the device .sdf. WHen I try to connect to the desktop I am getting a connection failure in the ADS wiz log and after stepping through
  • Address field problem.
    by bkana
    4 Replies
    Last post by bkana
      • I have a number of text boxes (one on top of the other) to display the addresses in my report. I have Address_name, Address1, Address2, Address_city, Address_State, Address_PostalCode - Each with its own text box except for the city, state, and postal code for which I just combined the fields. However, I have many who do not have any data for Address2 and don't want an empty line in the address. I
  • Oracle connection fail with Microsoft OLEDB provider for Oracle MSDAORA.1
    by Philippe Cand
    10 Replies
    Last post by frozen12
      • Hello, On my dev server I have working ssis packages that use connections Microsoft OLEDB provider for Oracle MSDAORA.1 and Oracle provider for oledb and OracleClient data provider. I use one or the other according to my needs. In anticipation and to prepare for the build of a new production server, I have build a test server from scratch and deployed to it the entire dev. Almost every
  • Populate flatfile source from variable
    by spacelord
    4 Replies
    Last post by Phil Brammer
      • We are storing incoming flatfiles into a text field in a table and then we are processing this table on a regular basis. What I would like to do is to get this flatfile from the textfield and populate a flatfile source with it, but so far I have only been able to do that with XML files as there are no option for doing that with the flatfile source. Using the disk as a temporary storage for the fla
  • Web Services And SSIS
    by JamFisk
    1 Replies
    Last post by Jamie Thomson
      • I am having trouble executing the example from microsoft that call a DTS package from a web server. I alway get Service Failed. I have loggin on in the pagage and it doen't get that far. I have set up IUSR_<machine> with access to sql server and granted approiated file permissions. The package loads but fails on execution. I can run the same code as a console app and it works. Any help wo
  • Sql Server 2005 not starting
    by Raj Thilak
    28 Replies
    Last post by Raj Thilak
      • Hi,       I have my web application with backend  as Sql Server 2005 CTP(Yukon). Initially It works well. I updated some security settings to the OS Windows Server 2003 and restarted the machine. Now the Sql Server is not starting.When I manually started  It logs error as follows. 2005-10-13 03:39:57.85 Server      UpdateUptimeRegKe
  • Package taking 100% of the CPU when it is opened for editing in visual studio
    by Mallikarjun n Channappagoudra
    5 Replies
    Last post by Mallikarjun n Channappagoudra
      • I have a package that I was able to edit a week before. But now it is consuming all CPU memory (100%) and not letting me to edit the package (When I try to edit that it says Visual Studio Is busy even after an hour waiting). Even though I have not changed anything, the package is behaving like this. I would appreciate any reply on this Thanks in advance
  • Import text file to SQL Server
    by Tarana
    5 Replies
    Last post by DaleJ
      • I have a project which I need to do the following steps: 1.Look for a partular file .txt in a directory. If the fil exists, loadn txt file ino SQL Server. 2. If # 1 was sucessful, then delete the source file. Every day, do the same thing ie check for existence of file, import into sql table, then delete the file. Pl advise the best way to do this:
  • Restore sql server 2000 backup on sql server 2008
    by Viv Sas
    2 Replies
    Last post by Kevin Farlee
      • Based on the books online I am not allowed to upgrade a database at sql server 2000 to sql server 2008. But I tried restoring the sql server 2000 backup on the Katmai release available and it works. It initially did have the database in sql server 2000 compatibility mode but later I was even able to change the mode to be 2008 compatible. So what is it am I allowed to do it or not
  • NON_EMPTY_BEHAVIOR if NON EMPTY isn't used
    by furmangg
    3 Replies
    Last post by Mosha Pasumansky
      • A cube I'm working on has lots of calculations. But none of the MDX queries in the reports use the NON EMPTY clause or the NonEmpty function. What I'm wondering is whether the optimizer or any other part of the Formula Engine uses NON_EMPTY_BEHAVIOR for anything else besides removing empty cells from the resultset. If the Sum function is summing two calculated measures, will a NEB on those two
  • XQuery: Error converting data type nvarchar to numeric.
    by lcj
    2 Replies
    Last post by Kent Waldrop Au07
      • I am trying to run a query off of a xml data type using Xquery (nodes() and value() methods) but am running inot a conversion error for a numeric type in the xml which is empty or blank. I want it to come back as null but it looks like it is trying to convert an empty string. Is there any way that an empty tag could pull back a null
  • ClusterDistance value
    by DanMeyers
    4 Replies
    Last post by DanMeyers
      • Can somebody please define the result of the ClusterDistance() function for me.  BOL and MSDN are vague about what the output means and I am getting some cases that have a value of zero and sometimes there are more than one per cluster.  Thanks in advance, Dan Meyers
  • SQLSTATE 42000- Error 15404 with ADS
    by Pereira
    8 Replies
    Last post by Kay Zumbusch
      • Hello, I'm having trouble running jobs with my active directory (ADS) account. I've setup my SQL services to run under an ADS account, but jobs cannot seem to query ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2. Here is the error message: == The job failed. Unable to determine if the owner (ADS\me) of job eFASRtest has server access (reason: Could
  • Help with installing/setup of SQL Server 2000 Trial
    by BigO575043
    14 Replies
    Last post by Arnie Rowland
      • I've installed SQL Server 2000 trial on a standalone XP Pro machine as a local server, however the debugger does not work correctly. I will not allow me to step into the code of stored procedures. Can anyone provide me assistance in resolving this.
  • How to select the "Select All" checkbox parameter?
    by pmak
    1 Replies
    Last post by BobP - BIM
      • When passing the prameter values to a linked report, I want to set one of the parameter at the linked report to "Select All", this was added automatically to the parameter list when multivalue report parameter is used . How to set this "Select All" as a parameter or can it be done Thanks
  • Trigger in the Subscription database - Transactional Replication...
    by Swapna.B.
    11 Replies
    Last post by Swapna.B.
      • Hi, We are Using Transactional Replication with Updatable Subscription in SQL Server 2005 SP1. Subscription Type : Pull Subscription Mode : Continuous Running Mode Conflict Resolution Policy : Publisher Wins. I have a table " Sample " (which is part of replication) and it has got 3 triggers. All the triggers are set NOT FOR REPLICATION . The first trigg
  • Dimension Hierarchy does not allow duplicates
    by Dan Perlman
    7 Replies
    Last post by Thomas Ivarsson
      • Hello, I am very new to data warehousing. I have created a hierarchy on "StoreID", "Make" and "Model". The Make "Harley" should appear below all of our Harley-Davidson store ids. It looks like there are no duplicates of any make or model in the hierarchy when I browse the dimension. I am using BI dev studio and SQL 2005 analysis services
  • UniqueIdentifier error in SSIS
    by Satish D
    4 Replies
    Last post by Bob Bojanic - MSFT
      • Hi, I got problem when i am sending the data from source to destination. My source is Sql Server 2005 and My Destination is Sql Server 2005. In Source table the column name is defined as numeric datatype. In Destination table the column name is defined as UniqueIdentifier. When i send the data from Source to Destination i am getting this error.
  • SharePoint on SQL Server 2008??
    by charlyn
    0 Replies
    Last post by charlyn
      • Hi Is it possible to run SharePoint 2007 on a SQL Server 2008 Is there any information/documentation about this issue Thanks /Charly
  • Report Header woes
    by Scott Steigerwald
    12 Replies
    Last post by Lisa Nicholls
      • I am creating a report which consists of data in two columns. I've set the Body section to have 2 columns in it. This works fine until I start working with the report header. I do not want a page header that shows up on every page, I only want a header on the first page, a report header. I first tried to hide the header by placing it in the Page Header section, then putting in the "page &g