on 08-28-2012 5:24 PM
Hi,
i accidentally deleted table T000. now when i login its throughs an error
Table T000 does not exist in the database with ID R/3.
Kindly advice.
Thanks
what to do if i dont have a latest backup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This will create the table but will not have any entries in the table for your client. Once you create it, you need to update the table with your Client information.
----------------------------------------------------------------
Use this script on another database and see how T000 looks.
USE XXX
Go
select * from xxx.T000
---------------------------------------------------------------
------------------------------------------------------------------
Replace XXX and xxx with your DBSID.
USE [XXX]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [xxx].[T000](
[MANDT] [nvarchar](3) NOT NULL,
[MTEXT] [nvarchar](25) NOT NULL,
[ORT01] [nvarchar](25) NOT NULL,
[MWAER] [nvarchar](5) NOT NULL,
[ADRNR] [nvarchar](10) NOT NULL,
[CCCATEGORY] [nvarchar](1) NOT NULL,
[CCCORACTIV] [nvarchar](1) NOT NULL,
[CCNOCLIIND] [nvarchar](1) NOT NULL,
[CCCOPYLOCK] [nvarchar](1) NOT NULL,
[CCNOCASCAD] [nvarchar](1) NOT NULL,
[CCSOFTLOCK] [nvarchar](1) NOT NULL,
[CCORIGCONT] [nvarchar](1) NOT NULL,
[CCIMAILDIS] [nvarchar](1) NOT NULL,
[CCTEMPLOCK] [nvarchar](1) NOT NULL,
[CHANGEUSER] [nvarchar](12) NOT NULL,
[CHANGEDATE] [nvarchar](8) NOT NULL,
[LOGSYS] [nvarchar](10) NOT NULL,
CONSTRAINT [T000~0] PRIMARY KEY CLUSTERED
(
[MANDT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
---------------------------
Good luck!!!
Ravi
Simple answer, restore from backup.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.