Answer Questions

• Gerben Rampaart Sql Server Begin Transaccion-Commit Transaccion problem

  Hi, i have this problem when i execute a job with a Begin Transaccion-Commit Transaccion sentence: "Executed as user: comfama\sqlservice. The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. [SQLSTATE 01000] ...Show All

• khubaib Cannot generate SSI Context

  New install of SQL Server 2005 (x64) Standard after uninstalling previous version SQL Server (x86) Standard. After installation, client connections are receiving "Cannot generate SSI Context" error messages. TCP/IP Integrated Authentication is being used. Kerboros authentication is failing when SQLService is running under a domain account and works when running under local system account by reverting back to NTLM authentication. ...Show All

• James E. Davey Connectivity Issues in AMO

  Hi, I am using AMO to connect to SSAS 2005 and programmatically create objects. currently I am specifying only the ServerName in the connection string. Please see the code below: <code> Server SSASServer = new Microsoft.AnalysisServices. Server() ; SSASServer.Connect ( "DataSource=" + ServerName); </code> The above code works fine and I am able to connect. Now I want to provide the instance name of the s ...Show All

• __Eli__ WMI Configuration?

  Hi All, I tried to install SQL Server 2005 Developer Edition RTM version and SCC failed with the message: "The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine mymachine Error:2147749917(0x8004101d)." Looking on SQLSetup0032_mymachine_SCC.log I have: " Processing article WMIServiceReadRegWorking Scc Error:  50024 (0xc368) Error code: 2147749917 (0x8004101d) Calling callback function for ...Show All

• Andy_Paul Understanding what this dts.Pipeline ERROR means

  Im am pulling down table called PRV from another server throught an ODBC connection in my SSIS package. I have the source and destination task all set up. I get this error when i run the packag. Most of the time, the error is pretty self explanatory but this one is .....beyond me. Any ideas. Error: 0xC02090F5 at PRV TABLE FROM CYPRESS, PRV SOURCE [1]: The component "PRV SOURCE" (1) was unable to process the data. Error: 0xC0047038 at ...Show All

• Drakx Fuzzy Grouping error when progress: Finding similar records

  I get this errors when progress is : Finding similar records [DTS.PIPELINE] Information: The buffer manager detected that the system was low on virtual mermory, but was unable to swap out any buffers. 6 buffers where considered and 6 where locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked. I'm triying to fuzzy match in a table wit ...Show All

• Brian Travis Migrating Registered Servers between EM 2K and 2005 SSMS

  I have a couple of hundred servers buried in many Groups using win & sql auth. - i'm looking to capture all those settings and import it into SSMS - i see in SSMS that i can create a *.regsrvr XML file to import settings but that apears to only support 2005 to 2005 migrations - is there an undocumented feature i'm missing here.... Thanks Phil bump In my own research ...Show All

• KPLG sql replication

  I use windows xp service pack 2. The service http://magna/SQLServerCE/sscesa20.dll is ok. SqlCeReplication repl = null; try { // Set the Replication object repl = new SqlCeReplication(); repl.InternetUrl = //"http://magna/SQLServerCE/sscesa20.dll"; InternetLogin = ""; repl.InternetPassword = /""; repl.Publisher = "magna"; repl.PublisherDatabase = "pubs"; ...Show All

• ShortBus service broker message on remote instance not working

  I was trying to send a message on a different instance in the network using service broker. I have created the endpoint and route both the side. I could see that the messages are in the transmission_queue in the sender side with no error in the status. What could be the reason. I am doing the following: CREATE ROUTE inst02 WITH SERVICE_NAME = 'SERVICE2', ADDRESS = 'tcp://10.14.43.149:2341' in the send script i am using this: BEGIN DIAL ...Show All

• KosmiCKhaoz Get Sql Err Message 15422 when activating application role.

  Running VB 2005 Express Edition and Sql Server 2005 Express Edition (SQLX). Developing a desktop application which calls a local instance of ".\sqlexpress". This app needs to set data base options and add/del various table columns. When activating the application role, I get the following message: HariCari SQL Error/s 15422 - Application roles can only be activated at the ad hoc level. Anyone know what this message mean ...Show All

• yurafromlviv SNAPSHOT Replciation - Last distributed transaction LSN ?

  Hi There When i created a snapshot replication publication on one of our servers , i noticed that it now keeps track of the last distributed transaction. I only plan on doing the snapshot every month or so. I am concerned that becasue it keeps track of the last LSN that the transaction log will keep growing, is this accurate Secondly why does snapshot replication keep track of the last distributed transaction, since it does not replicate transa ...Show All

• De_Vaddrr To Boost Performance

  We are designing the database for a high load web application . We used 4 techniques. 1.No outer joins,No Unions, > only in reports 2.No joins in main forms 3.Choose the smallest dataTypes possible. 4.Used a single instance for all users. Are there any additional MAJOR ones When you say web app, is it read only If so then pre-build the pages as html and never look back :) Seriously, this really depends on the web application for ...Show All

• DonRon1972 Multiple Devices per subscription and SQL-NS API communication

  Hi, I've got two questions, both targeting SQL-NS on SQL Server 2005. 1.  What is the best way to handle a subscription that could have more than one device associated with it   For example, a subscription that should result in both an Email and a phone call (via custom delivery channel).  I'm attempting to avoid needing to have two separate subscriptions that are identical other than device type.  This could be accomplished ...Show All

• khangngoc83 View sort order problems

  I am testing an upgrade of our databases to SQL Server 2005 (from 2000), and I apologize if this question seems a little simplistic.  I have a view that is based on a table where the primary key is Doctor #, and it even has an ORDER BY to sort by Doctor #.  This view has ALWAYS (in SQL 2000) returned the data in the proper sort order, but once I upgraded a copy of the database to SQL Server 2005 the view resultset is no longer in Docto ...Show All

• Jason L. linked server exec stored procdure results in Transaction context in use by another session.

  I am using sql 2005 beta Microsoft SQL Server Management Studio (expires in 355 days)      9.00.1116.00 Microsoft Analysis Services Client Tools      2000.090.1116.00 Microsoft Data Access Components (MDAC)      2000.086.1830.00 (srv03_sp1_rtm.050324-1447) Microsoft MSXML      2.6 3.0 6.0 Microsoft Internet Explorer   ...Show All