SQL Server

Page 2892




  • Topics
    Replies
    Last post
  • Installing SQL 2005 over the top of SQL Express
    by Suedcn
    1 Replies
    Last post by Arnie Rowland
      • Hi, I am installing SQL Server 2005 on a server that is currently running SQL Express. My reason for installing full SQL is due to the database size limitation of SQL Express. Can anyone give me advice on whether I should unistall SQL Express before installing SQL Server 2005 or just install over the top of Express. Thanks
  • Function to Convert Amount to Words for Check Printing
    by AnnetteC
    4 Replies
    Last post by AnnetteC
      • I am thinking someone out there must have already developed this.... I am using Report Services to generate checks and need to convert the $ amount into words on the "Pay To" line. I searched Google and found a couple of VB/ASP routines that do this, but I would need to do it via a SQL Proc since the reporter does not provide the capability to reference and/or call cust
  • Anything new to expect with SQL Fulltext searching?
    by Andrew Sieja
    10 Replies
    Last post by Upinder
      • would love to see improved proximity searching, specifically the ability to find terms within x number of words of another term. thanks-
  • Max memory support in SQL Server 2008
    by Yoshihiro Kawabata
    5 Replies
    Last post by MVP User
      • Hello, Are there any extension of max memory support At SQL Server 2005. Express Edition x86 = 1GB Workgroup Edition x86 = 3GB Standard Edition x86 = os limit Standard Edition x64 = 32TB Developer Edition x86 = os limit Developer Edition x64 = 32TB Enterprise Edition x86, x64 = os limit Datacenter Edition x86, x64 = os limit ref
  • Query in Oracle & SQl server
    by vishwaa
    5 Replies
    Last post by Tom Phillips
      • Hi All, I need the basic information about how the query is working in Oracle & SQl Server. Sicne I am getting different values when I run the query. I have a table called 'Client_Master' in both the DB (ie., Oracle & SQL). I have inserted a record with the below values for Client_Master table. (both Oracle & SQl). Inserted Values: ---------------- Start_Code = 90 End_code = '' The qu
  • parameter is missing a value.
    by Naveen J V, Bangalore
    13 Replies
    Last post by Naveen J V, Bangalore
      • Hi Friends, I have created a child report with hidden parameter. When I call this report from the Master report using a link, I am getting error 'the xxxx parameter is missing a value' . From, master report, if I click a value, it should take that value to child report where it filters for that value and should display the child report. How to overcome this Thanks & Reg
  • Select with Grouping for Multiple Date Columns
    by sqlhiker
    6 Replies
    Last post by oj
      • Hi All, Thanks for dropping by my post. I have a table which is of this form. ID MS030_A MS030_F MS036_A MS036_F MS040_A MS040_F ZZ0023 2/16/06 2/16/06 8/10/07 8/10/07 11/21/05 11/21/05 ZZ0031 8/10/07 4/5/07 8/9/07 8/9/07 3/22/07 3/22/07 ZZ0077 8/9/07 9/7/07 8/10/07 8/10/07 8/10/07
  • Do they ever plan on fixing imports from Excel (and probably anything else ??)
    by effmicrosoft
    3 Replies
    Last post by Benda Fenda
      • hours wasted    what else is new with Micro --- crap      try to import an excel into a table,  longest field (via vba macro report) is 278      receiving DB field is 4000     get "Truncation error,  I must stop   I am a piece of s*** program "   the only thing you can find on th
  • share variable with child
    by Fahad349
    4 Replies
    Last post by Fahad349
      • How a parent package can share its variables with child when calling it using Execute Package Task
  • FTP Task. "/" Validation makes Mainframe downloads Impossible.
    by mawill01
    6 Replies
    Last post by Phil Brammer
      • When attempting to use the FTP task to download a file from a Mainframe system the task fails stating the filename as invalid because it doesn't begin with a "/". Adding the slash to the front of the file name causes the mainframe to be unable to locate the file. Commandline version of FTP.exe mimicks this behavior by working perfectly when the filename has no slash, and being unable to
  • Help: MS Access to SQL Server 2005 using SSMA
    by Deirre
    1 Replies
    Last post by Mike Wachal - MSFT
      • I am new to databases and need some info that I'm having trouble researching. I just migrated a access database to SQL server 2005 using SQL Server Migration assistant (SSMA). I wondered how SSMA handles NULL values Also how it treats differences between Access and SQL Any help would be appreciated.
  • import large field from SSIS
    by J0sh159
    6 Replies
    Last post by Mark Durley - MSFT
      • Hi, I am making a SSIS package that imports data from a application using a custom ODBC driver. The field in the application is set to be a "longvarchar" type field and can be from 2 characters to 2MB of data. I've created a ODBC data connection in the SSIS package and use a "DataReader Source" to read the data I need. The sql statement is very simple Select log from table
  • Failed to create Database
    by Maria Regina
    10 Replies
    Last post by Caddre
      • I am trying to create a blank/sample database on Dynamics POS with SQl Server Express. And a error message is read: Error to create blank/sample database Error details: failed to create windows users/groups or add the sql loggins Do you have any idea why is this error message happening, or what can I do to fix it
  • Does SQL Server 2005 Express support Web/Internet Replication to other SQL Server Express Clients?
    by Shabby
    4 Replies
    Last post by danmbuen2
      • HI Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients Regards
  • Parent ID in a Slowly Changing Dimension
    by Jeroen Alblas
    12 Replies
    Last post by Jeroen Alblas
      • Hi There, Just wondering if any of you implemented a (Kimball type 2) dimension structure, in which a ParentID column exists which points to a record from the same dimension table, using a SCD objects in SSIS. The ParentID column would have to be "Historical". The challange here is that you would need to go through the table twice somehow, because if I would do a lookup of the pare
  • For-Loop and Failed Items
    by JNHL
    3 Replies
    Last post by Phil Brammer
      • All, I am currently in the middle of writing a package that needs to loop round a record set and extract data from various source DB's in a common format. The inner package is a simple data pump that relies on a dynamic OLEDB connection being set at run time via a variable in the outer package. This works wonderfully, providing the value in the outer package points to a verifiable data s
  • Can't find SSIS in VSTS 2005 for Developers
    by Richard Schaefer-HTSC
    11 Replies
    Last post by Richard Schaefer-HTSC
      • I have both VSTS 2005 for Developers and VSTS 2005 for Database Professionals installed on my PC. I can't find any BI or SSIS projects in File->New Projects. The only database-related projects are to write Stored Procedures, Views, etc. Where is it Did they break it when they added the Database version on top of the Developers version
  • diamension relationship
    by padu561408
    1 Replies
    Last post by Thomas Ivarsson
      • Hi I have a diamension called 'mechanism of injury' and measure injurycount situated in the injury measure group. I defined a relation between mechanism of them using the regular relationship connecting using the mechanismofinjuryid key in both tables (mechanismofinjury and injury). I tried to deploy the cube and it gave me the following error. Errors in the OLAP storage engine:
  • how to manage the transactions log
    by Jassim Rahma
    5 Replies
    Last post by Hemantgiri S. Goswami
      • i have fixed the log to 30GB thinking that it will replace the old data if it reachs the limit but my server stopped working because of the log and i was getting: The log file for database 'TEL_DATA' is full. Back up the transaction log for the database to free up some log space. what can i do
  • Cannot run report on the report server with ssis as a datasource
    by Jagapathi Raju
    8 Replies
    Last post by Jagapathi Raju
      • Helo All, I have report which uses an ssis package as a datasource. when I develop the report on the visual studio seems like it runs fine. But when I deployed the same report on to the server (report server 64 bit machine) it is throwing me an error: An error has occurred during report processing. Cannot create a connection to data source 'DataSource1'. is not a valid Wi
  • Target to Source Mapping
    by chip_levis
    3 Replies
    Last post by Lucas Almeida
      • Hi all, I'm trying to figure a target to source map in order to find where data was extracted from to create attributes in a dimension. For example, let's say you have Dim_Account with the attributes Account_name, Account_Number, Start_date, End_date, Transaction_Number, Transaction_History. Remember that the above attributes (Columns) are created from different base tables.
  • Failure writing properties running SSIS package from a Web Service
    by jojo the dogface boy
    1 Replies
    Last post by jojo the dogface boy
      • I am attempting to run an SSIS package from a web service. Right now both the service and package are on my local machine which is running XP. I have accessed the web service from a client application in debug mode. I am not sure if it is actually running under aspnet_wp.exe because it is XP and a development environment (separate question) The package fails with a series of OnError messages simi
  • writing back a zero to a writeback table
    by jam281
    4 Replies
    Last post by jam281
      • Hi I'm having trouble storing a value of 0 in the cube. If i type in any other amount in the meassure and send the data, it will be stored, but if i want to store 0 in a cell it just becomes blank. Any sugestions
  • Search by multiple date range options
    by MichiganMark1956
    2 Replies
    Last post by MichiganMark1956
      • I inherited a system and am moving our SQL2000 input data into a new 2005 database for web searching by clients. The conversion went pretty well, but I'm looking for suggestions on how best to index and query the data. Details: We have almost 500,000 records in a pretty wide history table, and will be adding more records daily. The original table design has numerous sets of dates(first/la
  • SQL Reporting Services performance on navigation pages.
    by Ray Dodson
    12 Replies
    Last post by dribar
      • I am experimenting with SQL Reporting Services on a machine with SQL Server 2005 loaded and deploying reports to a different server. both servers are equivalent in resources. In the browser on the Reports machine when I first go to the Reports address, it takes a very long time to build and load the page. it then takes a long time for each drilled down page. Subsequent calls to the s