Answer Questions

• pln Linux user: creating databases

  Hi all. I just installed MSSQL 2005 Express but I can’t find a sql client I can use to create databases. Do I have to download it or it’s placed somewhere on my HD The only tools I see are placed at Start > Programs > Microsoft SQL Serve 2005 > Configuration Tools Sorry about the dump question. I come from a linux background and everything seems to be different! Cheers. Hi Dan. Thanks for your q ...Show All

• Me_Titus Encryption By Passphrase

  I am investigating methods of encrypting data in a large number of databases. It seems to me that encrypting by passphrase would be optimum because it would prevent me from having to create all those database and symmetric keys on the various databases (there wil lbe dozens of them). Can anyone give me any advice as whether or not using encryption by passphrase is a good secure method of encrypting sensitive data in a large-scale production envi ...Show All

• dc33428 A little MDX problem

  Hi, I need some support for a MDX problem. We have a cube with a measure, are region (with hierachy, but this doesn't matter at all) and two time dimensions (with the usual hierachies). The business problem is now: You select a date (on any level) from Time1. If you would place the region on rows and Time2 on colums (the days) with nonempty enabled, you would get a number of members back (about 1000 numbers in Time2 per day in Time1). I ...Show All

• Ronaldo444 JDBC API - fetching only user tables

  Hi, I am using JDBC DatabaseMetaData's getColumns() to get the table names, column names and datatype of the columns. As a result, I am getting user tables as well as the system tables. How to fetch only the user tables excluding the system tables like sysindexes, etc. I know this is possible by executing a select query (using SYSOBJECTS and xtype = 'U'). But, is there anyway to fetch only the user tables using the databasemetadata AP ...Show All

• Veblen Lee T Cannot connect to MSSAS 2005 Standard on local machine

  I have installed SQL2005 completely, including Service Pack 1. Using Mgt Studio, I can connect to the relational db. I am not able to connect to analysis services though! The error message I receive is :"A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient". The additional information says: "Unable to read data from the transport connection: An existing connection was forcibly clo ...Show All

• RJW1958 Connection

  Hi all, I was on SQL 2000 and now changed over to SQL 2005 Ex Ed. When I run my application I get the following error Mssg @ Conn.Open An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. Code: Imports System.Data.SqlClient Public Conn As SqlConnection = New SqlConnection Dim da As New SqlDataAdapter Private Sub Form1_Load(ByVal sender As System.Objec ...Show All

• Wayne Woodbury File growth problem in 2005

  Have a database, one filegroup with one datafile and one log file. However, restarted the box and saw that the growth settings for the datafile was changed from 100Mb increments to 25600%. The logfile is still the same at 200Mb as required. Both have unlimited growth. Looking at sysfiles in the database, growth is 25600 for the log and data file. In Management Studio I cannot change the setting for the data file (log file still shows 200Mb ...Show All

• Damien White Reporting Services Performance

  Hi, I'm just wondering if anyone else has had any problems with reporting services when generating reports. I have a rather large report (approx 5000 rows) and to be fair there are alot of links to other tables. However it takes 5-10 minutes to generate this report. If I manually pull the data from the database, perform the aggregations and all the table joins, it takes under 10 seconds to complete and I seriously doubt that rendering the table ...Show All

• Pradosh Error by converting string to decimal

  Hi, I'm trying to import a text-file into SQL2005 by using SSIS. Unfortunately it doesn't seem to work in the way I thought. Because I'm using the german version of SQL2005 I need to translate the items of my toolbox, so dont wonder if their names are not exactly the same as in the english versions. Try number1: a) My datasource is a flatfile, in the connection manager I changed the DataType for the input column to DT_DECIMAL. In my des ...Show All

• itanium7000 Sql2005 installation headaches

  I am trying to install sql 2005 on a machine that had VS2005 beat and SQL2005 CTp on it.  I have uninstalled every possible component that was in the beta release, and I still get the error, SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructio ...Show All

• Lariamon Transaction (Process ID 58) was deadlocked on thread error...

  In an SSIS package I am continually getting the same error: "Transaction (Process ID 58) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. The package is attempting to do a simple Execute S ...Show All

• C.R. Hinners missing date

  Hi everybody I have table that store error messages.if error message is generated today it is stored in todays date.if next error message is generated after tomorrow the respective date is day after tomorrow.but i want date of that day also on which error is not generated.more clearer all dates wether error is generated or not.my corrent query is CREATE VIEW dbo.rpt_Kids AS SELECT     TOP 100 PERCENT KF_ID,dbo.just_date_form ...Show All

• Jordachec View sort order problems

  I am testing an upgrade of our databases to SQL Server 2005 (from 2000), and I apologize if this question seems a little simplistic.  I have a view that is based on a table where the primary key is Doctor #, and it even has an ORDER BY to sort by Doctor #.  This view has ALWAYS (in SQL 2000) returned the data in the proper sort order, but once I upgraded a copy of the database to SQL Server 2005 the view resultset is no longer in Docto ...Show All

• Miah Helpmann To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)

  What could be wrong I get this error when a stored procedure is executing sp_OAMethod from SQL Server 2000 SP4. EXEC @rc = master..sp_OAMethod @Obj, 'Execute' The linked server is SQL Server 2005 x64. Already installed is SQLServer2005_BC_x64.msi version April 15, 2006. Local server is SQL Server 2000 SP4. I can execute the sproc successfully in Query Analyzer from my local dev box which has both 2000 and 2005 installed. Profiler in ...Show All

• zoid Problems when Oracle running on same machine

  I was deploying my Report Model in Visual Studio but got an error that it couldnt connect to my Report Server while it was running. When i typed the address of my ReportServer I got an error, then when I typed the name of the localhost  got an Oracle screen. So then I decided to turn off all the Oracle things running on the machine. Then when I tried to deploy again it worked and I could go to my ReportServer without problems. ...Show All