Answer Questions

• imanish11111 SP "Upgrade" fails.

  So I've tried today to upgrade a SQL Express instance on a machine where "proper" SQL has already been upgraded. It fails. The error code is 2259. Database: Table(s) Update failed So I thought I'd uninstall SQL Express altogether and just do a full install. But it cannot find the MSI files to uninstall itself. The part of the log file referring to it appears to be <Func Name='ProcessHeaderTable'> <Func Name='ProcessScriptTable'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='GetFileTargetPath'> <Func Name='ProcessScriptTable'> ...Show All

• Izzy545 Is this possible without using cursors?

  Hi! I have 2 tables: Person and Address Person (   PersonID int PK ) Adress (   AddresID int PK,   PersonID int FK,   Default  -- 1 if address is default for person ) so when I join those table it yelds (for example): p1  a1  1 p1  a2  0 p1  a3  0 p2  a4  1 p3  a5  0 p3  a6  0 Person may: - have one default addres and some non-default; - haven't default address; - have only default adres So proper result is: p1  a1          p1  a1 p2  a4    OR    p2  a4 p3  a5          p3  a6 I ...Show All

• Matt Ellis SQL 2005 Server Express - Instance Restrictions?

  Hi, Do the restrictions for SQL 2005 express apply to each instance or per server For example, if there are two instances installed on a dual CPU machine, can each instance be configured to use 1 CPU and 1 GB of RAM Thank you. Per instance. And in fact you don't need 3 CPUs to run 3 instances, the CPU limit means that an instance is limited to using 1 CPU, so it will not make use of multilpe CPUs if present, but you can have up to 50 instances installed on one computer, each instance limited to using 1 CPU, 1GB of memory and 4GB of data files. The instances will work within those limits but share as much underlying hardware as is available. ...Show All

• ashk1860 @@IDENTITY in code

  Hi all, I encountered a problem with SQL server mobile. I am inserting a row inside a database table through C# code and need to obtain the ID of the last inserted row if successful. I have the following in my code: SqlCeHelper.ExecuteNonQuery(connectionString, "*INSERT STATEMENT*"); Int64 id = (Int64)SqlCeHelper.ExecuteScalar(connectionString, "SELECT @@IDENTITY"); The variable id always ends up NULL. Is this the correct approach to this Is there anything else I can use to obtain the id of the last inserted row in SQL server mobile -- The class SqlCeHelper is a wrapper that I wrote, it works 100%. Thanks Hi, No...unfortunately SQL mobile doesn't support the function. I though of the t ...Show All

• iw2nzm User credentials delegation from IIS on WinXP to SQL Server on Win2003SRV fails

  Problem: I am trying to create an asp.net website with integrated windows authentication to access SQL databases. IIS resides on WinXP and SQL Server on Win2000 SRV. Both are in the same NT Domain. IIS and SQL Server cannot reside on the same machine and a stand alone web server is ideal as the website needs to access multiple SQL Servers. IIS is set to Integrated Windows Authentication. The machine running IIS & the SQL Server are set to be "trusted for delegation" in active directory. The domain user accounts that will be accessing the databases are not marked as "Account is sensitive and cannot be delegated". The connection string that the web app uses to connect to SQL database is: "Data Source=PWSSQ ...Show All

• n0valyfe Support for Multi-Valued parameter in Custom Data Extension

  I have a stored procedure which returns me a list of values. I am letting the user select 1, some or all of those values. When I try to pass this multi-valued parameter to my Custom Data Processing Extension, I get this: An error occurred during local report processing. Cannot add multi value parameter 'Value' for dataset 'ReportData' because it is not supported by the data extension. My question is. How do I make my data extension support multi value parameters and if that is not an easy task, how do you go about sending in the comma delimited string coming out of the multi value parameter. Is it an interface I have to implement Is there something that has to be set in the config file ...Show All

• goreng Merge replication: problems upgrading SQL-2000 to 2005

  Hello! We have a module in our business-application, that automatically installs merge replication of the business-application's database, both at publisher and subscribers. It's intended for Sql-2000. Now we need it to be applicable also for Sql-2005, so the module requires some changes, because, as we noticed, sql-2005's replication technology differs from Sql-2000's one. A few questions to experts, familiar with Merge Replication in SQL-2005: 1. Is it possible to create hybrid replication , with publisher running at SQL-2000 (MSDE) and subscribers running at SQL-2005 Express Merge publication is not supported in SQL 2005 Express, but some users may require option to use the application at free-of-charge database platform. 2. ...Show All

• H.Saber Does SQL Server 2005 Express support XQuery Static Type Analysis?

  I am quite curious about SQL Server 2005 Express, since I am conducting an XQuery implementation survey for my thesis study. Yet I still got some questions and may need your help: 1. Does SQL Server 2005 Express support XQuery static type analysis (from http://www.w3.org/TR/xquery-semantics/ ) 2. If so, since the W3C standard is still changing, how do you keep up with the change efficiently Your help will be appreciated. Happy New Year and Thank you, Selina, Wang hi Selina, SQL Server 2005 XQuery implementation is alligned with the July 2004 Working Draft of XQuery http://msdn2.microsoft.com/en-us/library/ms345122.aspx ... when using a specific tool, you can and obviously should be concern ...Show All

• R Raghu SQLCE 2.0 and SQLCE 3.0, both on same server

  I presently run on my server SQL SERVER CE 2.0 and want to install, in addition on SQL Server 2.0, SQL Server Mobile 2005. Is there a procedure to have both installed and running on a computer Thanks! Marco Thanks, wish that someone will help... moving to setup forum. ...Show All

• morning_wind Anonymous Access from Pivot Table to OLAP 2005

  My asp-net web application connect to Analysis Services 2005 through Pivot Table client. To use anonymous access with AS2000 i used to add this property to the connection string of the pivot: "SSPI=anonymous". Which property give me the same thing with AS2005 Thanks! Hey David - good to hear from you ! Yes, you could still use SSPI=anonymous, but I really recommend in AS2005 to use standard OLEDB property for this purpose, i.e. Protection Level=none It has slightly better (more standard) behavior. Mosha ( http://www.mosha.com/msolap ) Hi, The SSPI connection property is still there, so it should work the same. Are you getting an error David Botzenhart ...Show All

• IgorV alfanumeric counters?

  Hi there, T-sql 2005 is offering the possibility to define alfaphanumeric counters I mean, stuff like this: a,b,c...z, a1, b1...zn...a2.. Is it possible or it must be built for yourself I'm awared of IDENTITY function when I ran Sql2k but it doesn't target my goal. Thanks for your time, You'll have to build that yourself. The question you need to ask yourself is why do you NEED an alpha-numeric identity. If you plan to process a field differently based on the format of the field then you're getting into the "database within a database" scenario which is bad. ok, thanks for that. At the end of the day it was related with Oracle. Thanks Darren You could do this in a Data Flow i ...Show All

• SanthaMind error: 26 - Error Locating Server/Instance Specified

  An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)   Does anyone know what could be wrong   Naeem Sheikh wrote: I installed SQL Server 2005 and I unable to connect my client Machine. I Created a DSN to connect to the Database through ODBC. Locally I am testing and everything works fine. The error is “SQL Server not Exist or Access Denied” on a client machine. I m using SQL server authentication with Mix mode install ...Show All

• Quirm Sql Server Error Remote Access

  Hi all, i need to upload time tracker in a static ip which doesnt have sql server, after the installation there in static ip, i receive the following error while trying to access Named Pipes Provider, error: 40 - Could not open a connection to SQL Remote Server 2005 need help Regards, Prasenna. K There are some things that I don’t undestand from your explanations: "I need to upload time tracker" What is time tracker " in a static ip which doesnt have sql server" You want to deploy it to a server on the internet which has a static ip "after the installation there in static ip, i receive the following error while trying to access" WHere do you receive t ...Show All

• n0n4m3 Difference between subquery and WITH in terms of performance?

  Hello Everyone, Does anyone know if there is a performance difference between the new WITH clause t-sql and the subquery On a basic functionality level, they seem to perform the same function but I was wondering if there are any performance difference between the 2 Thanks, Joseph Assuming you're referring to a derived table, rather than a subquery   The answer is, no -- they will generally get the same plan.  But if in doubt, view the execution plan and verify yourself...   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     <Joseph Ollero@discussions.microsoft.com > wrote i ...Show All

• Kamii47 Can I install a Enterprise version analysis service on a Standard version of SQL 2005 server?

  Hi all, Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition. So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation. Is it possible to keep data engine as standard version and install a enterprise version of analysis service Thank you very much Tony Yes. This is supported as in SQL Server 2005, Standardard SKU and Enterprise SKU can be installed side by side successfully. Of course, their instancenames must be distinct. ...Show All