SQL Server

Page 2164




  • Topics
    Replies
    Last post
  • PROBLEM WITH SQL2000
    by Kiesa
    3 Replies
    Last post by Satya SKJ
      • hello..i have a really big problem with SQL2000 installation, i cant install it, some sql,odbc dll and other files left after i reinstalled OS without removing SQL,maybe 4 months ago and still have them in my pc, bought new HDD but they still exist in my pc :/ used full format of HDD but those files still left after all new installation of OS,i tryed to delete them but they appear again,deleted th
  • DTEXEC for remote execute
    by yosonu
    3 Replies
    Last post by Phil Brammer
      • I have a legacy extraction ("E") .NET 1.1 application that is still going to be the driving force for our ETL process. We are going to be utilizing SSIS for "T" and "L". Now, the "E" phase is running on an application server where we have .NET 1.1 framework installed and working. The SSIS packages are running on a separate SQL Server. The problem here is - h
  • Is DAC supported in SQL Server 2005 Express Edition?
    by Gopinath M
    10 Replies
    Last post by Gopinath M
      • Hi All, Can you please kindly let me know whether DAC(Dedicated Administration Connection) is supported in SQL Server 2005 Express Edition. As per the documentation available in MSDN( Trace Flags ), Trace Flag 7806 Enables a dedicated administrator connection (DAC) on SQL Server Express. By default, no DAC resources are reserved on SQL Server Express. But when i tried to enable it by passi
  • See anything wrong with this MDX Expression???
    by JohnBGood
    2 Replies
    Last post by JohnBGood
      • I have a fact table like so: TimeByDay ProjectID TaskID ActualWork Work Baseline Cost 4/4/07 001 002 5 8 8 4/5/07 001 002 0 8 8 4/6/07 001 002 8 8 0 4/7/07 001 002 8 8 8 And calculated measures - Measure 1 and Measure 2 like so: SUM({NULL:[Time].CurrentMemb
  • Not a Number Values in the Database
    by anomolous
    12 Replies
    Last post by Umachandar Jayachandran - MS
      • Our application has a table, which is populated via ADO.Net from C# with data originating from a C++ COM call. Today I encountered an entry that is C++ code for an undefined value: -1.#IND stored in the database. However, I could only discover what was stored in the table by Casting the value to a varchar -- simply selecting returned an error. Is this expected behavior or a bug It does not
  • Server Hardware
    by john.adams
    1 Replies
    Last post by mrdenny
      • Just wondering, which server hardware do you guys use for SQL Servers - we use Dell, curious to know what you are using - John Adams
  • Setting SSRS data source via script
    by dba72
    3 Replies
    Last post by Markus Fischer
      • Is there a command that can be used to set the account and password of an SSRS data source I want to use a datasource that uses the option "(windows) credentials stored securely in the report server". The password for the account to be used can not be known by any humans (or we have to kill them after) so we want to set it programmatically. Is this possible via a command
  • Analysis Service 2000 on WIN 2003 and client on WIndow Vista
    by Surajkb
    1 Replies
    Last post by Darren Gosbell
      • Hi, We have Analysis service 2000 installed on our server and client are accessing the cube using excel 2003 on Window XP without any problems. But now after installing Window Vista with excel 2003 and 2007 on the users machine, users are unable to connect to the MSAS 2000 cube. We have installed PTSLITE.exe on the users machine. Still unable to connect. The error is 'U
  • From Flat File to XML
    by HemantC
    6 Replies
    Last post by jwelch
      • Hi, Bonjour. Using SSIS can i do the traformation from Flat file to XML file If possible can provide some links or example. merci, hemant
  • Sub-Query problem..
    by goodguy1974
    7 Replies
    Last post by goodguy1974
      • I big frustration with this project...There is not a good relationship structure to the database... Desired Functionality: I want to use the second table as an invalid list for the first table. So let's say the following: I have a dropdown list of the items in the first table. I want the second table to be checked in SQL or C# code for valid options per product. So if a person had the
  • Submitting Report Requests from .NET application
    by Gouri Sankar
    4 Replies
    Last post by Lukasz Pawlowski -- MS
      • Hi, One of my client want to shift his reporting to SSRS. He wants to submit his report requests to SSRS. He wants the report should run at the reporting server side (not on client system) and output should be exported to a folder on server. I am some what successful in submitting the report requests using subscriptions. But I have no idea to retrieve the requests from SSRS with the executi
  • Need another Opinion (Database Design)
    by csharpnewbie001
    4 Replies
    Last post by Arnie Rowland
      • I need some other opinions on whether or not this is considered a proper database design structure. Here is the relationship...We have PEOPLE, that each can belong to a COMPANY. PERSON_TABLE Person_ID Company_ID COMPANY_TABLE Company_ID Then each person can trust other people of other companies, but can only trust 1 person per company. My question is this. In order to maintain a constraint of 1
  • Package Execution condition
    by Skola17
    2 Replies
    Last post by MatthewRoche
      • Hi, I have 5 different packages out of which one needs to be run on a weekday basis. I wanted to have some kind of condition or varaiable to be set in a different Package which would determine which out of 5 packages needs to be Run. I am thinking of setting a variable and then passing a value that would determine the particular package but then I dont know how set that in "Execute
  • Could this be done in MDX ? and How
    by Jimmylaw
    5 Replies
    Last post by Yongli Yang
      • Thank You for the help. I would like to create a new measure in SSAS 2005 so I can use this measure for all my report (SSRS). Below is the TSQL to calculate total new / first time customer in the month of March. Could this be done in MDX Would be good if I can get some example. Select count (distinct customerID ) Cust_cnt from SalesFact f1 where f1.transdate between CAST ( '01
  • Conditional Bulk insert
    by mohanbabud
    1 Replies
    Last post by ggciubuc
      • Hi I am doing bulk insert as follows. The @lastUpdate, @filePath, @formatFile comes as a parametes to stored proc INSERT INTO Categories SELECT CategoryId, @LastUpdate FROM OPENROWSET ( BULK @filePath , FORMATFILE = @formatFile, FIRSTROW = 2 ) AS a This works fine for me. But my new requirement is that i shouldn't insert the Categor
  • Processing ALL dimensions in an SSAS db using xmla script
    by Grant Schulte
    13 Replies
    Last post by Vidas Matelis
      • Hi, I am trying to process all dimensions in an SSAS2005 db using an xmla script in a job step. I can select all the dimensions in Management Studio, right-click and select "Process" and then hit the "Script" button to get a script to process each dimension. However, if I add a dimension later, I need to script out that dimension and add it to the job step (and then prom
  • Sms to mobile phone
    by Vijayanr
    2 Replies
    Last post by Vijayanr
      • hai, how can i send sms through web page(without using web service) to mobile phone using SQL server 2005
  • HOW-TO Change "text" column to "ntext" that is NOT NULL
    by jaBowman
    14 Replies
    Last post by Arnie Rowland
      • Hi All, I have a table that has a column defined as: [colname] [text] NOT NULL and I want to change it to be [colname] [ntext] NOT NULL This table already has values in it (in this column). I tried ALTER TABLE [dbo][tablename] ALTER COLUMN [colname] [ntext] NOT NULL But as the BOL describes I am not able to execute an ALTER COLUMN against a "
  • Can't install the client components, error raised
    by Willgart
    13 Replies
    Last post by ACatellani
      • Hi, when I try to install the client components I receive this error: Upgrade failed due to the following error. The error code is: -2147467259. Message: Unspecified error I think the problem is during the upgrade of the report server components. my computer has the SQL 2005 client components installed but I have just uninstall these components. I'll try on a
  • How to set is_receive_enabled and is_enqueue_enabled from 1 to 0.
    by Michael_Shao
    4 Replies
    Last post by Michael_Shao
      • Hi All, I used service broker activation in my receive queue (SQL 2005 SP1). However, it seems the stored procedure does not work after the receive queue get message. I saw the following error in SQL Error log. "The activated proc [dbo].[Mystoredpro] running on queue test2.dbo.ReceiveQ output the following: 'The service queue "ReceiveQ" is currently disabled.'" Then I
  • Referencing Variables by Name
    by Colin Macguire
    10 Replies
    Last post by Phil Brammer
      • Hi there everyone, A quick question. How do I reference variables (system and user) in SSIS by name instead of by just using a " ". The reason why I'm asking is because I'm trying to log what happens in a package to SQL, and if I cannot reference a variable by name it tries to insert variable values into incorrect fields An example of the code I'm trying to use can be found
  • Date Range for Report built against cube using MDX query
    by medphis
    3 Replies
    Last post by Darren Gosbell
      • Hi, I am trying to filter data within my report by a date range (FromDate - ToDate), which is using a cube as a datasource. My Issue: I have the filtering working ok but if i select a date which is outside the range of the data within my cube for example if i select the starting date for the range as 1/Jan/1965 but by data starts from 15/Jan/1965 then no data is returned.
  • Forms authentication - Object reference not set to an instance of an object
    by Andreas Brosten
    14 Replies
    Last post by DanMan226
      • I have successfully implemented forms authentication, that means, I can access it from a web browser, get the login page, add my credentials and log on to Reporting Services. But now I try to access reporting services Web service from a winforms app, doing something like this: ReportingService _rs = new ReportingService (); _rs.LogonUser( "myUsername" , "myPasswor
  • Restore with scheduler!
    by TonyTTC
    2 Replies
    Last post by Madhu K Nair
      • Is there anyway you can schedule to restore a database table(s) from a backup file *.bak
  • Need help in migrating from Access to SQL express
    by SmileSmita
    2 Replies
    Last post by Glenn Wilson
      • Hi there, I am totally new at SQL/SQL express.I have downloaded the sQL express server and wanted to know how i can go about exporting my tables which i created using MS access into SQL express. Also my application is currently working by using Access and ASP...what will be the changes i would need to incorporate in my code other than the queries and Data connection string. How would the