SQL Server

Page 3000




  • Topics
    Replies
    Last post
  • Copy and Past a row
    by SY Tee
    7 Replies
    Last post by SY Tee
      • Hello all, Is there a way for me to copy a row, do some modification in a certain row and insert it to the same table as a new row Forward with thousand thanks. Best regards, Tee Song Yann
  • Excel export problem when matrixes are side by side
    by nostrum67
    0 Replies
    Last post by nostrum67
      • If I export to excel ,when Report has two matrixes side by side datas are missed....Is there anything to do
  • PerformancePoint Configuration Error: Starting service: w3svc: StartServiceByName failed with HRESULT 8007041d
    by Habeeb
    0 Replies
    Last post by Habeeb
      • I am configuring PerformancePoint Planning Server (CTP2) using configuration manager. It fails at the last step: Configuration failed. Error 1: Start registering ASP.NET scriptmap (2.0.50727) recursively at W3SVC/616204989/Root. Finished registering ASP.NET scriptmap (2.0.50727) recursively at W3SVC/616204989/Root. Setup has detected some errors during the operation. For details, pleas
  • Dimension, CurrentMember and a hierarchy
    by John Hennesey
    1 Replies
    Last post by JohnHennesey
      • Greetings - I am writing some MDX for a RS report, and seem to have hit a bit of a wall. The business folks keep changing their minds on what hierarchy they want to report from, so I would like to have it as a parameter to the report. Problem is that I don't know if there is a way to get the CurrentMember.Properties('Caption') without explicitly declaring the hierarchy. My MDX: With
  • Tracking Execution Time of each step?
    by CraigL77
    4 Replies
    Last post by CraigL77
      • hi, i am currently in the process of moving a bunch of jobs into SSIS from another ETL tool. I would like to benchmark the two products against each other by comparing how long each step of an ETL process would take. I see no way to do this in SSIS, there is the Progress tab but it doesnt list start/time and end/time. Plus I having loops and things which I want to know how long each
  • Database save and restore
    by Cesar Francisco
    14 Replies
    Last post by Cesar Francisco
      • Hello, A database EntryForm has a MenuStrip. How could the Menustrip implemented that it would have a Save and Restore data to the database for backup purposes What is the Menustrip for None of the standard Items seems to work. What can be printed or previewed This question is NOT about how to save the data into the database from the EntryForm. Thanks for any answer,
  • ROW_NUMBER() paging - CTE or subquery ?
    by Andrew Mackie
    1 Replies
    Last post by Konstantin Kosinsky
      • For paging in SQL 2005, ROW_NUMBER() is recommended. But is it best practice to use that with a CTE or a Subquery I get the same query plan for the two examples below. One link I found suggests CTEs are preferred: http://weblogs.sqlteam.com/jeffs/archive/2007/03/30/More-SQL-Server-2005-Solutions.aspx Thoughts on this Thanks, Andy Mackie Code Snippet USE Advent
  • SIngle transaction batch script without go's ???
    by Dietz
    9 Replies
    Last post by Dietz
      • Hi There I am trying to write a script that applies all changes to a database within a single transaction, eveything must be applied or not. The issue i have is with the following: BEGIN TRAN INSERT INTO ..... UPDATE ..... ALTER TABLE A ADD COLUMN INSERT INTO TABLE A VALUES ... COMMIT The issue i have is that the insert after the ALTER TABLE refer
  • Dataflow Tab:There is no ODBC Source option in the Toolbox
    by Mr Pro Tools
    5 Replies
    Last post by Phil Brammer
      • I need to extract data from tables in a database that I can only access via ODBC. I have successfully created a connection in Connection Manager (ConnectionManagerType = ODBC) for this database. However I¡¯m unable to add this connection as a Data Flow Source. There is no ODBC Source option in the Toolbox. This is a major because we have been using the system dsn Microsoft Visual Foxpro Driver
  • How to create Report Model Project for OLAP Cube
    by Raghava Narayana
    1 Replies
    Last post by Naveen J V, Bangalore
      • Hi , Please tell me how to create Data Source and Data Source View in Report Model Project for OLAP Cube.Whats the provider to use while creating Data Source in Report Model Project to make connection to OLAP Cube. Thanks Raghava
  • Log files grows indefinitely and causes ETL to fail
    by rok557261
    7 Replies
    Last post by Thomas Ivarsson
      • Hello; I 'm feeding my warehouse through SSIS. When I run a package that does full load from staging to the fact table(which takes 7hrs at least) the log runs out of space. I've added space to the log drive and created a job that shrinks the drive every 10mins but still it does'nt seem to solve the problem. I'm having this problem since I created a primary key column in the fact tabl
  • SSIS - Best way to copy files from one directory to another
    by Linda Cornerstone
    14 Replies
    Last post by Linda Cornerstone
      • In SSIS, I was to: take files from c:\directory1 copy them to c irectory2 with a different name (concatenated date on the end) delete them from c:\directory1 Should I be using the Script Task for this I am wondering if I should be using the File System Task which copies directories or files, but I don't know if I could rename the files during the copy. Also, I want the direct
  • MDX - Group By functionality
    by Zach84
    1 Replies
    Last post by Deepak Puri
      • Hello. I am currently trying to replicate a GROUP BY clause in MDX. Basically we have a Many-To-Many Dimension, with Planograms-Items as our hierarchy. When I say: { DESCENDANTS( [Planogram].[PLanogram1], [Planogram].[Items]), DESCENDANTS( [Planogram].[PLanogram2], [Planogram].[Items]) } I get duplicate items since an item is in both planograms, but of course each row has it own sale
  • SQL Server 2005 Profiler - Newbie question
    by Gunsva
    3 Replies
    Last post by Satya SKJ
      • I need to reverse engineer a SQL Server database in that there is an application that sits on top of the database.. I am trying to understand how certain tables in the database are affected by certain events in in the application.. example on the order entry screen, when an order is placed successfully, what relational tables are accessed Can the SQl Server 2005 Profiler be used to assist
  • Parameterized connection string & parameters - problem
    by Tomaszek
    0 Replies
    Last post by Tomaszek
      • Hi, I¡¯ve created a report which utilizes two stored procedures to populate parameter dropdown and fill report itself respectively. Report works fine until I create parameterized connection string. When datasource (not shared) has parameterized connection the parameter dropdown is greyed. I¡¯m getting error: ¡®error during processing of the ConnectString expression of the datasouree ¡®name¡¯¡¯. It
  • SQL Server 2005 Developer Ed Installation On Vista Business Ed 64
    by CampbellCP
    0 Replies
    Last post by CampbellCP
      • This sounds strange. When I have installed Sql 2005 on this Vista Machine and then applied SP2 it kills Vista to the point it wont even start in Safe Mode - It will come back when using Last Known Good Configuration but this leaves Sql Server without the SP2 and it doesnt run very well - Compatability issues and all. Tempted to go back to XP 64 where Sql 2005 ran without a hitch. Vista is a cle
  • Script Task scripts will not stop at breakpoints.
    by JWardRogers
    14 Replies
    Last post by Phil Brammer
      • I can not debug any of my scripts. They execute just fine, but if I have a breakpoint set in the script code (in VSA), I get the message: SQL server integration services script task has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost. Debug Close When
  • Login failure issue with Crystal reports connecting to SQL Server 2005
    by satishrjay
    3 Replies
    Last post by satishrjay
      • Hi All, My application uses "crystal reports" control to integrate some reports that can be viewed from within the application. I'm getting a login failed (due to bad password SQL State 8) error when I bring up the report from within the application. The report runs fine outside the application with the same username password. - I've checked several times to make sur
  • Parse XML to load files inside them
    by MShetty
    9 Replies
    Last post by MShetty
      • Hi all, is there a way we can parse a XML(file name lister) file that has a structure say, <Node> <Root> <FullName>/My Documents/Documents/Feature/17470_652</FullName> <ShortName>17470</ShortName> <XMLFileName>17470_652.xml</XMLFileName> <LastModifiedOn>12 December 2006</LastModifiedOn> </Root> ... ... ... </Node> and
  • Browsing attributes from shared dimensions
    by Wout_B
    1 Replies
    Last post by Darren Gosbell
      • Hello, e.g : I have the dimensions order.date , delivery.date based on the dimension date. When i browse the date dimension in the cube browser or in excel, and i select the year attribute from the dimensions it just shows year in the browser and I really want it to show order.year and delivery.year Our real cube has more than 10 shared time dimensions, so it can be really
  • Cannot connect to SQL Server 2005 Express with Management Studio Express
    by PussyFoot
    11 Replies
    Last post by Anthony Stanley
      • On my home machine without permanent network connections enabled, I cannot get the Management Studio connect to the database server. Always get this error: Cannot connect ot MPLIAM\SQLEXPRESS Additional Information: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settin
  • password cannot be saved
    by Qiuwei
    4 Replies
    Last post by Qiuwei
      • Hi, there; I have a SSIS package which has SQL2005 as its destination. When I setup the connectionmanager, I'd like to use SQL authentication. But I found that the password field cannot be saved (Checkbox "Save password" is selected).Everytime I open the this package's connectionmanager, that password field is cleard. The result is that my C# application that loads that package to exec
  • Unable to change SQL 2005 database Autogrowth through Server Management Studio
    by Akinja
    14 Replies
    Last post by EmilF
      • I have a database that seems to change its autogrowth settings every so often. When I initially set this up, I set the autogrowth at 500MB. After some time, I noticed that the autogrowth was set to 645000%. When I tried to change it through Management Studio but recieve the following error ' Value of '645000' is not valid for 'Value'. 'Value should be between 'Minimum and Maximum'. Paramete
  • Sorted Input
    by DarrenSQLIS
    5 Replies
    Last post by Jamie Thomson
      • If a component requires a sorted input it would seem reasonable that you can check the IsSorted property of the attached input, but this will always return false. I have tried this when connecting the output of the Sort transform to my component, and then check the IsSorted property for this input. It is always false. How can this be, and also how can I see if the path is indeed sorted If using
  • Need to change Authentication type of my first DB in SQL05
    by kcoleman
    2 Replies
    Last post by Vidhya Sagar
      • * I was able to configure and install the DB * I accidentally selected Windows Authentication Now it won't let me login and keeps giving me an error. Question: how do i change the authentication type without getting into the db is there something I'm missing