Answer Questions

• Tvercel SQLExpress Linked Server to Oracle Express 10g

  Trying to set up a development environment on an XP SP2 machine with an installation of SQLExpress and Oracle 10g Express. Having been trying to create a Linked Server in SQL to access the Oracle EX database. Have had no luck using either Oracle driver or Microsoft driver. With Oracle driver get the following error on an openquery statement: select * from openquery ( xe , 'select top 1 * from HR.REGIONS' ) Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "xe" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle&qu ...Show All

• davidjmsdn OLAP - EXCEL problem - urgent

  Hello, I have a dimension hierarchy with 2 levels, like this: A - X - Y - Z B - U - V - T And I have a cube with the dimension above and one measure (sum). The fact table of this cube has 2 columns (level2,sumvalue) and i have the values: Level2 SumValue X 1 Y 2 T 6 When I access this cube from Excel and use multiple selection weird stuff happends. So, I create a Pivot table, in which i select only X,Y,U: Level1 Level2 Total A X 1 Y 2 A Total 3 Grand Total ...Show All

• bYmulo could not process the cube

  hi, after i deploy the cube ,i will run it i am getting the following error i have used the database egss Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Egss', Name of 'Egss'. how could i solve this regards lalitha If you want to change the SSAS service account you would do the following: Logon to the server with a user that has administrator privileges Open up the SQL Server Configuration Manager application which is found under Start > All Programs> Microsoft SQL Server 2005> Configuration Tools. Under SQL Server 2005 Services, double click on "SQL Server Analysis Services&qu ...Show All

• Trini_Pierre SSRS syntax

  Hi, basically I'm having trouble with something that's gotta be really easy. I just want to check if a field in a dataset is null from the expression editor. Also, is there a good reference out there for SSRS syntax I have a book that references a ISNULL() function in the System area, but after messing with it for a little while it's still not working and I'd rather find a good source examples than trial and erroring it every time. I could just do this in the vb code section, but that seems like too much of a hassle for something that should be this simple. Thanks, Jeff =Iif(IsNothing(Fields!ANYFIELD.Value),"The Field Is Null",Fields!ANYFIELD.Value) If this doesn't work you can also try che ...Show All

• benson81 .net and Sql Express

  Hi all, I have written a simple .net class to call sql functions like create subscription and sync replication. I am using merge replication. My Question is this:-- my class calls Microsoft.SqlServer.Replication.dll. On a machine that has SQL Express loaded it works but on a machine that does not have sql express it fails. I have made a setup project and deployed my "service". I added all references into the project and all works well on a machine that has sql express. We are running a network with 1 machine that has sql express and other machines that plug into this sql express. Is there a sql express runtime setup or do I have to load sql express on each machine. OR Am I deploying my class wrong. my setup project has the Micros ...Show All

• Tabas Install SQL Server 2005 on top of Express for publications

  Hi, i have the SQL Server 2005 Express installed but i want to create publications so i’m going to install the Developer Edition. Shoud i uninstall SQL Server Express before IN DE installation i have the following options: sql server database services analysis services reporting services notification services integration services workstations components, books online and development tools What is the minimum i have to install to create publications Thanks SP You need to install the database services which includes the Replication part. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- For the first question, the answer is no because you can insta ...Show All

• Whoisit casting date stored as integers

  Hi I have a SQL server database that have dates stored like 12142006003423 which means 2006-12-14 00:34:00 is there any way to cast it directly to a datetime type (I don't mean a user defined function as I've already implemented one) thanks Mugambo, thanks for your interest . however I was looking for a direct cast or convert statement that can accomplish this task I've created a scalar function for the ease of use as follows CREATE FUNCTION Int2Date ( @sdate bigint) returns datetime as begin declare @dt as varchar(14) declare @dd varchar(2) declare @mm varchar(2) declare @yy varchar(4) declare @hh varchar(2) declare @mi varchar(2) declare @ss varchar(2) declare @result varchar(25) set @dt = cast(@sda ...Show All

• devdev33 Confusion over SQL 2005 Standard CPU Support

  I'm a little confused over the maximum CPU count supported by SQL 2005 Standard Edition (this particular edition supports four CPUs). Does the figure refer to four physical CPUs regardless of whether they are dual-cored or hyperthreaded, or does the figure refer to the number of logical CPUs available to the OS Let me cut to the chase - if I purchase a server containing four dual-core CPUs and install SQL Server 2005 Standard, will SQL Server see the eight CPUs and utilise a maximum of four of these, or will it be able to use all eight (because there are actually only four physical CPUs) Thanks, Chris. Hi Glen, the compare-features url above just says number of CPU's 4 for Standard SQL2005 Edition (includes suppor ...Show All

• Flame Thrower SSIS Deployment

  I ahve read previous posts on this but didnt get a clear answer for what I am trying to do. I have couple of SSIS packages running in y dev environment, we will be moving this into production soon. These pachakes will be called from the webapp to run once the flat files are uploaded. Production environment has separate web server and Sql server box. Now how do I deploy the packages and where...on webserver or sql server box workflow is user uploads a file which is saved on the webserver and then the package will start to upload the data to the SQL Server db. I have seen that while storing the location of the flat file in the configuration file for the package it stores the hard coded path of the flat file is there a way for to sav ...Show All

• boulderbum Can the data tables in SQL Express database be printed out?

  Hi, is it possible to print out the data tables If, yes how to go about doing it how to print 1 table per page In my case having a hardcopy of the data is suitable than viewing it on the computer. Is there some way/method of printing out my data Like transfering to a .txt/.doc/.xls file than print from there You can show a report in a WinForm application in two different ways: You can build the report directly into your WinForm application - Add New Item | Report (Note: The VS report designer is not available in VS Express.) You can build the report for SQL Reporting Services and show the report using the Report Control in your app. (Note: The report runtime control is a separate download for VS Express.) ...Show All

• tattoo MS Sql Express Tookit error during install

  Trying to install MS Sql Server 2005 Express tool-kit on local PC to manage SQL Express on Server. Was able to get this installed on the server but would like to be able to run the tool kit on PC to build reports + publish on reports server. when i try and install on pc i get Error 1335.The cabinet file '_1979_RTL_x86_enu_VS_SCC_TeamCore.cab required for this installation is corrupt or cannot be used. This could indicate a network error, an error reading from the CD-ROM, or a problem with this package. I used the exact same install SQLEXPR_TOOLKIT.EXE on the server & didnot receive this error. Is it possible to run the toolkit on PC + connect to SQL 2005 Express on another server I am running VWD 2005 Express on client P ...Show All

• Eric66 sql native client

  hello COMMUNITY, I HAVE a CONSULTATION I HAVE a SERVANT WITH SQL 2000 AND MY CLIENTS ARE Windows 98, I WANT TO MIGRATE TO SQL 2005, LIKE HARIA WITH SUPPLIER SQL NATIVE CLIENT, IS COMPATIBLE IN the CLIENTS You mean that I can continue using he himself supplier MDAC 2,8 in the client to connect itself now to a servant SQL 2005 who is in another machine With Windows 98 clients you must continue to use the MDAC ODBC driver and OLE DB provider. You can use them with both SQL Server 2000 and SQL Server 2005 servers. SQL Native Client is support on Windows 2000, Wndows 2003 and XP clients but not Windows 95 or Windows 98. Yes. SQL Server 2005 is not configure ...Show All

• arcliner Save Word Doc in Db

  hi can u tell me plz how do i save a word doc or and excel sheet in sql server thanx the other option could be to save the Word and Excel in the database as WordML and SpreadsheetML (Office's XML representations of Word and Excel documents). Would only work if you have Office XP or higher. Just another option. If you did this you could run queries on the documents content. can u send me a sample on SpreadsheetML here's an example, it's super easy... using ( SqlConnection conn = new SqlConnection ( Globals .ChatterDbConnectionString)) { conn.Open(); using ( SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "update ...Show All

• Nancy_Issa How Change field value triggered by date?

  In a table i had field called Status and it is of type integer and another two field From and To ... they are of type date ..... what i want to do is to change the value of status field when the current date become equal to the From field and also make another change when the current date become equal to the To field ... So How can i do This on SQL server 2005 UPDATE mastertable SET Status = CASE WHEN datediff(d, detailtable.From, getdate()) = 0 THEN 1 WHEN datediff(d, detailtable.To, getdate()) = 0 THEN 2 END FROM mastertable INNER JOIN detailtable ON mastertable.PersonID = detailtable.PersonID Thank You for your reply and it is helpful, But what if the From and To fields in a child tab ...Show All

• Sledgehammer What do I need to use SSIS API on a target machine?!

  Hi, I've created an SSIS package to be loaded using my ASP .NET app. This package is kept within the application and loaded via Microsoft.SqlServer.Dts.Runtime.LoadPackage method. My target machine does not have MS SQL Server 2005 installed. So what do I need at minimum to get this up and running What components do I've to install or copy over I tried to copy just the class libraries across. I copied Microsoft.SQLServer.ManagedDTS.dll and Microsoft.SQLServer.DTSRuntimeWrap.dll into my bin directory but I got this error: [COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.] Microsoft.SqlServer.Dts.Runtime.Applic ...Show All