Answer Questions

• VerusMaya CURSOR/FETCH Issue

  Hey Everyone, I have an issue with pulling data out of one table and concatinating it into another table. There is a table with a list of Work Orders (tblWorkOrders) that has a one-to-many relationship with a table that contains a list of Work Order Comments (tblComments). I want to concatenate all the work order comments together into one Text field in the work orders table for each work order. For example, if tblWorkOrders.ReqNum matche ...Show All

• antony leo Transaction context in use by another session.

  I'm having a SP1 on server A. This procedure has a begin trans and a commit. In this procedure i'm inserting data into tables. This data is provided by an extrenal app in staging tables. On the tables i'm inserting data on i'm having triggers that again are starting a SP2. I'm using a cursor on the inserted table to achieve this. The SP2 only insert a record on a table that is on a linked server. For testing reasons at this moment this is ...Show All

• forwhat79 Strange cube processing error

  We have a bit of automation that creates a relational star-schema database and deploys and processes an SSAS2005 database (using an XML/A deployment script). Sometimes (but not always) during this process an error is thrown: Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: A transport-level error has occurred when sending the request to the server. (pr ...Show All

• jillab Synchronize data via GPRS???

  I made application (using .NET) to transfer data using PDA via GPRS and then upload data to database server. The data not update old data but make new insert new data to database server. If we use USB to synchronize data from PDA to database server, we can use merge replication. But i still confused how to synchronize data, if we transfer data from PDA via GPRS, then insert to database server Regards Agus Ilmi ...Show All

• JaysonC Detach sql2000 msde database using SMO.

  Hello, I am trying to detach a database from an instance of msde 2000 using smo.  When I call the Server.DetachDatabase function using my valid server object I get the following error. "This method or property is accessible only while working against SQL Server 2005 or later." Does anyone know if it is possible to detach a msde database using the .net smo objects.   What I am trying to do is detach the d ...Show All

• spiritualfields Synchronize problem

  I want to replicate my database with table like this: +-----------------+ | Table | +-----------------+ | ID | | Distributor ID | | Total Sales | | ... | +-----------------+ At table above you can see that I have a field called Distributor ID. The scene like this, I have 4 distributor that have replication of my database. Each day they synchronize database from distributor (lets call they A, B, C, D) into my server. So at th ...Show All

• GaryCanada Metadata driven SSIS

    I am looking for some pointers on Metadata driven SSIS.   Specifically, how to automate creation of a large number of packages in SSIS using metadata.   I am looking at this as a solution to deploy multiple packages on multiple servers. Any other ideas on this would be highly appreciated.   Thanks   Vishal Verma Well, I am not sure either. I read some posts by Microsoft ...Show All

• kab122 service broker error : Connection handshake failed

      When I configure SSB in two machine to send message, I get a error message in target machine SQLProfiler:     "Connection handshake failed. There is already an existing connection with the same peer and this connection lost the arbitration. State 80."     Then I get another message "This message could not be delivered because it is a duplicate.", but I am sure the configuration of routes is r ...Show All

• Russt Connection Issues

  Hi, I have sql express server running on a network pc. I have created an application on the same pc that is able to access the data contained within the sql express server. I have depolyed the application to another network pc, but it is not able to access the same data. I have also installed 'ssmse', this cant connect to the database either I have enabled the TCP/IP Protocol on the server, enabled the browser service, disabled the fire ...Show All

• Queen of the desert SQL Server Management Studio DDL Incompatible with v2000

  I have developed a database using SQL Express (2005). During development, I ran the aspnet_regsql.exe program on the SQL 2005 database to implement the default Membership and Role Providers for the .NET 2.0 web application front end for this database. Anyone familiar with this tool knows that, among other things, this program installs aspnet tables, stored procedures, views, and database roles. I generated a DDL script via SQL Server Manageme ...Show All

• BNavas source control integration

  If my company is using ClearCase instead of VisualSource Safe, can I still leverage the new 2005 checkin/checkout features ...Show All

• Bruder Script generation for Objects - Management Studio

  How do I generate a single script for each object - table, view, index, trigger, sp, function etc.... in SQL Server. The script that is generated from SQL Server wizards is in a single file. I want to have separate file for each of the objects. Well we have the same feature in SQL 2005 but I need one individual file for each object. I do not want the script of say all tables in file. I want this in differen ...Show All

• K Wenzel 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

• Valkrye SPIDs blocking itself

  Running sp_who2 on our SQL Servers during peak time (where more data come in), that the same spid is displayed multiple times and some of them blocking itself. DISKIO and Lastbatch on all these will the same, while the CPUTime are different. This is how the result of sp_who2 looks: SPID        Status         BlkBy      Command  ...Show All

• till_hm Can't uninstall Reporting Services

  I need to reinstall Reporting Services but during uninstall I face the following error: "The setup failed to read IIsMimeMap table. The error code is -2147024893" Nothing seems to help with the problem. Regards, Ksenia I am also having the same problem,  Is there a way I can get around this without havin got rebuild my machine Thanks KDog! Uninstalling IIS worked! ...Show All