Answer Questions

• Henllys Decimal Separator with Comma... is Possible???

  In Sql Server Express I need use in field MONEY "update product set price= '1,23' where cod='001'" i don’t use "update product set price= '1.23' where cod='001'" hi, with all kind of datatypes supporting fixed or non fixed decimal values you have to use the "." as decimal separator... so you have to code UPDATE ... SET price = 1.23 WHERE... and this without the " quote for the value... regards ...Show All

• step Installing SQL SERVER 2005 Enterprise Edition On Windows XP??????

  Hi, I brought the MCTS Sql Server 2005 Implementation and Maintenance,Self paced training kit recently but i cant get my hands on the required OS for SQL Server 2005 Enterprise Edition which comes with the book. (Too Expensive!!!!!!) Is it OK to intall it on Windows XP Will I encounter any problems Many thanks Uma are you able to short ut this problem Server type: Database Engine Server name: I enter localhost Authentication: Windows Authentication When I click connect, I consistently get an error message Hi guys.. Thanks for all your help !! Your posts have saved me from spending abt ￡60 on buying the developer edition. Uma. Like Gun ...Show All

• hieu.nguyen Is it possible to get MSDE & SQL Server 2005 Express run on the same machine?

  Hi guys, I'm just wondering if the MSDE & SQL Server 2005 Express can run on the same machine(winxp) without conflicts. Because I need both the reporting services & the publication functionality of replication. Thanks in advance. Thanks guys. I appreciate ur time. :) Hi, Yes as said you can run both on same machine without any problem, my machine have both installed on it. Hemantgiri S. Goswami Hi, yes running both instances on the same system is possible. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• chance1166 Using expressions with FlatFile connections?

  This seems so obvious, but is causing me a lot of trouble: The flat files input to my SSIS packages may contain an empty line between each row of data, or may be "continuous" without any extra empty lines. Here are small examples of the data I'm working with: With the extra line: "M","SFH","Single Family Mortgage Loans","Single Fam Mtg" "M","MFH","Multifamily Mortgage Loans","Multi-Fam Mtg" "R","MIX","Mixed/Various/Unknown","Mixed/Various" Without the extra line: "M","SFH","Single Family Mortgage Loans","Single Fam Mtg" "M","MFH","Mult ...Show All

• JohnGalt An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue

  Hi Guys, Can anyone help me with this error An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source ...Show All

• csLearner Books Online

  I have registered to use SQL server 2005 Express Edition.  I want to download relevant documentation for books online. The guidance for this is to download the 'SqlServer2k5_BOL_Jul2006.msi' software. When I initiate this download:- (1) I get a message from my ISP (I.e AOL) saying the publisher coud not be verified, and asking if I wanted to run this software. (2) when I press 'run' software is downloaded to a tmp file, and I get the option to install. (3) On clicking the install button, a Windiws Installer message appears - this states that ' the installation package cannot be opened and suggests contacting the application vendor to verify that this is a valid Windows Installer Package. How can I  access the ...Show All

• jdang Enterprise ETL "Appliance"

  At least one company has developed such a product. Here's a link: http://www.dataintegrityinstitute.com/copula.htm I am interested to read your thoughts on this. DISCLAIMER: I don't work for the aforementioned company and don't benefit from them in any way. Duane, Please tie this post back to SSIS, or it will get deleted. This is an SSIS forum, not a bulletin-board. this website looks suspicious to me. sry, i don’t think these guys are reliable. Phil Brammer wrote: Duane, Please tie this post back to SSIS, or it will get deleted. This is an SSIS forum, not a bulletin-board. Ok. My understanding is that ETL appliances are the wave of the future and that many of these devices wo ...Show All

• Windows Project RS Security rsAccessDenied

  Hi all, I'm new to reporting services and having a nightmare with setting up the security. The problem is as follows: I have been forced to allow anonymous access on IIS6 but have a requirement where some sub reports need to be secure because they are of a sensitive nature. When I remove anonymous access from the secure reports and add specific active directory accounts, it works fine if I am logged on to active directory with that account. Most of our users are not in AD and will just get an rsAccessDenied message. I need RS to prompt for a username and password. I can achieve this by specifying that the user provides a username and password on the shared data source, but this doesn't give much flexibility. The primary data sourc ...Show All

• Philly10407 Matrix control

  Hi all, I'm using matrix control as my reporting tools. But i found one trouble, how can i do my matrix become like this. Product A Product B Customer Price Qty Price Qty Customer A 10 10 140 160 Customer B 12 120 120 160 Customer C 10 10 110 140 The price and qty is the static column, and i would like to make the static row also. (show in red color) but i can't. Please help... Thanks Kendy Hi, I see the problem and I'ts seams somthing worng with your matrix setting since this problem should no ...Show All

• tgbt Frequently update and select Table Locking Problem

  Hi guys,               I faced problem related to Locking and Isolation Level on Table(s).               My problems is there r some tables which r frequently updated, and I also want to fire select query over   those tables every 1 seconds and want to get only committed records.             In current scenario we start transactions with ReadCommitted Lock for updating records. But in this scenario I can’t get select query result because of some of recourses r used by transactions so after some time it gives Deadlock error .     ...Show All

• tri4pro Error 28092 when upgrading from Express to Workgroup Edition

  Hello, when I try to upgrade SQL Server 2005 using this command line: setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine INSTANCENAME=Z1 SQLACCOUNT=NT-AUTORITAT\SYSTEM SECURITYMODE=SQL SAPWD=XXXXXX I get error 28092 (administrator rights needed). It seems like the upgrade tries to use Windows authentification although I've told it to use SQL Server authentification. Or did I miss a parameter in my command line If I do the upgrade manually it works without needing Windows authentification. Sorry, but this doesn't answer my question: Why does this error not occur if I do the upgrade manually And how do I have to change my command line above to get the same result ...Show All

• micronax SSIS Deployment Question about Conn Strings? Please Help.

  Hi everyone: I have a package(SSIS) that works fine on a local SQL Server. Once I deploy it to the server A, and change the connection strings, it throws the following error: Error: The AcquireConnection method call to the connection manager "DatabaseName" failed with error code xxxxx. Error: component "OLE DB Destination"(16) failed validation and returned error code xxxx. Error: An OLE DB error has occurred. Error Code: 0x80040E4D. Al OLE DB record is available. Source: "Microsoft SQL Native Client" Description: "Communication Link Failure" Error: Error: An OLE DB error has occurred. Error Code: 0x80040E4D. Al OLE DB record is available. Source: "Microsoft SQL Native Client&quo ...Show All

• TheAgent Does SQL permit use of a column alias directly in the CASE statement?

  Our Case statements can get very long and complicated and I would like to maintain just a single "Case" and than depending on the type of set I'm processing, use this generic "Case" statement to properly decode the value. My SQL code is listed below. Select 'PCAR' as [vtyp] ,Case When [vtyp]='PCAR' and substring(veh_vin,8,1)= 'A' Then 'Cyl = V-6 Fuel = Gasoline' When [vtyp]='PTRK' and substring(veh_vin,8,1)= 'A' Then 'Cyl = V-8 Fuel = Diesel' When [vtyp]='PCAR' and substring(veh_vin,8,1)= 'B' Then 'Cyl = V-6 Fuel = CNG' Else ' ' End as 'Engine_Decode' From veh_owner Where substring(veh_vin,10,1) = '3' --Selects on cars Union All Select 'PTRK' as [vtyp] ,Case When [vtyp]='PCAR' and substring(veh_vin,8,1)= 'A ...Show All

• KevinBurton Creating Pull Subscription using T-SQL

  Hello, i am trying to create a pull subscription to my publication using T-SQL. The pull subcription is created successfully but the problem is that data is not merged correctly. I mean when i run the agent ( despite of having data in subscription / publication ) the data is not merged and i get "No Data Needed To Be Merged" message. i run following sp in this sequence: At Subscrber: 1 - sp_addmergepullsubscription 2 - sp_addmergepullsubscription_agent At Publisher: 1 - sp_addmergesubscription Again at subscriber : Transaction for adding merge agent job. Regards, OK, just to be clear, you've generated the snapshot and applied it to the subscriber, correct Now you've made more changes (at publisher o ...Show All

• vasudupe Data flow task multiple destinations

  Hi, The further i get with doing my current SSIS package the more i am starting to wonder about best practices and performance. My current package loops through CSV files in a specified location and extracts events from these files. Each file contains multiple events which are a mixture of different types. Depending on the event there are a different number of comma seperated values. In the package i firstly set each event to one column seperated by a comma delimeter. I then create an array for the event which is split by the delimeter. In a script i weed out all elements of the array that are common to all events and set the remaining events to another array. After some processing i come to my conditional split transformation which splits ...Show All