SQL Server

Page 4231




  • Topics
    Replies
    Last post
  • "XML Source" xsd relative path
    by pc_83
    4 Replies
    Last post by pc_83
      • Hi all, Is it possible in the XML Source to specify a relative path for the xsd file If not, do you have any idea why Best regards, pc
  • Creating a blank row in a table between positive & negative values
    by stevensun2007
    2 Replies
    Last post by stevensun2007
      • I have a table that displays a bunch of data based on their percentage changes. There is a parameter (let's say 5%) that the user can set to display only the data which either increased more than 5% or decreased more than 5%. I want to have a space between the positive changes and the negative changes. ie, to create a blank row between the +'s and the -'s. Does anyone know of a way to do this Th
  • SQL Server 2005 rejects remote internet connections
    by PetrTab
    14 Replies
    Last post by swvajanyatek
      • PROBLEM: SQL 2005 rejects connection from an ASP.net test webpage (shown below). CONFIGURATION: Internet > Concast Cable > Router > Sever01 Nic1 > Server01 SBS 2003 & SQL 2005 > Sever01 Nic2 > Switch > Local Area Linksys Router WRV54G( Firmware Version: 2.39.2 ): Port Range Forwarding TCP 1433 and UDP 1434 Small Business Server 2003 P
  • DTS package
    by Mapa3matuk
    5 Replies
    Last post by Phil Brammer
      • Hi guyz, I have created a DTS package that takes XLS file and updates the database. The problem that i run into is - sometimes XLS file does not have any records in the table, and in this case i do not want DTS to execute and update the database. The question is i believe is how to check ( i think usign Active X) if the exel table has any values in there or if it is blank many tha
  • Unable to Create New web Site in IIS 5.1
    by Saravanakumars38
    3 Replies
    Last post by jwelch
      • Hi, I need to create a new web site in Internet Information Service. This can be done by opening IIS manager. In IIS Manager, expand the local computer, right-click the Web Sites folder, point to New , and then click Web Site . The Web Site Creation Wizard appears. But if i right click the Web Site Folder. only Properties and Refresh option is showing. New option is not shown. I wil
  • SQL Server 2005 Installation On Windows Vista Home Premium
    by Abdul Aziz
    14 Replies
    Last post by borofc
      • Hi Every One, I am trying to install SQL Server 2005 on Windows Vista Home Premium edition, when I run the Installer I received  are the following error message.   IIS Feature Requirement (Warning) Messages IIS Feature Requirement Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. W
  • Exception from HRESULT: 0xC0048004
    by Qiuwei
    1 Replies
    Last post by Jamie Thomson
      • Hi, there; I created a SSIS package in a ASP.NEP application which importing data from some .dbf file. "Exception from HRESULT: 0xC0048004" happened to two tables. I had a look this exception at http://msdn2.microsoft.com/en-us/library/ms345164.aspx, it says: The index is not valid. But there is no index defined in my destination table. Does anybody how to resolve it Thanks
  • Changing destination database for SSIS Package
    by Hugor
    9 Replies
    Last post by Juilee
      • Hi, I have a small problem. I've gone through the SSIS wizard and created a dtsx file which imports data from an access file into a SQL Server 2005 database. It has been set to delete existing rows and enable identity insert. I then edited the .dtsx package in SQL Server Management Studio and added an environment variable configuration to allow me to change the destination database. In the s
  • I4 to I8 in Aggregation
    by MikeCoffey91
    1 Replies
    Last post by MatthewRoche
      • I'm using an Aggregation task to summarize an input file by item and week before inserting it into a SQL table. Two of the fields I'm summing, because their totals per record can occasionally exceed 32k, are defined as int (I4) instead of smallint (I2). However, the summarized total never exceeds the value an int can hold. I ran into a problem on the insert, however, with SSIS tellin
  • Pass variables to an OPENQUERY
    by Vicky G
    2 Replies
    Last post by Vicky G
      • Hi all, Does anyone know if it is possible to pass variabes to an openquery statement I am trying to do something like this: OPENQUERY(LinkServer, 'SELECT column1, column2 FROM table WHERE column3 ='' + @@variable1 +'' AND column4 = '' +@@variable2 +'') Many thanks in advance, -Vicky
  • Order By ignoring the hyphen character
    by jcriv
    2 Replies
    Last post by jcriv
      • Hi, I'm using the following SQL script to return a list of part number and the order is not what I expect. Perhaps this is a collation problem but I have no idea where to look to modify that. Thanks in advance, John select part from transactions T where (T.transdate between '20070701' and '20070705') and (T.transtype = 'ISSU' or T.transtype = 'RTRN') order by part Here is the beginning of the Tr
  • can't replicate table with column name too long (from sql server 2005 to oracle)
    by cg2001 (Cristina V
    11 Replies
    Last post by cg2001 (Cristina Vancea)
      • I have a table in SQL Server 2005 who has a column with a name longer than 30 characters. The method I use for replication is transactional and the subscriber is an Oracle Subscriber. The error I get when trying to synchronize is an oracle error : "Identifier too long" and this appears when executing the "create table" statement on the Oracle side. Do you have any idea how can
  • Logical equivalent IN operator in a Conditional Split Transformation
    by windthorstking
    8 Replies
    Last post by Phil Brammer
      • I am using a Conditional Split Transformation to find incorrect city listings in a specific list of zipcodes. I have the following condition: LTRIM([PatientCity]) != 'Wichita Falls' && [PatientZip] IN '76301','76302','76305','76306','76307','76308','76309','76310') I found the && which is the logical equivalent to AND. I now need a logical operator for IN. An
  • SSIS package failing
    by Ed77
    5 Replies
    Last post by Michael Entin - MSFT
      • We are porting an existing package from SQL Server 2005 to Katami and are getting the following error: Code: 0xC0209303 Source: MasterSSIS Connection manager "SSISOperations" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider is not registered -- perhaps no 64-bit provider is available. Error code: 0x80040154. An OLE DB record is ava
  • MDX Dynamic parameter syntax
    by jrock1
    3 Replies
    Last post by Yao-Jie Tang - MSFT
      • I have a SSRS report that I'm passing a dynamic parameter to another SSRS report. The datasourse is a SSAS cube. Can anyone tell me the if following syntax is correct for receiveing report. I'm having trouble creating the datasource for the second report. I'm new at SSRS so any help would be appreciated. When I parse this code in management Studio I get the following An MDX Statem
  • User Defined Function Help Needed
    by CaptainMyCaptain
    12 Replies
    Last post by CaptainMyCaptain
      • Hello All, I hope that some one here can help. I should note that I have very limited experience in SQL. We are upgrading from a Redbrick (IBM) warehouse to a SQL server version. In an effort to avoid rewriting 3600 reports I am trying to create a user defined function in SQL that looks like a Redbrick function. Rebrick uses the function SUBSTR() where sql uses SUBSTRING(). I simply want to def
  • transaction log is full
    by cherriesh
    13 Replies
    Last post by ColSchmoll
      • hi, if my transaction log is full, do i need to execute only this command to truncate old logs DBCC SHRINKFILE ( <dbname> , 1 ) BACKUP LOG <dbname> WITH TRUNCATE_ONLY DBCC SHRINKFILE ( <dbname> , 1 ) Should I use the same command as a daily maintenance to my transaction log cherriesh
  • Sub Query in where clause on SS2K5
    by Robert Hanekom
    1 Replies
    Last post by Chris Howarth
      • I've got a problem with a specific query, which when running on the exact database, is super quick on SQL 2000, and takes forever on SQL 2005. The problem seems to arise from the concatenation done in the where statement. select * from [users] where [users].[name] + '|' + convert(nvarchar,[users].[age]) not in (select [listing].[name] + '|' + convert(nvarchar,[listing].[age]) from [listing])
  • [DBNETLIB][ConnectionWrite (send()).] General network error. Occurs when SQL times out on new Windows 2003 sp2 server
    by garrytman
    14 Replies
    Last post by mitre
      • We just replaced an older Windows 2000 sp4 server with a new Window 2003 Standard Edition sp2 server to run our batch processing. We noticed that when the SQL command times out we now get the following error in the ADO command object error collection. [DBNETLIB][ConnectionWrite (send()).] General network error. Check you network documentation. Native Error: 11 SQL State: HY018
  • Global variable: MaxPledgeID used in Parameter mapping of a property in a DTS
    by eric_o
    0 Replies
    Last post by eric_o
      • I need to understand why someone would use a global variable in a parameter mapping inside of a DTS package. The reason I ask is that I have (finally) successfully recreated a production environment involving ASP pages that push user data into a table on a SQL server across a firewall. Everything works great up to getting into the T_Pledge_Web table on my test server. However now I need to add to
  • Data Driven Subscription Help
    by 5thGen
    12 Replies
    Last post by xpherion
      • Hello all, I am trying to schedule an MDX report to run once a week and it only works if I pass one parameter per field. It would fail every time I try to pass multiple parameters. Do you know if there is way to pass multiple MDX parameters The parameter field is set as multi-value field. This worked ¨C '[Dim Travel Product].[Dim Travel Product].&[67]' This fai
  • Reaading and Processing a Recordset from Com object
    by Erik Aladas
    1 Replies
    Last post by Umachandar Jayachandran - MS
      • Hi everybody. I need help with the next topic. From a stored procedure in sqlserver, I need to call a com+ dll, this dll connect ot another database diferent to sqlserver y return this dll must return to stored procedure a recordser for ther processing. I tried with sp_OACreate, sp_OAMethod, sp_OAGetProperty but I did not know how to process a recordset Thanks Erik
  • end conversation : security context could not be retrieved
    by paulixml
    10 Replies
    Last post by David Dong
      • HI I have a service broker setup between 2 remote server. The message send does get sent to the target, but I am having a problem where the end conversation message from the target is failing. I did a trace on both the target and the source server. here's what I found On the Target Server: on Broker: Message undeliverable --- This message could not be delivered because it is a dup
  • Problem installing SQL Server 2005 Express Edition with Advanced Services SP2
    by drkbl
    11 Replies
    Last post by A-n-o-n-y-m-o-u-s
      • Don't know if this is the appropriate forum... I have encountered a showstopper problem during installation. I have installed SSEE on a fresh XP, all the checks but memory requirements passed. In the final stage of the install, during the "real work", the Client Component installation failed due to missing ASP.NET state service ( spelling). After the failure the installation conti
  • SQL Server Agent Question
    by KPatSQLServer
    3 Replies
    Last post by Vidhya Sagar
      • Hi, I am using SQL Server 2005. Under SQL Server Agent there is a job...Job1. Which has been disabled by the previous DBA. Needless to say that the DBA no longer works for the company. I am trying to get more infor about this Job. So I right clicked the job and "Script Job As" --> Create to File and view it..All it shows is: Exec msdb.dbo.sp_add_job Exec dbo.sp_add_jobstep Exec msdb.d