.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

0 transactions rolled back in database 'testdb' (33). This is an informational message only. No us

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

0 transactions rolled back in database 'testdb' (33). This is an informational message only. No user action is required.



plz help me any one ..suddenly this type erro megs looged in sqllog why its happen?



any one give nay suggestions to  me

View Complete Post

More Related Resource Links

get the last inserted row ( autoincrement id ) in mysql database back


In my mysql I have an autoincrement id , whenever I add a new row into database I need to store this id in other table, so how to get this autoincrement Id back?

Errors in the back-end database access module. OLE DB reported an overflow of the data type for colu

Getting an error when processing a dimension, Errors in the back-end database access module. OLE DB reported an overflow of the data type for column 0. Errors in the OLAP storage engine: An error occurred while the 'xxxxxx' attribute of the 'Dim XXXXXX' dimension from the 'XXXXXXX' database was being processed. Content of this dimension is very similar to one that is processing no problem. The content of the dimension is one field only of type date.  The original content was imported through SSIS from a DB2 database on an iseries machine.  Thought a first the issue was because of the data contains some null values but the dimension the process OK also has some null  values.  The dimension that processes ok is also a single field of type date. Any help greatly appreciated, Roscoe

Writing values back to a database

Hi All, I'm trying to write values back to an access database from an open source mathematical programming language (called glpk) using ODBC. I succeeded in doing so in most variables except one. The problem is described below: The following code gets an error when writing the data: \begin code:   table x3_iii {j in TF, k in C, p in P, t in T: x3[j,k,p,t]>0} OUT 'ODBC'   'FileDSN=.\d2.dsn'   'UPDATE ((Channels a INNER JOIN ChannelPeriodProducts b' 'ON a.ChannelID = b.ChannelID)' 'INNER JOIN TransformerTypes d' 'on a.OriginFacilityID = d.FacilityID' 'SET b.Quantity = ?'   'WHERE d.TransformerTypeID = ?'   'AND a.OriginFacilityID =?'   '    AND b.ProductID = ?'   '    AND b.PeriodID = ?':   x3[j, k, p, t], j, k, p, t; \end code Note that the sql is on multiple lines, because of a maximum strings limit in the glpk (but the way I used in the code is fine and worked without problems for writing other variables). Now, let me describe what I am basically trying to do: I'm trying to write the values for the variable x3[j,k,p,t] in its field "Quantity" in the table 'ChannelPeriodProducts'. The indices for that variable are j,k,p,t. The 'ChannelPeriodProducts' table has a "ChannelID", "PeriodID", "ProductID" and "Quantity" field

Problems with SSRS 2008 Install when configuring a back-end database on a SQL Server 2008 R2 environ

We are tyring to configure SQL Server Reporting Services (SSRS 2008) not the R2 version with a SQL Server 2008 R2 version of database. We are facing error when the configuration manager within SSRS tries to execute its scripts against the database. Do you think that SSRS 2008 may have trouble using a SQL Server 2008 R2 version as the back-end? Also, what kind of permissions does the ID installing SSRS needs to have on the SQL Server database ?  Not much is available in the documenation or online.

How to extend this query to write the results back to a database?

FOr this query I have four tables I would like to access. SELECT StockA, SUM(Score) AS Total FROM dbo.ScoresNew_LongPrice WHERE [When] >= @StartTime AND [When] < @EndTime GROUP BY StockA ORDER BY SUM(Score) DESC _LongPrice, _ShortPrice, _LongVolume, _ShortVolume I would like to improve the above query to return not just the results from LongPrice, but four columns, of sum(score), from each table, if possible. And, if that is possible, I would also like to have the query then update another table with its results.  Not a new table, but just updated to an existing table. Anyway, I can do some stuff in T-SQL but this seems over my head.  Any help would be appreciated. (The four tables all have identical structures)

Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' cou

Hi. I have connected my SSAS in SQL server 2008 to an Oracle database.  I have installed the Oracle ODAC to enable me to set up the Data Source, the Data Source View and the Cube.  Now everything was going fine.  I could connect to the Oracle Database and I could see my tables and pull them into the DSV. But.  When I come to process the Cube it throws these errors.  Why all of a sudden do the connection objects stop working? Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DBIBGEORAclients', Name of 'DBIBGEORAclients'. Can anyone help here please? Thanks, David.

how to count transactions done on your database by T-SQL query?


Dear All,

I have multiple database and I want to know how many transaction that are happening per database using T-SQL, can anyone help me?





Karim Alaa

how to make a back up file(.bak) of database


I need to make a back up file(.bak) from my database (.mdf)

I learned that i need to use Ms SQL Server management studio express. I can't figure out how to connect to the database. looks like I need to select a server type, but nothing comes up for me to select. The databse was made using visual developer 2008 ms sql server, so i thought something like "SQl Server 2005 or 2008" comes up, but it didn't. What am I doing wrong.. Please help.

MySql Database back


I developed a software in ASP.ne-VB.net with MySql as database, I wanted to back up the database every end of the day,how to backup and restore the MySQL Database

Error Message: Configure Database after changing the IP of the pc


hi All

When i click on Central Administration, I get a error message as  Configure Database after i changed the IP address of the MS Server 2008 R2. If i delete Sharepoint databases from SqlServer 2010 and then configure the database again it works fine. Why it ask me to configure database when ever i change the Server IP address?

Getting error message and other data back from SSIS to managed code




From a SharePoint workflow we are trying to synchronously execute an SSIS package - which seems to work - and display error messages and return some variables back to SharePoint.


I followed the "Running a Package Remotely by Calling a Remote Component or Service" instructions on http://msdn.microsoft.com/en-us/library/ms403355.aspx and executing and parameterizing the package does not seem to be a problem. But the SSIS package does a lot of plausibility checking and raises an error (RAISERROR in T-SQL or Error

Can't bring database back online after backup


Hey forummers,

I'm a little frustrated here. I have turned the default database offline then used windows explorer to copy the database to another location but when I tried to take the database online again this error came out:

Cannot open user default database. Login failed.
Login failed for user 'Zephere-pc\Zephere(JuLian Yong)'. (Microsoft SQL Server, Error: 4064)

The cause is that the default database is set offline, How do I bring it back online agian?

URGENT: windows server corrupted - how do I pull back the sql server database in a new installation?



I have a major problem. I have windows 2003 serverm in it I have installed sqlserver and on it several databases that was published for months.

Now, the windows 2003 server crashed and I cannot login ti windows anymore. 

What I have done is to create a new installation of windows and installed again the sqlserver...

Now, how do I get back the latest database from the previous corupted installation? I still have access to the files in the previous installation.

Please help,

Windows Live Small Business and SharePoint Services Back-End Database


According to the Windows Live Small Business (WLSB) help content, there is a means to setup a survey that will allow you to use Sharepoint list data from the back-end of a WLSB web site to validate an entry from a front-end web site answer. If this is still possible, is there any current detail information that demonstrates a step by step approach to how it can be done. The usefullness of this solution would aid in web page development allowing for the developer to have a landing page in which a client or customer could fill out a survey, enter their client identification number, and then have the Sharepoint list data on the back-end validate the user's id so that if the id is not a valid pre-pitted id entry or storage of the survey entry could be declined.

Do any of you have knowledge that you could share in order to solve this solution delima?

MCITP-SA, MPN, CRCP, and WestconGroup Partner; http://oguninternationalmedia.com

How do I write code to show message box when data is not available in database


Hello everyone,

I have successfully developed the C# code that will enable me search the SQL database for text box text and display the result in a datagrid view. When the text box text is not found in the database, an empty row is displayed in the datagrid view.

However, I am at cross roads on how to write and add C# code such that a message box will pop-up if and when the text box text is not found in a data base table.

Below is my code so far:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.SqlTypes;

namespace RidersCard1
  public partial class SearchDatabase : Form
    #region Global Declarations

    // Global declaration for SQL 

Abmiguous reference message triggered by VS database projects compiler for an SQL XML query

Working with a Visual Studio 2010 database project I've written a query:

    UPDATE [s]
        SET [s].[ValueB] = [s].[ValueB] + [x].[ValueB]
        [dbo].[Something] [s]
            [XmlInfo].[Entry].[value] ('@AttributeA', 'int') AS [ValueA],
            [XmlInfo].[Entry].[value] ('.', 'int') AS [ValueB]
            @XmlData.[nodes] ('/Node')
            [XmlInfo] ([Entry])) as [x]
        [s].[ValueA] = [x].[ValueA]

Now everything works fine. Management Studio runs it and does not say a word.

Database Projects compiler however finds two ambiguities:

> Warning SQL04151: Procedure: [dbo].[SP_XXX] contains an unresolved reference to an object. Either the object does not exist or the reference is ambig

Gmail internal chat like message box

This article provides you with the multi-functional message box window through which the usability of the web-site or any web application increases.

.Configurable MessageBox window with AJAX Support
.can set maximum number of message boxes to be visible
.can define the auto reload time, for single message, for all messages or no reload
.can create messages through a single function call
.can define auto hide time for each messages
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend