Answer Questions

• J B Li SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call

  Hi All, Iam using SQL Server Management Studio subscription wizzard to attempt to create a subscription from SQL Server Mobile to a publication on SQL Server 2005 CTP i got couple months ago. When i get to the end of the wizzard and press finish when it attempts to "Syncronizing Data" it then gives me a error as follows. "An incorrect or unsupported HTTP function call was made HRESULT 0x80004005 (28017)" Any help is appreciated. Thanks. ...Show All

• xu jiameng Connectioni leak with MDAC 2.82

  Hi, I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousends). It is using the SQL ADO provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790). Is there a knwon bug like this Is there a way to trace the ADO provider What is your code that opens and closes connection ...Show All

• crt Stored Proc Output Parameter to a Variable

  I'm trying to call a stored procedure in an Execute SQL task which has several parameters. Four of the parameters are input from package variables. A fifth parameter is an output parameter and its result needs to be saved to a package variable. Here is the entirety of the SQL in the SQLStatement property: EXEC log_ItemAdd @Destination = 'isMedicalClaim', @ImportJobId = , @Started = NULL, @Status = 1, @FileType = , @FileName = , @FilePath = , ...Show All

• Snowfire save data selected in cube browser tab

  Hi, I'm using cube browser tab for browsing for interesting cube data. Once selection is made, I want to save results to file.  Also, I would like to use cube actions and their involved features to accomplich that. Is it possible to make my own custom save method, wich will be used from various application for cube browsing, such ProClarity is. Does someone know something about... with regards   ...Show All

• bshammer Will lost update occur if transaction isolation level set to SNAPSHOT?

  Let's say if there're two transactions updating a column of the same row concurrently, will one of the update be overwritten by the latest one Unless you use optimistic locking (timestamps) or serializable transactions then this will be the case oops No an, error will occur: Msg 3960 , Level 16 , State 4 , Line 1 Snapshot isolation transaction aborted due to update conflict . Y ...Show All

• steverino_can problems to conect a cube in client due to panda antivirus

  I have the next problem: i have MS sql server 2005 installed in a server. We have some olap cubes in the server deployed with analysis services 2005. When we try to connect to the analysis server from a client pc using pivot tables we obtain this error: "Errors in network layers. Error code=0XC10D0009, External code=0x00000000" The client pc has panda antivirus (corporate) with true prevent When i unisnstall it, we can connect to the a ...Show All

• Jetjez Keep Identity on Merger Replication?

  Hello, I have a table with composite primary key: sID- int (Identity) -No to for replication UnitID (char) I would like to carry the subscriber's sID to the server since the server has its own unitID. There is not conflict. The reason I want to keep is that I don't want the Identity number to increase too fast. Otherwise it will reach the limit very soon. Is there a way to do this Thank you for help. John ...Show All

• KojiKato_MSFT How to know the next ID ?

  Hi all, is it possible to know the next record's identifier of a table without inserting it I tried with SELECT MAX(ArticleID) FROM Articles but imagine that there is no record in the table (but there was of it), the SELECT MAX statement return a null value... Thanks in advance, Gilles Hi Gilles, Try this instead: " SELECT IDENT_CURRENT ( 'tableName ...Show All

• Vasillio Linked Server to Sybase 11 problem

  Attempting to create a Linked Server to a Sybase 11 db. Did the following - Used DSEDIT to create a data source. Ping(Test) works - Created a System DSN using the Sybase System 11 driver - Created a Linked Server with following options     General Tab       - Provider as - MS OLE DB Provider for ODBC Drivers       - Data source as the DSN name created above       ...Show All

• Casey Shaar From MySQL to MSSQL 2005

  Hello! I'm installing the MSSQL 2005. And i want to transfrom the DB from my old MySQL DataBase to new MSSQL Database. How can I do this With Import|Export Utils I can't do this task =( Pleasure Help me. Thanks Issues I've noticed so far with OLEDB: a) mysql 4.0 date column type is not recognized (requires using "Edit" to change to change dest type from <blank> to Datetime). b) mysql 4.0 t ...Show All

• KevinUT same visual studio standard 2005 product key from the "ready to launch" dvd set

  Hi, I attended the Technet Ready to Launch event and obtained the dvd set, but when I tried to install the sql product, the software won't take the product key (the key is the same as the studio product).  Anyone experience the same   Support should be able to address your issue directly.  Please try the support.microsoft.com again. Chris Here's the update... U.S. and Canadian cus ...Show All

• Flounder How to Execute a DiffGram

  This article on MSDN: "Microsoft SQL Server 9.0 Technical Articles, XML Options in Microsoft SQL Server 2005" states that it is possible to execute a DiffGram using SqlXmlCommand. However, when I execute this code: static string NorthwindConnString = "Provider=SQLOLEDB;Server=NJSQL06;database=Interlink_GISLink90;Integrated Security=SSPI"; SqlXmlCommand cmd = new SqlXmlCommand(NorthwindConnString); ...Show All

• David Wrighton SQL 2005 - Rename a Named Instance

  Hi all, Ok, first I am new to this so please be gentle.  1.  I created a named instance on a existing SQL 2000 server for a installation of SQL 2005. 2.  After I named it, I decided that the name needed to be different (GOODNAME vs. BADNAME). 3.  How do I rename a named instance (NOT default instance) of a SQL Server 2005 install   I have completed the steps shown in this article.  http://msdn2.microsoft.com/en-u ...Show All

• DGPunkt Network access SQLExpress

  I am  trying to access a SQLExpress database on another computer on my LAN.  Using Windows Authentication. I don't really want to go to Mixed Mode authentication as I understand it involves a registry tweak and creating a new user. I am a novice at this. Getting the following error on running the connection code below: SQLException was unhandled "Login failed for user 'D37YKC1S\Guest'." No doubt it is a security probl ...Show All

• Miles Reporting Services Error - SQL Server does not exist or access denied

  Hi, I am unable to view my reports once deploying them.  The error I get in Report Manager is SQL "Server does not exist or access denied".  What is weird about this is that I am able to run the reports within the preview tab (in visual studio .net 2003).  When I try to use the same connection string in Report Manager I get the error.  Please note that I deploy the reports from my computer onto a ...Show All