SQL Server

Page 4835




  • Topics
    Replies
    Last post
  • Querying 1 member from 2 hierarchies in same dimension?
    by tee_user5
    3 Replies
    Last post by tee_user5
      • I've tried to do this: select ({[Date].[Fiscal].[Fiscal Year].&[2004], [Date].[Calendar].[Calendar Year].&[2004]}) on 0 from [Adventure Works] but it errors with Members belong to different hierarchies in the function. Then I tried: select ({[Date].[Fiscal].[Fiscal Year].&[2004], [Date].[Calendar].[Calendar Year].[All Periods]}, { [Date].[Fi
  • Visual Studio closes when data source has changed
    by csi_hugh
    5 Replies
    Last post by MatthewRoche
      • I am trying to edit an SSIS package due to a change in the schema of one of the source tables. When I open the package in Visual Studio, I see the exclamation mark on the object but before I can make change or go to edit anything in the package, I hear the "dumphhh" sound that indicates an error. There is no dialogue box but the program is now locked up. Then after 10 - 20 seconds the pr
  • OLTP Database Design help for bank's customer table
    by Gagan Kr Sharma
    2 Replies
    Last post by richbrownesq
      • Hello,friends 1) CustomerID 2) FirstName 3) MiddleName 4) SurName 5) Title 6) Marital Status 7) Education 8) Occupation 9) Annual Income 10) Line of Business 11) DOB 12) Father Name 13) Mother Name 14) SpouseName 15) Gender 16) Emai
  • Need drillthrough for just one month--but cube goes back two years
    by Dan Scott
    11 Replies
    Last post by Annand
      • First, let me ask if I am correct in understanding that while fact tables can be partitioned, a drillthrough dimension cannot Thus, a drillthrough dimension must span the entire fact table My users both want one to two years of info in the cube, and also want drillthrough. We have been able to persuade them to accept only a month or two of drillthrough. Unfortunately, it appears that this
  • Data Mining Client for Excel
    by JenniferJones
    3 Replies
    Last post by Jamie MacLennan
      • Is it at all possible to use this tool without any connection to SQL Server (mine data in Excel Worksheets only) Or is it required to connect to SQL Server From reading the documentation, one minute I get the feeling this is possible, then the next section I get a feeling it's not. Can anyone help Thanks.
  • microsoft decision tree algorithm
    by desny
    10 Replies
    Last post by NopV
      • I have read some sources about microsoft decision tree algorithm like in claude seidman book, paper about scalable classification over sql databases and paper about learning bayesian network. But i still don't understand and i still didn't get the point on how microsoft decision tree algorithm works exactly when splitting an atribut. Because i have read that microsoft decision tree using Bayesian
  • DBCC SQLPERF WaitStates / OLEDB
    by JoeAndMax12
    1 Replies
    Last post by Sue Hoegemeier
      • OK ... how many of you run dbcc SQLPERF(waitstats) to display analyze SQL Server 2000 resource utilization How about sp_waitstats This is a very useful stored procedure that takes the sqlperf output and aggregates it over common wait types. If you've had to work on a sick SQL Server box, I've found this pretty useful to help pinpoint bottlenecks. While there's plenty written about the various wait
  • Sql 2005 Management Studio
    by b.paul
    6 Replies
    Last post by PAD25
      • We are just now moving from SQL 2000 to 2005. I've been playing around with the new (to us) SQL Mgmt Studio. Overall it looks awesome! However, I need the ability to generate SQL Scripts for FKs, PKs, indexes etc... withtout generating the associated create table command within the same script (which you could do in SQL Enterprise Mngr). In SQL Mgmt Studio, when i select "Generate Scripts&quo
  • DTS Package problem?
    by Bill_C
    2 Replies
    Last post by Satya SKJ
      • I have set up a couple of DTS local packages to run ActiveX scripts creating XML files and copying them to our webserver (on the same domain). I can run them OK manually via the 'Execute' package command in the drop down list when I right click on them and also get the 'Package successfully run' message back on running them, but when I schedule them to run overnight I find the SQL Server Agent rep
  • SQL mail using external mail server
    by Marcelroos
    2 Replies
    Last post by Maciek Sarnowicz MSFT
      • Hello We are using SQL Server 2000 SP4 Standard Edition and would like to use the e-mail function to monitor certain alerts. However, an e-mail server (SMTP server) is not installed on that box, but on a different IP address within the network. I have set up the e-mail operator, enabled e-mail in SQL Agent and set the Mail Configuration in Support Services. However, on testing I get the foll
  • Synchronization fails
    by Minnpletch
    6 Replies
    Last post by dustinka
      • After working fine for months, everytime I try to ActiveSync my Palm Treo 700wx, I continually get a message that says, "Synchronization could not be completed. Try again later. Support code:80070008" It does not synchronize and this has been going on for a week or so. How can I fix this
  • Help on global variable for insert statement
    by Lawrence 007
    9 Replies
    Last post by Jon Limjap
      •   I am new to DTS, but really enjoy it and was wondering if someone could help me with the following small vb app. I am using the following DTS insert statement to insert records into my table. I have multiple textboxes that needs to be filled and then inserted, none of them exept Nulls. How can I modify my code to insert those textboxes as well as run through the boxes and then check i
  • Network share/Multi user deployment
    by arothberg
    2 Replies
    Last post by BrianSquibb
      • Can a SQL Server 2005 Compact Edition database file be deployed on a file share and be accessed by multiple (5-10) concurrent users This is a current scenario being implemented at several sites using MS Access databases. Each client would have the SQLce engine installed on it and would only access the database via a managed C# application.
  • Cannot connect to SQL Server DB Engine...Instance Contains SQL Express in Name
    by SP WannaBe
    7 Replies
    Last post by Ekrem Önsoy
      • I recently installed SQL Server and Visual Studio. When I went into SQL Server, I could only connect to a SQL EXPRESS Database engine. I need to access the full Database. I tried disconnecting it, uninstalling/reinstalling. Now I cant connect to the SQL EXPRESS DB Object. There are no SQL Server services running. Please help. Thanks
  • continuous attribute & Complexity_Penalty
    by th3r3
    1 Replies
    Last post by Raman Iyer
      • I am having one question about discretization of continous attributes values. How does it work I need this information for my thesis. I have a continous attribut, namely SKS, with range 0-20. When I use Microsoft Decision Tree algorithm, this attribut split in SKS <= 18 and SKS > 18. I want to know how does it find 18 as a number to split not the other. One question again about Micros
  • Deploying subscriptions on different server
    by JAM_Switzerland
    0 Replies
    Last post by JAM_Switzerland
      • Hi, I have three environments which are exactly the same. A dev, prod and backup server. Everyone has its own installation of SQL. What is the best practice to re-use the subscriptions for the other environments I know I could restore the test database but I would prefer not. Thanks in advance for any input. Best regards, Jam
  • MDX Query performance issue
    by Reena33
    13 Replies
    Last post by El gabacho
      • I have the following query which takes more than 3 minutes to run. There are just 10,000 records in the Fact table. The largest dimension has about 2000 records in it. How can I optimize it SELECT NON EMPTY { [Measures].[Productivity Time in hours - Edited Docs], [Measures].[Productivity Time in Hours - Typed Docs], [ Measures].[Productivity Time in Hours], [Measures].[Lines Per 10
  • DFT - Howto last execute a storedprocedure
    by donRiccardo
    5 Replies
    Last post by Phil Brammer
      • In a DataFlowTask with several OLE DB Destinations, how can I "last", before ending this DFT execute a storedProcedure This storedprocedure is used for saving metadata (taskname, rowcounts etc) regarding this DFT and I dont want to add an ExecuteSQLTask after the DFT in the Control Flow Regards Riccardo
  • Jump To Report Without Running It Automatically
    by SQL Servant
    1 Replies
    Last post by tee_user5
      • Hi I need to be able to click a hyperlink in one report to open a linked report, but without automatically running the linked report. Scenario . I have a report showing customer details and on this page there is a link to a price enquiry report. This price enquiry report has two parameters: customer code and product code. When I click the price enquiry hyperlink in the cust
  • Can I Upload a URL or Shortcut to the SSRS Home Page?
    by Dave Jackson
    1 Replies
    Last post by Dave Jackson
      • I have a simple WSS 2.0 SharePoint site for my SSRS deployment which I would like to link my users to from the SSRS home page. Is it possible to add a link or shortcut to my SSRS home page without embedding it inside of a document or report
  • Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
    by scotthunter
    7 Replies
    Last post by Mark Arrow
      • I'm getting the following error on two of my SQL Servers - Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later. The only solution that I have seen is the same solution that Microsoft has published in the following article - KB303287 [http://support.microsoft.com/ scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f303287%2fen-us%2f] The solution is
  • Capture date and timestamp of a file?
    by spattewar
    6 Replies
    Last post by spattewar
      • Hi, I am pulling files from the FTP site using the FTP task. I want to also capture the date and timestamp of each of these files so that I can insert the values into a database and track when are these files get created normally on the FTP server. Any ideas Thanks in advance for your help. $wapnil
  • SCOPE_IDENTITY()
    by guddu567568
    4 Replies
    Last post by guddu
      • hi what is difference between thos two's SCOPE_IDENTITY() and @@IDENTITY thanx
  • How to dynamically process a Model in a Web App
    by Ricky Wang
    7 Replies
    Last post by hj
      • Hi, I am a novice at Data Mining realm on SQL Server. Scenario: I have created a Time Series model and deployed it into SQL Server. I hope users can see forecast based on the up-to-date data residing in data source rather than the old ones used to train the model. In a addition, the interface provided for users is a .aspx. Problems: What ADO APIs should I exploit to dynam
  • SUM and Iif statements
    by phorest
    9 Replies
    Last post by phorest
      • Hello, I have a report with 1 field that I need to sum into 2 different textboxes based on another field's value. Specifically, Is it simply doing something like this below =Iif(Fields!iBB.Value=1, Sum(Fields!Billed.Value) =Iif(Fields!iBB.Value=0, Sum(Fields!UnBilled.Value) Which will not get past intellisense checking, -or- do I have to do something different here