SQL Server

Page 2417




  • Topics
    Replies
    Last post
  • Help with query
    by BarefootSanders
    2 Replies
    Last post by Jens K. Suessmeyer
      • I'm not sure if this is the right forum but here goes: I want to make a query that selects data from multiple tables and joins it all together. I have that but what i want to do is only select the data I need. at the moment it is returning columns that are not necessary. I'm trying to do something like this: Code Snippet SELECT sysdba.OPPORTUNITY.OPPORTUNITYID AS OPPID FROM sysdba.OPPO
  • Can't install sql server 2005
    by dennist685
    4 Replies
    Last post by John Paul Cook
      • Can't install sql server 2005 When I insert the disk autoplay flashes on the screen, then I get the message - windows cannot open this file splash.hta I tried directly clicking several setup icons, but cancelled them because they didn't seem to be the initial setup of the server. I've done this with both the dvd and the cds dennist685 It worked with virtual-CD
  • ReportServicesConfigUI.WMIProvider.WMIProviderException: System.Runtime.InteropServices.COMException (0x8000000A)
    by RuiFernandes
    3 Replies
    Last post by RuiFernandes
      • Hi there! I installed the Sql Reporting Services under Vista Business. When i run de configuration tool, i have to select yhe machine name and instance name... then when i press connect this exception is thrown ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMEx
  • Creating a Sum for the Year
    by muzzettemm1
    12 Replies
    Last post by muzzettemm1
      • Hi all I have to create a query that would give the users a a total amount of each field for the month or year. I just need it to give me a total amount of each item for the month. So basically what happens is that the user enters in a beginning date and an ending date for the month or year and this report gives them the [INVESTIGATOR], [VIOLATION TYP], [DATE], [TOTAL LOSS]. I just want to show h
  • New User - Unable to connect
    by tim_duncan
    3 Replies
    Last post by RhythMick
      • Hello, Im new to SQL Server so please forgive me if I seem a tad ignorant. Any help is much appreciated. I have just installed SQL Server 2005 CTP on my machine at home in order to learn more about it. The istallation completed successfully on my home pc under XP Pro w SP2. I use the machine with Administration priveliges. There is also a local account on the machine I could use, but I ne
  • problem deploying SSIS to another server.
    by Thai Nguyen
    2 Replies
    Last post by Thai Nguyen
      • Hello, I am trying to deploy a SSIS package (using deployment utility create at build time) to a different server and ran into problem wonder if someone and direct me to the right path. development environment: WIN XP, SQL 2005. package is built using server buisiness intelligence. Package content: connect to a "target"SQL2005server using OLE DB using SQL Login authentication to proce
  • Check remotely if Reporting Services exist
    by reggiepangilinanX
    9 Replies
    Last post by reggiepangilinanX
      • is there a way to check the reporting services remotely.. using the reporting services url
  • File Move Component Error
    by chip_levis
    4 Replies
    Last post by DarrenSQLIS
      • My process checks values in certain files in a "Source" folder against a table in a database. If these values do not match, those files are moved to a "Fail" folder and if they are validated then they are moved to a "Success" folder. My issue is caused by the fact that these files (which are notepad text files) are not being moved over to the success folder for the fo
  • Error deploying large Report Model
    by Patdev
    4 Replies
    Last post by tmorgan_uk
      • Hi , I am trying to deploy the report model which is more than 4 mb size. I am getting following error: Error 2 There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded. i changed the web.config on the server side: as following: <!-- <httpRuntime executionTimeout = "600" [in Seconds][number]
  • Barcode doesn't print from reports server
    by Carpet King
    6 Replies
    Last post by Ram1979
      • Hi there, Ok, so I have a report that is generating product labels on a standard mailing lable sheet (30 of them on a 8.5X11 sheet of stock). The whole process works just fine even the printing of the bar codes when I am printing the lables from VS2005's Preview function. However, when I moved the report to our reports server and run the same report, the barcodes don't print out. I have checked
  • Copy cube from a DB to another one
    by Juan64
    5 Replies
    Last post by Juan64
      • Hi, I would like to copy a cube and its content from a database to another one. The first database is the one used for production and the second will be used to archive the old cubes. Is there a specific way to deal with this kind of issue Thanks in advance for your support. Rgds, Juan
  • How to change the instance name?
    by satya.krishna
    2 Replies
    Last post by satya.sqldba
      • Hello DBA's I have installed SQL Server 2005 on a machine with named instance, but later I noticed that I created it with the wrong name than desired. Now I need to change the instace name of the SQL Server that I have installed. How can I do that Thanks Satya
  • Database size allocation - where other than tables, logs, etc ????
    by Scott_lm
    1 Replies
    Last post by Peter Byrne MSFT
      • I have a Db that is 1.7 gigs. The table data takes approximately 200megs. The transaction logs were truncated. Where else can this large size be coming from and how can I confirm DB is generally small. ~25 tables, 100 SPs, 10 views, etc. Note: I have 4 queues using SQL Notifications, but when selecting from them results in no data. Thanks Scott
  • SSAS 2005 Connection
    by PHILIP LOW
    5 Replies
    Last post by Darren Gosbell
      • I need to connect SSAS which reside on another computer. I had a vb.net program which running fine if execute it on remote server. If i execute the program on my local machine it prompt me error when i try establish a connection to remote remote server (SSAS 2005). Is it SSAS not allow remote connection I had try connect to SSAS remote machine using SSMS (SQL Server Management Studio) and i
  • How to run DTS package/upgrade in SQL 2005.
    by satishpatil
    13 Replies
    Last post by BQMartin
      • Hi All, I am following instrucation in the following doc to migrate dts package. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/SQL05InSrREAL.asp In step 2. Right-click the DTS Packages folder in Solution Explorer and select the Migrate DTS 2000 Package option. This starts the Integration Services Migration Wizard . I don't see "DTS Packages" folder what am I d
  • TSQL Challenge
    by dot NET developer
    7 Replies
    Last post by hunchback
      • Im calling all the TSQL gurus to help me with this problem. Tables: Contracts (ContractID,Lastname, Firstname, ContractValue, Date Created Amendments (AmmendmentID, ContractID, Lastname, Firstname, ContractValue, EffectivityDate, DateCreated) Amendments table is related to contracts thru ContractID. Changes to the contract table is made by creating a record to the ammendments table. when this ame
  • Accesing offline cubes with MS Excel 2003
    by MatoK
    1 Replies
    Last post by Thomas Ivarsson
      • Hi, I created offline cube (.cub file) with SQL Server 2005 Analysis Services. Accessing the offline cube with MS Excel 2003 I get an error message: "Unable to obtain list of tables from the data source". I can access the offline cube with MS Excel 2003 only when MS Excel 2007 is instaled. After uninstaling MS Excel 2007 the same error ocures. I have MS Excel 2003 (11.8146.6568) SP2, Mic
  • Disaster Recovery - How to verify my 2005 standard databases using 2005 express
    by rufusman21
    4 Replies
    Last post by Deepak Rangarajan
      • How to verify the "Full" backups of an online database. Running MS SQL 2005 on Windows 2003 server using windows domain authentication Obtaining nightly backups of the application databases & the system databases Installed MS SQL 2005 Express SP2 on a workstation My task is to take the FULL BAK file(s) and recreate the database on the workstation for Disaster Recovery veri
  • How can we create cubs in sql server 2005 BI
    by VSB
    3 Replies
    Last post by Thomas Ivarsson
      • How can we create cubs in sql server 2005 BI
  • Can't Get SQL Authentication to work With XP Pro SP2 in very simple test case
    by codequest
    4 Replies
    Last post by codequest
      • I'm trying to work my way through the steps of using a User Id and Password in a connection string. I'm working with SQL 2005 Express, VS2005, in the development server. Got an error I can't get around...tried it several diffent ways on a slightly more complicated test site...no joy...so went to the MSDN tutorial...made the most "vanilla" test I could think of, and still can't figure it out.
  • Using Array Variable in ForEach Loop Container
    by Hery Susanto WR
    11 Replies
    Last post by Threko
      • Dear all, I have a problem using SSIS since I was a beginner, the problem is I have to do some data transform from flat files into database. These flat files come from many branches of my office with the file structure like this D:\SSIS\branch_nm\file_nm.txt, in folder SSIS there are many branch_nm folder and each branch_nm folder contains many flat files. My idea was grab the branch_nm folder int
  • Database corrupt on power loss
    by ttaritan
    14 Replies
    Last post by ms44cn
      • We are planning to use SQL Compact for an industrial control application. We selected this database based on the assuption that it will survive when power is lost in the middle of a transaction. We setup a test where we open a connection, write to database and randomly shut of the power while writing to database. We are running on XPE with EWF enabled for C drive. Database is on D drive.
  • tfs installation issue !!!!!!!!1
    by Areej
    1 Replies
    Last post by Barry Andrew
      • i had SP1 of visual studio and TFS installed on my server but it didnt work and i had a server failure, so i removed the SP1 after doing this i had this error: " Team Foundation Server does not exist or is not accessible at this time. Technical information (for administrator): HTTP code 503: TF30059: Fatal error while initializing web service " after searching on line i found th
  • Connection Error from ASP.Net under IIS: provider: Named Pipes Provider, error: 40
    by Zach Nelson
    3 Replies
    Last post by Nan Tu
      • We experience the 40 error when our Asp.net code runs under IIS and uses named pipes to a sql server 2005 named instance. We've tried all suggestions found on blogs and KB articles such as making sure the named pipes protocol is enabled, making sure the Browser service is started, making sure Allow Remote Connections is enabled, making sure we're not using Asp.Net 2.0 membership providers,
  • Cant restore the database backup in SQL server 2005?
    by shyam1aqua
    1 Replies
    Last post by Euan Garden
      • Hi, System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 83679641600 additional free bytes, while only 46151348224 bytes are available. (Microsoft.SqlServer.Smo) Thanks, S.Shyam.