周一早晨,在测试库建立了一张数据表,里面放了一些数据信息(没有任何模式备份)今天打开测试库意外发现我的数据信息全部没有了,我在 SQL Profiler 查看一下,谁把数据删除了,但是令我意外的是,自己把数据删除了?
这令我很费解,我从来没有在SSMS里面写过如下的语句,怎么会出现这种情况呢?你们谁知道这怎么产生的?
这是 Profiler 里面的 TEXTDATA
declare @p1 int
set @p1=22
exec sp_prepare @p1 output,NULL,N'if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].[CT_Text]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)
drop table [dbo].[CT_Text] CREATE TABLE [dbo].[CT_Text] (
[CT_ID] [int] IDENTITY(1,1) NOT NULL , --
[CT_TYPE] [char] (10) NULL , --
[CT_Text] [text] NULL , --
[CT_Time] [varchar] (10) NULL , --
[CT_Desc] [text] NULL , --
[CT_DBName] [varchar] (20) NULL --
) ;
ALTER TABLE [dbo].[CT_Text] WITH NOCHECK ADD
CONSTRAINT [PK_CT_Text] PRIMARY KEY CLUSTERED
(
[CT_ID] --
) ON [PRIMARY] ;
-------------------------------------------
',1
select @p1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CT_Text]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CT_Text] CREATE TABLE [dbo].[CT_Text] (
[CT_ID] [int] IDENTITY(1,1) NOT NULL , --
[CT_TYPE] [char] (10) NULL , --
[CT_Text] [text] NULL , --
[CT_Time] [varchar] (10) NULL , --
[CT_Desc] [text] NULL , --
[CT_DBName] [varchar] (20) NULL --
) ;
ALTER TABLE [dbo].[CT_Text] WITH NOCHECK ADD
CONSTRAINT [PK_CT_Text] PRIMARY KEY CLUSTERED
(
[CT_ID] --
) ON [PRIMARY] ;
-------------------------------------------谁知道这种情况? 谢谢
这令我很费解,我从来没有在SSMS里面写过如下的语句,怎么会出现这种情况呢?你们谁知道这怎么产生的?
这是 Profiler 里面的 TEXTDATA
declare @p1 int
set @p1=22
exec sp_prepare @p1 output,NULL,N'if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].[CT_Text]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)
drop table [dbo].[CT_Text] CREATE TABLE [dbo].[CT_Text] (
[CT_ID] [int] IDENTITY(1,1) NOT NULL , --
[CT_TYPE] [char] (10) NULL , --
[CT_Text] [text] NULL , --
[CT_Time] [varchar] (10) NULL , --
[CT_Desc] [text] NULL , --
[CT_DBName] [varchar] (20) NULL --
) ;
ALTER TABLE [dbo].[CT_Text] WITH NOCHECK ADD
CONSTRAINT [PK_CT_Text] PRIMARY KEY CLUSTERED
(
[CT_ID] --
) ON [PRIMARY] ;
-------------------------------------------
',1
select @p1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CT_Text]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CT_Text] CREATE TABLE [dbo].[CT_Text] (
[CT_ID] [int] IDENTITY(1,1) NOT NULL , --
[CT_TYPE] [char] (10) NULL , --
[CT_Text] [text] NULL , --
[CT_Time] [varchar] (10) NULL , --
[CT_Desc] [text] NULL , --
[CT_DBName] [varchar] (20) NULL --
) ;
ALTER TABLE [dbo].[CT_Text] WITH NOCHECK ADD
CONSTRAINT [PK_CT_Text] PRIMARY KEY CLUSTERED
(
[CT_ID] --
) ON [PRIMARY] ;
-------------------------------------------谁知道这种情况? 谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货