Multiple-step OLE DB Operation Generated Errors

Jan 31, 2005

Hi!


We have installed MPS for Service Provisioning on domain controller. SQL 200 is also installed on this server. EventView logs per 15 second following error:





Source: Provisioning and Audit Recovery Service


Category: None


Event ID: 5896





"Error occurred while moving records to the audit log database. SQL server reported errors:


Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.





For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."





I did not find the problem source and the solution.


Any idea?





Best Regards


Cicek

View 1 Replies


ADVERTISEMENT

Multiple-step OLE DB Operation Generated Errors

May 16, 2006

Hello....

I have two linked server... (ServerB and ServerC) which reside on ServerA. I am able to connect to the remote database using "Select" statements without any issues.

When I run this query, It is successful:

delete [SERVERB].MyDatabase.dbo.TableName
from [SERVERB].MyDatabase.dbo.TableName t1
Left join MyDatabase.dbo.TableName t2 on ( t1.ID = t2.ID and
t1.EmployeeNumber = t2.EmployeeNumber and
t1.AccountNumber = t2.AccountNumber)
where t2.ID is null;

However, when I change [SERVERB] to [SERVERC], I receive two errors:

"Could not find server 'ELEARN-FRM-BETA' in sysservers. Execute sp_addlinkedserver to add the server to sysservers."

And

OLE DB provider "SQLNCLI" for linked server "ELEARN-FRM-BETA" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

When I run profiler on ServerC, I see traffic... mainly a whole bunch of exec "sp_cursorfetch" operations, so I know the connection is valid.

Any ideas?

Forch

View 8 Replies View Related

Multiple-step OLE DB Operation Generated Errors?

Jan 12, 2006

I am trying to use sqlexpress (release version) with vb6. The mdf file is located in a subdirectory of the app.path. When I run the program I get the following message:

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.


What am I doing wrong? Here's the code:

Dim DbPath As String, strDbConn As String
DbPath = App.Path & "dbs" & DbName
strDbConn = "Data Source=.SQLEXPRESS;AttachDbFilename= " _
  & DbPath & ";Integrated Security=True;User Instance=True"
 
Set DbConn = New Connection
DbConn.connectionString = strDbConn
DbConn.Open

View 3 Replies View Related

Multiple-step OLE DB Operation Generated Errors

Dec 18, 2006

I'm trying to view a report on Report Manager (Reporting Services 2000) that displays Analysis Services (2000) data. I keep getting the following error message:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'CubeName'. (rsErrorOpeningConnection) Get Online Help

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I am using Visual Studio 2003 to build the report and I can successfully view the cube and pull data but when I deploy the report and data source to Report Manager I keep getting this error message. I am not using my credentials for the data source I am using a SQL account that is a sys admin and has access to the cube I am trying to view.

Additional Information: Visual Studio - local machine
SQL Server/Analysis Services - Machine A
Reporting Services - Machine B

View 1 Replies View Related

Distribution Agent Error - (Multiple-step OLE DB Operation Generated Errors....)

Oct 18, 2005

Hi,

View 5 Replies View Related

Urgent Multiple-step OLE DB Operation Generated Errors. Check Each OLE DB Status Value

Nov 30, 2007

I am using execute sql task and my sql statement contains

EXEC test ?

procedure test has 2 parameters. I added parameters using parametermapping tab. When I run i get an error message


Multiple-step OLE DB operation generated errors. Check each OLE DB status value

View 1 Replies View Related

Multiple-step OLE DB Operation Generated Errors. Adding Colums Using ADOX

Nov 26, 2007

Hi
I'm trying to add columns to an existing table using ADOX. I'm using C++/CLI. My code is as follow

Table->default->Append("new_column", ADOX:: DataTypeEnum::adWChar, 255);
Table->default["prev_instance_id"]->Properties["Jet OLEDB:Compressed UNICODE Strings"]->default = true;

The first line of code works fine but when I try to set the value of the property I get the following excpetion:

An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in MyDll.dll
Additional information: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Any idea?

Marco

View 7 Replies View Related

Export From Excel To SQL.. Multiple-step OLE DB Operation Generated Errors. Check Each OLE DB Status Value, If Available.

Nov 9, 2007

Hi all,
We have Windows 2003 64 sp2 Xeon, 2005 EE SP2 64 bit...
Trying to do conversion from DTS sql 2000..One package use load from excel to sql..So I tried to create same thing by myself.. Hell, so many issues.. So I used wizard, package created, I changed Run64bit to False, tried to run package, once - completed in debug mode.. Now it's time to create deployment utility and deploy package..During execution of manifest file got error:

Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

In BIDS, open up solution and tried to rerun package again - no way,".. cannot acquire connection from connection manager blah blah blah.."
Even tried to fire package without debugging, it fires 32 bid execution utility, so no question about 64 bit mode.. package failed..
Execution GUID: {CE11CF95-A25E-4285-A8B0-9E28E51A6785}
Message: ExternalRequest_post: 'IDataInitialize::GetDataSource failed'. The
external request has completed.
Start Time: 2007-11-09 09:41:25
End Time: 2007-11-09 09:41:25
End Log
Error: 2007-11-09 09:41:25.95
Code: 0xC0202009
Source: Package_name loader Connection manager "SourceConnectionExcel"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" H
result: 0x80040E21 Description: "Multiple-step OLE DB operation generated error
s. Check each OLE DB status value, if available. No work was done.".
End Error
Log:
Name: OnError

Source Name: Data Flow Task
Source GUID: {2A373E56-8AAF-40E9-B9EF-4B2BB40175F0}
Execution GUID: {CE11CF95-A25E-4285-A8B0-9E28E51A6785}
Message: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
. The AcquireConnection method call to the connection manager "SourceConnection
Excel" failed with error code 0xC0202009. There may be error messages posted be
fore this with more information on why the AcquireConnection method call failed.

Any help..?

View 1 Replies View Related

(Item Lookup Error! Hr=80040e21, HrDesc=Multiple-step OLE DB Operation Generated Errors. Check Each OLE DB Status Value, If Av

Jan 31, 2007

Hi,

I am using ATL COM library application. It is using sql data base for fetching the records. Some times, i get the following error. could you please let me know, why this happens? This is not reproduceble every time.

(Error! hr=80040e21, hrDesc=Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work

Here is the code to connect to database which i am using.

CDataSource db;
CDBPropSet dbinit(DBPROPSET_DBINIT);

dbinit.AddProperty(DBPROP_AUTH_INTEGRATED, OLESTR("SSPI"));
dbinit.AddProperty(DBPROP_INIT_CATALOG, (const char *)bDatabase);
dbinit.AddProperty(DBPROP_INIT_DATASOURCE, (const char *)bServer);
dbinit.AddProperty(DBPROP_INIT_LCID, (long)1033);
dbinit.AddProperty(DBPROP_INIT_PROMPT, (short)4);
dbinit.AddProperty(DBPROP_INIT_TIMEOUT, (short)150);
hr = db.Open(_T("SQLOLEDB.1"), &dbinit);
if (FatalError(hr, "db.Open", buf))
{
*iErrorCode = hr;
return S_OK;
}



Any help, appreciated.



Thanks,

Satish

View 1 Replies View Related

Multiple-Step Operation Cannot Be Generated Check Each Status Value Error

Jan 22, 2007

Hi All,

I have a field 'Rowguid' of type uniqueidentifier in a table. This field is the last field in the table. In this case if I update a record through the application I don't get any error. Suppose if there are additional fields after the field Rowguid I get the error "Multiple-Step operation cannot be generated Check each status value"

For your reference I have used the following statement to add the RowGuid field

Alter table <tablename>
Add RowGuid uniqueidentifier ROWGUIDCOL NOT NULL Default (newid())

Can anyone please help me.


Thanks

Sathesh

View 3 Replies View Related

Errors Generated From A Form Online

Mar 18, 2007

More then two years ago I had a form in .asp created using Frontpage. When a user input information that didn't meet the requirement in SQL (sbs 2000) an error would be display after for form was submitted. I was playing around with the Diagrams in SQL server enterprise which I believe I created relationships that might have made the reporting error's possible, but I am not sure. Does anyone who if making these relationships could made the error's show up at the browser when someone is submitting a form?

Ernie

View 5 Replies View Related

SSIS Package Step Errors And Logs From SQL Job Agent?

Mar 28, 2007

I've deployed an ssis package to the database server through the manifest file over the network..



The package runs great when testing through vs.net on my client.



I've added the package to a job step in the sql server job agent.



When I test the new job, the package step fails, but there is no error or log information in the job history.



Wwhere can I get error information? And/or How can make SSIS error information more verbose in the job history?



Thanks for any help or information.

View 6 Replies View Related

Multiple Step OLE DB Error From VB

Mar 29, 2004

One of our users is getting this error message.

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21) Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if available. No work was done.

This is the only user that is currently getting the message. Last week another user got this one day and then it stopped.


Inside VB6 code, we're sending some filters to an ASP that in turn sends a SELECT based on those parameters the SQL database and we get data back to the program.


Stepped through the code and found the error returns after this line

oSqlServConn.Open "Provider=MSDAOSP;Data Source=MSXML2.DSOControl.2.6"



Any thoughts out in ForumLand? Please take it easy on me since I didn't write most of this code. Just trying to solve the problem. :)

View 6 Replies View Related

Multiple-step Ole Db Error

Mar 21, 2006

When trying to connect to sqlexpress, I get the rather uninformative error message:

Error No. -2147217887
Multiple-step OLE DB operation generated errors. Check each OLD DB status value, if available. No work was done.

Here's the connection string I'm using:

strDbConn = "Data Source=.SQLEXPRESS;AttachDbFilename=" & _
DbPath & ";Database=rawtf_1;Integrated Security=True;User Instance=True; " & _
"Trusted_Connection=Yes;providerName=System.Data.SqlClient"


What can I do correct this problem?

View 18 Replies View Related

Multiple Step OLEDB Error

Apr 2, 2007

The error message is

-2147217887 - Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.



View 1 Replies View Related

DTS: One Failure Step For Multiple Process Steps

Dec 17, 2004

How can I make this work?

I have two process steps in a package and one failure step. Both process steps have On Failure workflows to the failure step. The problem I'm having is that it seems if two or more workflows go to the same failure step then neither go to the failure step, but it does go if only one process step is attached to it.

I know I can create duplicate steps for each process step, but I was hoping to be able to do it this way FMI.

Thanks for your assistance.

View 1 Replies View Related

Sample Files From The Book SQL Server 2005 Reporting Services Step By Step

Jan 18, 2008



Hi All,

Please let me know where can i find the sample files and rs2005sbsDW database in msdn library as i dont have CD provided along with the book.

Please give me the link of the sample files so that i can download it for testing the sample application.

Regards,
Prabhanjana

View 1 Replies View Related

Step By Step SQL2000 Failover Cluster Upgrade To SQL2005

Oct 13, 2006

is there such a paper? if so, can you pls point me to it? thx in advance

View 4 Replies View Related

Step By Step To Publish/deploy The Report Project To The User Pc ?

Oct 3, 2007

hye everyone,

after finished do the report and deploy at IIS/report manager in local pc..

i want to know , what is the step /how to deploy the report project at the user's pc/ client pc /other server..


thanks in advance
thank you very much

View 16 Replies View Related

Reporting Services :: How To Convert RDL File To RDLC Step By Step

Jun 18, 2012

I want to convert .rdl  to .rdc need full steps.Actually i created .rdl report using sp sucessfully.Now i want to convert it to rdlc while doing it iam getting some authentication error and some thing else.I created rdl in 2008 and i want to change it to rdlc 2010.

View 5 Replies View Related

Execute Package Results Different To Step By Step Execution - Uses Raw File

Jan 31, 2007

I have a package that has multiple data flow tasks. At the end of a task, key data is written into a raw file (file name stored in a variable) that is used as a data source for the next task. Each task requires a success from the preceding task.

Here's the rub:

If I execute the entire package, the results of the package (number of records of certain tasks) differs significantly from when I execute each step in the package in turn (many more records e.g. 5 vs 350).

I get the feeling that the Raw file is read into memory before it is flushed by the previous task, or that the next task begins preparation tasks too early.

Any help is greatly appreciated.

I am running on Server 2003 64 (although the same thing happens when deployed on a Server 2003 32 machine)

Thanks

B.

View 2 Replies View Related

Step-by-step Deployment Of Single-user Database App?

Mar 2, 2008

Hi!

I hope the answer is as simple as the question -- but after reading all the documentation I could find (understand?) and a lot of posts here, I'm no closer to achieving the goal.

I have a Visual C# app, DAYTRACKER, developed in VS2005. It uses a database with several tables constructed using SQL Server 2005 Developer Edition.

I want to deploy the app plus the database plus SQL Express to another machine, to be used by a single user (the administrator) with no need for network connectivity of any kind.

What I have so far is:
1. The application is successfully deployed from a CD-ROM, having used the Publish process within VS2005, and opens on the new machine -- without database connectivity, however.
2. SQL Express is successfully deployed (it deployed as a 'prerequisite' when I went through the Publish process in VS2005)
3. I manually copied the database's .mdf and .mdl files, using SQL Server Managers 'Copy Database' function, then transferred the copies to the new machine into the ..MSSQL.1MSSQLdata folder (where they appear along with the master.mdg, mastlog.ldf etc files)

Now, the DAYTRACKER application's DAYTRACKERConnectionString under 'Settings' in the VS2005 studio reads 'Data Source=DELL3;Initial Catalog=DayTracker;Integrated Security=True' (which are the appropriate parameters for the machine, DELL3, on which I wrote the program.)

The problem, of course, is that SQL Express on the new machine doesn't connect the application to the database. When I go to the 'SQL Server Configuration Manager' and go to the 'SQL Server 2005 Services' and double-click on the 'SQL Server (SQLEXPRESS)' icon (the service is running) and the user is logged on using 'Local System Account'. Under the 'Service' tab the Host Name is 'MUSIC' (which is the name of the new machine I've installed the app onto -- which of course is not the name - DELL3 - that the app's connection string is expecting). Under the 'Advanced' tab, I've tried correcting the name of the Startup Parameters default .mdf and .mdl entries to ..DayTracker.mdf and ..DayTracker_log.mdl, but the server won't start up after I make the changes.

What I'm hoping for: a step-by-step way of doing this type of deployment, preferable getting it all onto one CD-ROM, and installing it on the new machine so that it all works seamlessly from the start, not requiring any 'tweaking' of the SQLServer Express settings by the end-user.

But I'll take pretty much anything that fixes the specific db connectivity problem I've described.

Thank you very much.

John F.

View 11 Replies View Related

How To Read An Database Table Step By Step (with ADO)

May 19, 2008









Hi,
I have to transport a big database table and can't read it at once with "select * from table" because the table is bigger than my system memory.
Is there a way to read the table step by step? I thought it was possible with ADO and his serverside cursors but I don't now how. I need an "universal" solution that works on SQL Server 2000/2005, MySQL and Oracle.

Regards,
harry

View 2 Replies View Related

Enabling T-SQL Debugger (SQL2000) - Step Into, Step Over Etc

Dec 5, 2007

Connecting to a networked SQL Server Box from my local machine


Open Query Analyzer from Start menu, logging in using sa account.

from the object browser i select my stored procedure (WEA_InsertClaim) - right click and select Debug.

i am prompted to enter the parameter values, which i do, auto rollback checkbox is checked - click Execute.

T-SQL Debugger opens and runs through the stored procedure.

but only buttons enabled are the "Go", "Toggle Breakpoint", "Clear All Breakpoints"

so i can set breakpoints etc. but when i select Go it will not stop at the breakpoints it just runs through the stored procedure from start to finish. giving the correct return code as its output

is there something i need to enable in order to make it stop at breakpoints??

Cheers,
Craig

View 3 Replies View Related

SQL 2012 :: Current Operation Cancelled Because Another Operation In Transaction Failed

Nov 20, 2013

I'm using SQL Server 2012 Analysis services in Tabular mode and connected to Oracle Database and while importing, I'm getting below error after importing some rows.

OLE DB or ODBC error: Accessor is not a parameter accessor.. The current operation was cancelled because another operation in the transaction failed.

View 1 Replies View Related

Entity Framework: No Support For Server-generated Keys And Server-generated Values

May 23, 2008

Hello

I tried the Beta 1 of the service pack 1 to .net 3.5. If I try to add an entity (and try to save this), I get the Exception "No support for server-generated keys and server-generated values".

How can I add entities to my Sqlce- database?

I tried to give the id- column (primary key) in the database an identity, another time without identity, only primary key --> none of them worked. I always get the same error.

What do I have to change to make successfully a SaveChanges()?

Thanks for your help,
Gerald

View 21 Replies View Related

Multiple OLE DB Errors

Apr 30, 2008

Hi all,

I have a problem I was hoping someone has been able to solve, since I haven't been able to. We have an application that uses a local instance of a database that we would like to update incrementally so we are switching to SQL CE from SQLExpress to take advantage of the sync functions. I've been able to recreate the database from a SQL Server 2000 .mdf file to a SQL Server CE 3.5 .sdf file and now I am trying to connect to it from my VS2008 .NET application. I have all the absolute latest patches, downloads, frameworks, etc. The problem comes when I try to open the recordset. I decided to keep the old code instead of going through this very large application and change over to a dataset or the other CE data handlers. I've read, and it makes sense to me that since it is still an SQL Server database, it should support ADO still.

Anyway, here is a snapshot of the code that tries to connect but fails:

(I use a module to abstract my calls to the database so that I can re-use the process in other places in the code. It used to work fine until I tried to switch to SQL CE)

'--at the top of the module:

Imports System.Data.SqlServerCe
Imports ADODB
Imports System.Xml

Module Module1

Public Const SQLConnString = "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; Data Source=C:DATATOOLS.sdf; Max Database Size=2047"
'used to be "SERVER=.SQLEXPRESS; DRIVER={SQL Server}; DATABASE=TOOLS;"

Public stSQL As String
Private _Conn As ADODB.Connection
Public myRS As ADODB.Recordset
Const adCmdText = &H1
Const adOpenForwardOnly = 0
Const adLockReadOnly = 1
Const adStateOpen = 1

Public Sub GetSQLData(ByVal stSQL As String)
Try
_Conn = New ADODB.Connection
myRS = New ADODB.Recordset
_Conn.ConnectionString = SQLConnString
_Conn.Open() '***blows up here
myRS.Open(stSQL, _Conn, adOpenForwardOnly, adLockReadOnly, adCmdText)
Catch ex As Exception
CloseConn()
End Try

End Sub

'******************************************
error message is as follows:
System.Runtime.InteropServices.COMException was caught
ErrorCode=-2147217887
Message="Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."
Source="Microsoft OLE DB Service Components"
StackTrace:
at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) at CAD.Module1.GetSQLData(String stSQL) in C:ProjectsCADCADModule1.vb:line 83
InnerException:

I also had a weird exception earlier that said my data source location string was too long - very strange - fixed it though by moving the DB to a folder closer to C.

Anyway, I hope some can decipher the "multiple OLE" errors - not sure what it is looking for.
Thanks,
Brian

View 4 Replies View Related

Step By Step For Indirect Configuration

Feb 15, 2006

Is there a good step by step guide to setting up an indirect configuration? I've followed the steps in Kirk Haselden's 'Keep your packages in the dark' article 3 or 4 times this afternoon and nothing seems to work. I cannot even get the XML configuration file to work by accessing it directly. I'm using the wizard to create the file.

Just wondering if there was something else out there....

Thanks in advance for any help.

MarkA

View 3 Replies View Related

SQL Server Agent Job Step Fails When Creating A SQL Server Integration Serveices Type Of Step

Mar 12, 2008

Hi

I posted this on the sql server security forums too. Here is the error that i get when i change the type of the step to ssis

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
Additional information:
An exception occured while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.(Microsoft SQL Server, Error: 3930)

This error pops up right after i change the type of the step to "SQL Server Intergration Services Package"

I have made the following configurations:

The user group (windows group) that the user belongs has the following roles in msdb :

db_dtsadmin
db_dtsltuser
db_dtsoperator
SQLAgentOperatorRole
SQLAgentReaderRole
SQLAgentUserRole

i have made a proxy to sql server agent which has the following subsystems :

"SQL Server Integration Services Provider" the proxy is tied to the same login which has those SQLagent and dts roles in msdb database.

Im using windows authentication and the user that logs into the sql server is in the same group that i have set all of the rights.

Ps. Clearly im missing some role or right somewhere because as soon as i give the group sysadmin role then all the users in that group can create SSIS steps in the agent.

Ps. Ps. I have been living under the impression that i dont have to give sysadmin rights to people that create ssis packages and schedule then with the agent.

View 3 Replies View Related

Errors Using Multiple Parameters In A SQL Statement

Feb 23, 2007

In an OLE DB Source in an SSIS package, we are having difficulties using multiple parameters in a SQL statement.

Using a single '?' works fine, but I've read that when you want to map more than 1 parameter you should use 'Parameter0, Parameter1, etc'.

The problem is that when we use Parameter0 and Parameter1 and then try to map it, it says that the query contains no parameters.

Can anyone help with the correct way to use multiple parameters in a SQL query that's part of an OLE DB Source task?

Thanks,

Mike

View 15 Replies View Related

Error Handling - Multiple Errors

Jun 26, 2007



In almost all scenarios, where there is an error, it also raises 3-4 other errors like these ones below.

I'm 100% sure, the 1st one is the actual error resulting in package failure and the errors 2-5 is the result of error #1. So what ever code I have in the error handler section of the package gets executed 5 times.

How do I handle this? Can do I hard coding for the error numbers?



1. An OLE DB error has occurred. Error code: 0x80040E07.

An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E07 Description: "ORA-01858: a non-numeric character was found where a numeric was expected ".



2. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.



3. Thread "SourceThread0" has exited with error code 0xC0047038.



4. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.



5. Thread "WorkThread0" has exited with error code 0xC0047039.



Thanks

View 3 Replies View Related

Database Fails Dbcc Check Db With Multiple Errors

May 1, 2014

I am not a DBA but have responsibility for a particular MSSQL 2008 R2 file server running a particular application.how to solve a database consistency check problem.The database fails dbcc checkdb with multiple 8903 errors. Unfortunately this was not discovered until well after any good backups were deleted. The good news is that the DB otherwise seems fine. We have experienced zero problems with the DB or the applications. Running the checkdb with the "repair_allow_data_loss" option does not fix the problem.

However, I would still like to fix the problem. Using a popular SQL recovery product I am able to recover the database.The original, vendor designed and supplied DB, has 2 file groups, and three files (MDF, NDF, LDF). The output of the recovery process produces 1 file group and 2 files (MDF and LDF). Vendor says they cannot support me since the recovered DB is 'non-standard' according to their design.

I am able to set up a new, blank version of the vendors database on another dev system with the proper file and filegroup structure. How can I get the data moved/copied from the recovered (MDF/LDF) database into the dev database (MDF, NDF, LDF). I've tried the import/export function but it fails (I can rerun and give details if necessary).

View 1 Replies View Related

Reporting Problems W/ MS SQL Server 2005 Reporting Services Step By Step To MS

Apr 26, 2007

I am trying to learn Reporting Services using the title "MS SQL Server 2005 Reporting Services Step by Step" by Stacia Misner and Hitachi Consulting, published in 2006. I am experiencing problems with some of the exercises. I got as far as Chapter 4 when I followed directions to create a SQL statement to define a query string for a dataset. Pg 80:



select * from vProductProfitability

where year = 2003 and

MonthNumberOfYear = 1



The view vProductProfitability does not exist in the tutorial database that came with the book, rs2005sbsDW. The result of this query is the basis for the entire chapter on developing basic reports and I'm being denied a learning opportunity because the view does not exist. In short, I'm stuck.



I have tried to find somewhere at Microsoft to place this question and get some answers so I can continue thru the tutorial. To no avail. Does anyone have any suggestions?



BTW, the solution that came in the CD is also wrong because the query noted above is also in the solution.



This humble grasshopper seeks wisdom.



Respectfully Submitted,



Dave Matthews

Atlanta, GA

aka FlooseMan Dave

View 17 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved