Answer Questions

• Bay Prince Does anyone know how to fix this?

  hi this is my problem : SELECT * INTO Sales FROM Sales1 WHERE 0=1 ON [MyFG1] the problem is in filegroup MyFG1, rest works fine So if anyone can help, i'd like it to work this way, to copy only first column names from Sales1 to Sales but in this filegroup. thanx ;) ok i made it thanx Can you please write me the code.. fot point 1. from your comment   The wole idea of me asking this is that i ne ...Show All

• Mark S. Milley, MCSD SQL Server Express 2005 fails to install

  I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require. Web Developer and C# Express install OK. I have been trying to install this for around 2 weeks now with no luck ... I even had the PC formatted and rebuilt but the install still fails. If it installed and worked before, i cannot understand why it doesn't work now. The summary log is p ...Show All

• jclausius - SG Creating DTS

  Are you referring to Data Transformation Services package in SQL Server 2000 or SQL Server Integration Services package in SQL Server 2005 If it's the latter you can create an SSIS project using the Business Intelligence Development Studio which is part of SQL Server 2005 in editions from Developer Edition and higher. Andrew Watt MVP - InfoPath wrote in message news:6a53eb64-e504-4710-99bf-527c9aa02e46@discussions.microsoft.c ...Show All

• perrymans Cannot change naming metadata

  Hello, I've found a bit of an infuriating nuance in SSAS2005. My cube used a view called view1. At some point in time the DSV was changed to use a very similar object called view2 instead. I got a failure when processing the cube. The message was: Errors in the OLAP storage engine: An error occurred while processing the 'view1' partition of the 'foo' measure group for the 'bar' cube from the foobar database. In other words...the n ...Show All

• David Hary Can multiple Reporting Services use one SQL Server?

  I'm working with a team that's trying to get a new set of development servers working and have run into all sorts of issues, mostly w/ Team Foundation Server and RS, but it has caused to us to ask a number of questions about the use of RS. All our servers are virtual servers, running W2003. We have: + one SQL 2005 server installed w/ SSIS, SSAS, and just the RS databases. + one Web server (IIS6) hosting multiple websites. I installed th ...Show All

• hafez ParameterMetaData.getParameterType gives errors

  Hi, I'm using SQL Server 2005 and the new JDBC, version 1.0.809.102. I'm trying to get the ParameterMetaData out of a PreparedStatement, and have mixed success. When getting the parameter type data out of very basic queries, like SELECT * FROM users WHERE users.user_name = I get the expected results, but when using a more complicated query, with joins like SELECT * FROM users INNER JOIN customers WHERE customers.customer_name = I get this ...Show All

• Mladen Perisic Default Values do not show in WinForms.ReportViewer parameters

  I have two multivalued comboboxes on my report. One cascades from the choice in the other. In IE or report preview the default values load and show on the form. In the reportviewer control the default value needs to be selected in one which then causes the default value to load in the related combobox. I was hoping to find some custom code for loading the in the report_load event but Custom Code is hard to come by. I just got the Osborne 2005 ...Show All

• oguevarra Failing to install SQL2005 Express and Standard Edition on Via Eden CPU.

  I've tried to install SQL 2005 on a fanless PC with a Via Eden CPU with Windows 2003 Standard and at the end of the setup procedure it hangs when SQL engine tries to start. Analyzing the log the error reported is: Error: 17311, Severity: 16, State: 1. SQL Server is terminating because of fatal exception c000001d. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handl ...Show All

• Scott Elliott SSIS: varchar(max) or nvarchar(max) help

  Please I know this is fustrating but I really need help with this issue: I am getting data conversion error when I tried to load data from one SQl table to another SQL table using SSIS. The source table has a column with data type nvarchar(max). Also the destination table has the same data type nvarchar(max) but I keep getting conversion error when I use SCD transformation. Error: " Input column "des" (116) has a lon ...Show All

• Alois Money conversion

  Hi! When I write: 'SELECT Amount FROM tTransaktion' I get returnvalues such as '12000.0000'. Instead, I want it to return '12 000'. The Amount column is of datatype money. Is this possible! Thanks! select amount, amt, left(amt, len(amt) - 3) as [What you want] from ( select amount, replace(convert(varchar(20), amount, 1), ',', ' ') as amt from ( select convert(money, 12000) as amount ...Show All

• CEO-Match Analysis services: Locking partitions

  Table A in SQL Server 2005 is split in partitions where the oldest partition will be deleted when the new partition fills up. Data aggregation using Analysis Service is powerful, but when syncronizing against the database, source data from the deleted SQL Server partition/file group is removed and aggregations in Analysis Service will be updated. Is there any possibility to avoid updating the data for certain partitions and lock the data in p ...Show All

• kawak Memory Issue with Simple CLR Based Table-Value-Function (TVF)

  Hi, We are seeing memory issues with a simple C# based TVF that splits an input string into a table based a delimiter.    Entries such as the following show up in the SQL log:  AppDomain 8 (DBName.dbo[runtime].7) is marked for unload due to memory pressure. AppDomain 8 (DBName.dbo[runtime].7) unloaded. These entries only show up after the TVF has been called many times (~ half million times or more ...Show All

• DOrsborne Encrypted password in DB and reused later

    Hi guys... My question.... I built an vb.net app that set some parameters and runs a store proc. Besides, the vb.net app creates an user with admin rights, his credentials: username and password are stored in DB. I thouth to encrypt password with hash + salt method. The problem.... Hashing password means that they are not decrypted ...only compared ..and here the problem....I would like to reuse this password to be u ...Show All

• iaragorn Sourcesafe 6 and SQL 2005 Project Studio

  Hi, We're thinking of using the new SQL 2005 with the new studio 2005. Can we use the 'old' sourcesafe (version 6) or must we upgrade to sourcesafe 2005 Thanks ...Show All

• Henry_2003 Why do all packages in the project open when running one in debug mode?

  Does anyone know why this happens When I run one of the packages in my project (by hitting the play button in the designer), all of the other packages in that project open before it starts running Thank you. Is this also true for all packages in all projects of a solution I have multiple projects for a SSIS solution, and when I debug one of the packages in one of the projects, all the packages in all of ...Show All