[Microsoft][SQL Server Native Client 11.0]Unspecified error occurred on SQL Server. Connection may
have been terminated by the server
Object Server 01: The database reported (session 1 (-AOS-)): [Microsoft][SQL Server Native Client 11.0]Unspecified error occurred on SQL Server. Connection may
have been terminated by the server.. The SQL statement was: "SELECT COUNT(T1.TZENUM) FROM TIMEZONESLIST T1"
While i am going to start the server its showing me a warning message.
I went to event viewer, reason for not starting the server. It showing the below issues.
I Opened the SQL database and checked.
Here the "TimeZonesList" table is corrupted. So, I delete the table.
After that, i copy and paste this code in the database and Execute this command for re-creation same table.
Got a message completed successfully.
CREATE TABLE [dbo].[TIMEZONESLIST](
[TZENUM] [int] NOT NULL DEFAULT ((0)),
[TIMEZONEKEYNAME] [nvarchar](64) NOT NULL DEFAULT (''),
[ENUMNAME] [nvarchar](64) NOT NULL DEFAULT (''),
[ENUMPOSITION] [int] NOT NULL DEFAULT ((0)),
[RECVERSION] [int] NOT NULL DEFAULT ((1)),
[RECID] [bigint] NOT NULL,
CONSTRAINT [I_65496TZENUM] PRIMARY KEY CLUSTERED
(
[TZENUM] 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
as picture as below.
After then start the service. It will work fine.
Thank You.
No comments:
Post a Comment