the system allows creation of triggers on sysobjects table. this works fine when one does changes to the sysobjects table after setting 'allow updates' option on. however, the trigger does not fire...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10048913.html
Zones:
MS SQL ServerDate Answered: 05/07/1998 Rating: 8.2 Views: 0
is there anyway to repair the sysobjects table..my sysobjects table is corrupted ...there was a similar question posted in sybase section but i wanna know if a solution exists in MS-SQL DATABASE......
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20637770.html
Zones:
MS SQL ServerDate Answered: 08/07/2003 Rating: 7.4 Views: 5
CREATE PROCEDURE sp_CreateVersioningTriggerAdd
(
@TABLE_NAME SYSNAME
)
As
DECLARE @PK_NAME VARCHAR(50)
SET @PK_NAME = (SELECT ObjectIdColumn FROM Objects WHERE ObjectName = @TABLE_NAME)
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21082526.html
Zones:
MS SQL ServerDate Answered: 08/04/2004 Rating: 8.4 Views: 0
I want to understand
select a.name, case when b.id is not null then 'insert ' else '' end + case when c.id is not null then 'update ' else '' end + case when d.id is not null then 'delete ' else...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21568831.html
Zones:
MS SQL ServerDate Answered: 11/12/2005 Rating: 6.8 Views: 0
Hi Guys
Problem in Short:
Ive got a SQL problem where the query works fine ending with ON Table.Column=AnotherTable.AnotherColumn
However it doesnt work with:
ON Table.Column=AnotherTab...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21638644.html
Zones:
MS AccessDate Answered: 11/23/2005 Rating: 8.2 Views: 0
I have over 200 stored procedures in my database and about 90 tables. I have renamed some of the schemas and tables, so I have to change code in about 90% or more of the stored procedures. I have...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22041135.html
Zones:
MS SQL ServerDate Answered: 12/08/2006 Rating: 9.4 Views: 0
Hi
I am using the following query with a store procedure to get the information about changes made to the database tables. How can I use syscolumns or other system tables to get the information ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22405019.html
Zones:
MS SQL ServerDate Answered: 02/23/2007 Rating: 8.2 Views: 0
Dear All!
On my Sybase SQL server an index of a sysobjects table got damaged. The table needs to be reindexed, I think. I, however, cannot do that because Sybase denies such act repairing on sy...
http://www.experts-exchange.com/Database/Sybase/Q_10279023.html
Zones:
SybaseDate Answered: 02/14/2000 Rating: 5.8 Views: 4
Hi,
Am using sql server 2k and would like to place a trigger on a system table (sysobjects). I believe this is not possible. Please correct me if im wrong.
Instead I thought I could create a ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20852757.html
Zones:
MS SQL ServerDate Answered: 07/14/2004 Rating: 7.2 Views: 0
The following query pulls all of the tables and triggers in my database:
SELECT sysobjects_1.name AS TableName, sysobjects.name AS TriggerName
FROM sysobjects INNER JOIN sysobjects ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21229505.html
Zones:
MS SQL ServerDate Answered: 01/11/2005 Rating: 8.8 Views: 0
