Answer Questions

• Kamii47 SQL on Appliance Edition

  Is it possible to install and run SQL server on Windows Server 2003, Standard, Appliance Edition The operating system came installed a storage server. Thanks! Hmmmm.... I'm not exactly sure, but my guess is that it isn't supported on Appliance Edition. Here's the page for SQL Server 2005 Standard Edition where it lists the supported OS'es and Appliance Edition isn't listed: http://www.microsoft.com/sql/editions/standard/sysreqs.mspx Thanks, Sam Lester (MSFT) ...Show All

• nullity Anyone else have problems with Sort/Merge in For Each loop?

  Just wondering if I am an isolated case or just doing stuff other people don't. Ive created around a dozen packages for importing various types of data into a datawarehouse and some of the packages have random crashes. Over time I have been trying to tie together what the crashing ones have in common and now believe I have completely isolated it: Sort + Merge inside a dataflow in a for each loop. The more sorts and merges in the flow the more likely the problem is to occur. This week I created 2 identical packages to import some XML... one used some gnarly complicated substrings and such to extract some data and add it as derived columns while the other used the XML correctly that produced 2 streams (one being meta data - other being de ...Show All

• Bluehunter restore transaction log

  dear all, I want to restore transaction log to other server using transact-SQL. can we restore serveral transaction log files at the same time anybody have experience on this one. thanks hi rod, yes actually I want to set log shipping. but I can't set it cause my production server is using sql 2000 and my staging server is using sql 2005. so I plan to do it manually using job. if you said that we can't add more transaction log after using with recovery. so what is the best option for my case. is there a third party software to do this thanks -dedys Use the "WITH NO RECOVERY" option after each r ...Show All

• Alucaz Transaction Log does not truncate and shrink using a SQL Server 2005 Maintenance Plan

  We are using SQL Server 2005 (SP1). I have created a maintenance plan that backs up up the datebase every night. The problem is that the transaction log is continuing to grow. I have been told that a full backup will automatically truncate and shrink the transaction log. However, this is not happening. How can I truncate and shrink the transaction log after a full backup as part of our maintenance plan. Thank you. I tried to backup the transaction log to see if its size would shrink, but it didn't. I double checked and the 'Truncate...' option was set. Is there another setting which affects this Also, I'm a little confused about why the transaction log is useful at all after a full backup is take ...Show All

• Tyf ACCESS2SQLSERVEREXPRESS

  Hello, First of all, please excuse my english... I'm french :-D Can someone give me a way to convert an Access2 DB to a SQL Server 2005 Express Is it possible Thanks, I managed to export datas from ACCESS2 DB in text format. Can I insert from a text file datas in SQLExpress Even if I don't need all the fields Thanks, There is tool from Microsoft to convert Access Database into SQL Server 2005 database. I have no link for it. You can search it from Microsoft's website. Is this a silly question ! I read that SSIS is not in SQL Server Express and I'm trying to find a way to import Access2 DB to SQL Server Express DB... For importing text files into SQL Expre ...Show All

• LS6FD Does it exist a boolean data type in SQL SERVER ?

  Hello. A question please. To define a column of a table in SqlServer, Does it exist a boolean data type Thanks... Yes, it has a data type for this, this is bit (it is an integer value with the constraint to only allow 0 and 1 (and NULL of course)). HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Rob Wheeler SQL2005 Enterprise IA64 vs x64 vs x86 performance?

  I went to setup a new SQL 2005 Enterprise Edition cluster and have to admit being quite confused after reading product version and CPU requirements. This is what I seem to understand: SQL 2005 EE in 64bit native on IA64 SQL 2005 EE in WOW64 (32bit emulation) on x64 (does it still use AWE ) SQL 2005 EE in 32bit on x86 Does anyone have performance data or comparisons from having gone through this before Anyone know why the EE x64 version cannot run natively in 64bit is it an artificial limitation (Intel kickbacks :) or a technical one Since the x64 version runs in WOW64 emulation am I better off building this as a 32bit machine There exists a 64bit version of SQL Server for x64. ht ...Show All

• Aleniko29139 ReportViewer scrolling problem

  Hi, I'm having a problem with the windows forms reportviewer. With some customers, running Windows XP and framework 2.0, the reportviewer hangs when you scroll a report. These are all local reports, compiled into the application. Some reports have subreports and others dont. When it hangs you cant do anything in the application and some of the controls turn white. Has anybody else ever encountered this problem Hmm, maybe this should have been posted in the Visual Studio Report Control forum ...Show All

• Nilkanth A connection could not be made to the report server http://localhost/ReportServer.

  Hello Guys, Please take me out from this hell. I created report using VS2005 Business Intelligence Project. It builds fine. I can also see data in the design time. But when I am trying to deploy it gives me this error. TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer . ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title>Configuration Error</title> <style> body {font-family:"Verdana";font-weight:normal;font-s ...Show All

• A.F.B Percentage/Proportion

  I'm new to Analysis Services 2005 and MDX. I'm trying to create a calculated member that contains the proportion of cases (using [Measures]. ) for each dimension in the cube. The following code gives me the percentage of the total number of members in each dimension. This is what I need for attribute hiearchies (single-level), but for user-defined hiearchies (multi-level) I want the percentage of the above level. For example, in a time dimension, I want the proportion of cases in each year (this works) and the proportion of cases in each quarter of a given year (this doesn't work). CALCULATE ; CREATE MEMBER CURRENTCUBE .[MEASURES].PercentCases AS CASE WHEN IsEmpty ([Measures]. ) THEN NULL ELSE (( [DimLocati ...Show All

• da_b0uncer Query:how to transfer data from a .net application in wireless mode in a WLAN enviornment.

  Hi All,   Query:       I do have one query if u can just help me out with it .There is a VB.net application which is made for PDA under smart device application (compact framework) till date the application has Database in one central repository on desktop version of the PDA appliocation ....all time we need to run the application we need to Synchronize the data using Active Sync Software of Microsoft  ...now is there any possible method to go WIRELESS i.e we need not always need to use the Active Sync  but the data through any WLAN wireless lan technology may be having the single database at the server side we need not have the database on the PDA also .(its wat i ...Show All

• Whoisit RB - Multiple Data Source for Report Builder

  I add two data sources to the designer. Create a new dsv using one data source first. Then right click in the designer to add a new table. This time I use the second data source. When I create a Report Model and run it, an error occurred: "Message: Invalid object name 'dbo.tblTrade'. Command: SELECT COUNT(*) FROM [dbo].[tblTrade] t" It does not recognize the second data source. Look at the property of the dsv, it only points to the first data source, not the other one... MSDN Online Book link below: http://msdn2.microsoft.com/en-us/library/ms175683.aspx "Our newly created Data Source is positioned as the default, and will serve us in meeting the ...Show All

• Nick Colebourn Replication with Clarion

  Does anyone here know or have experience on doing replication between SQL server 2000 and Clarion ( .tps ). Hope anyone can give me any advice / guide / reference / etc. Thanks in advance. Not sure what Clarion is, but the only supported non-sql sqlserver subscribers are Oracle and DB2 (and maybe Sybase in the near future). On SQL 2000 it is. Is Sybase NOW supported for replication If not, when is it expected to start. I am badly in need to setup this for real-time data synchronization between sybase and SQL Server without any cost for third party tool. ...Show All

• Jason Zhang SQL Help

  When I try to install SQL express it gave an error message : SQL Server 2005 CTP Setup has detected incompatible beta components from Visual Studio or SQL Server. You must run the build cleanup wizard from the CD to remove previous SQL Server 2005 components and .NET Framework components, and then run SQL Server 2005 CTP Setup again. For detailed instructions on uninstalling SQL Server builds, see the SQL Server 2005 CTP readme file. With the greatest difficulty Found the Build cleanup wizard. But when I run it it tells that there are no SQL components to clean. And it asks me to install the SQL server (To run the SQLEXRESS) But I stil get the same error message. An cant Install the SQL Server. Pls Provide me a solution. Tha ...Show All

• junior.skunk What is the account that the SQL Server is running under?

  Hello, I need to allow SQL server 2005 to open a file in a shared directory. Any assistance or help will be greatly appreciated! Oh, MSSQLSERVER is the instance name.  If you scroll to the right, you should see a column titled "Log On As", this displays the account for the server.  Or, you can double-click "SQL Server (MSSQLSERVER)" in SCM, you should get a pop-up which displays the login info for the service account (this is also how you change the user account). Sung Thank you Sung. But, I got "MSSQLSERVER" under SCM. That seems just the service name. I grant the access right on the shared folder to the user "MSSQLSERVER", but got "user not found" error. Good point : ...Show All