sure, I post it to you.

USE [SV]

GO

/****** Object: Table [ManageStudent].[_Student] Script Date: 06/17/2009 11:38:04 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [ManageStudent].[_Student](

[StudentID] [varchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS...

I replace it with :

Insert into ManageStudent._Student

Select * From ManageStudent.StudentTemp

The problem is still not solved.

insert into ManageStudent._Student exec('Select * from ManageStudent.StudentTemp')

Text above create the error. I see it quite simple, so I don't know why it has error???

ALZDBA (3/10/2009)

---

thieuquanghuy (3/9/2009)

---

...

Thanks marina.kudryashov, I wonder if Idera is a shareware.

Thanks ALZDBA, this link www.sqlservercentral.com/articles/Administration/64974/ is very useful.

and article in http://www.sqlservercentral.com/articles/Security/66151/ is interesting.

I replace FOR LOGIN_EVENT with FOR LOGON,...

RBarryYoung (3/9/2009)

---

Here's one way:

Declare @sql as nvarchar(MAX)

Set @sql = ''

Select @sql = @sql

+ 'Create trigger ['+TABLE_SCHEMA'].[tr'+TABLE_NAME'_auto]

on ['+TABLE_SCHEMA'].['+TABLE_NAME'] for INSERT,UPDATE,DELETE as

{your-stuff-goes-here}

'

From INFORMATION_SCHEMA.TABLES

Where TABLE_TYPE = 'BASE TABLE'

Print...

ALZDBA (3/9/2009)

---

I forgot to reply on your logon trigger.....

Read my little article regarding exactly that:

www.sqlservercentral.com/articles/Administration/64974/

But If you're on sp3 you shouldn't have the problems I encountered.

I also advise to read...

GilaMonster,ALZDBA(3/8/2009)

---

Thanks. If I want to catch a log on event, how to write a trigger for it. The information will be saved is logged on name, datetime, succeeded or...

GilaMonster,ALZDBA(3/8/2009)

---

Thanks. If I want to catch a log on event, how to write a trigger for it. The information will be saved is logged on name, datetime, succeeded or...