Answer Questions

• M.Ghareb SQL Server CE and Memory Issue

  Hello, Have a query that consistently gives back the following message. Not enough storage is available to complete this operation The query I'm using is a little more complex than what I'm usually using. It uses Case, has extra characters in the formatting like (i.e. '-------'), connects 2 databases. Free memory can be as much as 3 MB  on the Pocket PC before sending the query and I can still receive the above message. Was wondering if t ...Show All

• Hinemac 32-64 bit versions issue

  I uninstalled the 32-bit Standard version but during install of the 64-bit trial version I got an error that the integration services could not install because the 32-bit version of COM+ was already registered and you can't have both. Need some help how to resolve this issue. Thanks I suspect there is a conflict, I always format partitions and reload from a Ghost backup when trying stuff out. Might need to chec ...Show All

• Neil Waterworth Text Qualifier {"} Not Working

  I have installed Standard SQL 2005. I have a problem to import text file in db because of text qualifier {"} not working. Does anyone have the same problem Is it a problem in my installation Thanks for ant comments. Jian I just tried a simple example along the lines of the data you just gave me, with the following input: "19760101","","1fDx" "19760102","","1fdddddddd ...Show All

• dxfoo SQL Express and windows applications

  I have a windows application that uses a small MySql as its data source. I would like to convert it to SQL Express. I would like to continue to manage the data from the windows application, but would like to make it available to the web using Visual Web Developement. I can create the new database in VWD, but how do I access the data from my application I can use either ODBC or ADO. SQL Server Express has an OLE DB/ODBC Driver, it is called ...Show All

• kmin Advenced select

  Hi, I have 3 tables. 1. TableValues with MainID, FieldID and value 2. TableFields with FieldID, FieldName, FieldTypeID 3. TableFieldsTypes with FieldTypeID, TypeName I want to create select that returns me columns as fields names and values taken from TableValues and types taken from TableFieldsTypes. How can I do this Thank's Alexei Average doesn't really do anything since there will be only one row per group (based on the ...Show All

• jon galloway VSI Templates install failed

  I just installed SQL2005 (and VS2005). When I run VSSQLCLRTemplates.vsi from the SQLCLR Project all the templates fail to install. It gives the error "Installation stopped because the directory for the ProjectType value did not exist. The project type is invalid for your installation of Visual Studio." I do have a \my documents\visual studio 2005\ directory. I am trying to start writting user defined aggregates. If I can install the t ...Show All

• lil_pepe Report Builder Help

  I have been doing everything in Report Designer....now I just tried report Builder after using a Model I creted to create a report.  When I try to run the report, it's prompting me for a username and password.  Where and how can I switch this to Windows Authentification   The dataset it's supposedly using already has windows authentification as the method.  But the strange thing is, when I click on View Report, it gives me an ...Show All

• mirren_st Unable to use Books Online search function

  I am unable to use the search feature in Books Online.  Every time I click the "Search" button, I get this error message: Package "Visual Studio Common IDE Package" failed to load Anyone have any ideas on what might be causing this error Thanks.  Unfortunately, the Visual Studio folks I need to contact are out of the office until Monday (10/31/2005).  I'm assuming you're able to access Books On ...Show All

• MaurizioBu SQL Server 2005 Reporting Serivces: XML Datasource problem

  Hi, I'm just starting to use SQL Server 2005 Reporting services, and need to use an XMLdocument as the datasource. I will get the xml data from a webservice and then need to bind it to the report. Here is what I am doing: 1. I created a webservice at the following location: http://localhost/myWebDirectory/myService.asmx . this webservice has a method called " GetXMLDocument" that has 1 parameter (sql). This method uses the sql st ...Show All

• Bill Zunis Connecting to SQL2005 Developer edition

  I'm attempting to connect to and instance of SQL and cannot seam to find it. The server logs says its listening on '127.0.0.1 <ipx4> 1545'. Kind of stuck what to check next. Will using pipes help What do I need to do Hi, check if the port listening or not using command prompt as: netstat -an | find "YOUR PORT NUMBER" for exampl, my SQL Server is listening to port 1433: netstat ...Show All

• TheOzzmanDPG Pocket PC database connection

  Hi, I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas Thanks a lot. Imports System.IO Imports System.Data Imports System.Data.S ...Show All

• RPalmer NOT EXISTS optimization

  This is a general question regarding optimization of queries that have a NOT EXISTS subquery. Sample: SELECT * FROM TABLE1 WHERE NOT EXISTS (SELECT * FROM TABLE2 WHERE TABLE1.FIELD1 = TABLE2.FIELD2) Question 1. Is it more efficient in the subquery to specify only one/any field like this SELECT * FROM TABLE1 WHERE NOT EXISTS (SELECT FIELD2 FROM TABLE2 WHERE TABLE1.FIELD1 = TABLE2.FIELD2) Basically, is the query engine actually run ...Show All

• JeffSkla SQL Express uninstallation

  I am trying to uninstall SQL Express beta so I could install the latest version but unfortunately I cannot remove it. I tried going through my control panel but it wasn’t there, I tried using the uninstaller from Microsoft.com ( http://msdn.microsoft.com/vstudio/express/support/uninstall/ ) but it gave me error messages like saying …” The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is: F ...Show All

• Dan0001 Another question about Login failed, but with Windows NT Integrated security for SQL 2005

  Hi, Happy New Year!   I have been struggling with this problem for a while with SQL 2005.   I have never had such login problem with SQL 2000. Here is the scenario:   I have installed SQL2005 standard version on a XP Pro box and I am trying to access it from another XP Pro machine.   I can access it using a SQL user name and password that I set up on the server, but I have not had luck with using Wind ...Show All

• JMZuniga Scope defined on Member Properties

  Hi, is it possible to define a scope in a MDX script based on a member property of a dimension Background: I have a "custom" measures dimension. In this dimension I have measures of different type (i.e. currency, integers, percentages,...). So I want to have the display format set for the different types. My idea was to have a member property on the "measures" dimension to save the display format. I want to use this in ...Show All