WinNT 4, Microsoft Access / MSDE
I have MSDE installed and running. I have learned a little about using osql utility.
I want to follow along with the SQL SERVER newsletter code such as below. But, it always says to “USE Northwind”. Does this mean the Northwind.mdb or do they mean an SQL SERVER version of Northwind.xxx? I do not know where to find this Northwind version.
from todays Newsletter:
USE Northwind
GO
SET NOCOUNT ON
GO
CREATE TABLE CheckAppName
(CheckAppNameId INT NOT NULL
CONSTRAINT PkCheckAppName PRIMARY KEY CLUSTERED,
DescrText char (20) NOT NULL,
CONSTRAINT tck_AppName CHECK (APP_NAME() = ‘VBApp’))
GO
— =============================================
— Create trigger basic template(After trigger)
— =============================================
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N’tiud_CheckAppName’
AND type = ‘TR’)
DROP TRIGGER tiud_CheckAppName
GO
CREATE TRIGGER tiud_CheckAppName
ON Northwind.dbo.CheckAppName
FOR DELETE
AS
BEGIN
IF (SELECT APP_NAME()) != ‘VBApp’
BEGIN
RAISERROR (‘CAN NOT USE THIS APPLICATION TO UPDATE TABLE ‘, 16, 10)
ROLLBACK
END
END
GO
Thanks