Comments by jawad59 (Top 14 by date)

i got trigger list through your code. There is only one trigger named- noinsertion. This trigger restrict insert operation in the table.

I do'nt know why its kept. Previously it was working fine. now, it gives this trigger error. if I disable it then works.

Also there is a common trigger for all database in server, which restricts delete & create database.

trigger may be associated with that table.

error when creating database

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Create failed for Database 'gwb18mar2015'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

The transaction ended in the trigger. The batch has been aborted.
you must check the permission of this Database (Microsoft SQL Server, Error: 3609)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3609&LinkId=20476

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [safety]
ON DATABASE
FOR DROP_TABLE, ALTER_TABLE, CREATE_TABLE,Drop_trigger
AS
PRINT 'you must check the permission of this table'
ROLLBACK;
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ENABLE TRIGGER [safety] ON DATABASE



Now sql is also giving same error when i try to create new database.