CELKO (10/13/2012)

---

In particular, do you know how to properly create a “problem_category” encoding scheme? It is usually a hierarchy (a Dewey Decimal of Disaster, as we call them)? Do...

thanks OPC I'm going to put this on my test server now. I'll let you know how it turns out.

by the way why do you put the () after...

How would I tie back a table such as the one below to the trigger?

USE GK50LIVE;

GO

SET NOCOUNT ON;

USE GK50LIVE

go

-- Create LIMITEDLOGINS Table

CREATE TABLE dbo.LimitedLogins

(

...

If I need to have this trigger take effect on 4 logins would I just add the additional logins as such below.

USE master;

GO

CREATE TRIGGER connection_limit_trigger

ON ALL SERVER WITH EXECUTE...

Would this be the code to use?

USE master;

GO

CREATE LOGIN login_test WITH PASSWORD = '3KHJ6dhx(0xVYsdf' MUST_CHANGE,

CHECK_EXPIRATION = ON;

GO

GRANT VIEW SERVER STATE TO login_test;

GO

CREATE TRIGGER connection_limit_trigger

ON ALL SERVER...

Bingo!!! You were right on the money. Thanks Wendel!!!!!!!

Wendel,

you were correct on the column allowing nulls. I have changed this to

alter table CaseData Alter column CaseStatus BIT NOT NULL

In regards to setting a default value this...

Wendel,

thanks I was able to create the odbc in the user dsn. I was trying to create it via the export part of external data but I realized i...

I figured it out. I needed to add the accdb file as an import --> Link from the external data ribbon.

Got it. thanks Howard. I usually look out for the inellisense to pick up those mistakes but for some reason I didn't notice.

ProofOfLife (1/15/2012)

---

Hi

First a word or two on your database. Ideally, you should match your datatypes when it comes to the Category ID attribute - you have it specified as...

Dev (1/14/2012)

---

Is there any particular reason for using Access Front End (except you are familiar with it)? I have used Access Front End but only if the backend...

I think I just found that out for myself.

How then can I make a drop down list in access show data in a seperate table yet relates to the...

Doing it this way:

USE GKHELPDESK

GO

Alter Table dbo.CaseData

Add Constraint FK_Category_CatType Foreign Key (Category)

References dbo.Category (ID);

Allowed the command to complete successfully. Hopefully access will see it.

Thanks Brandie. I added the below code and get an error message stating

Msg 1776, Level 16, State 0, Line 1

There are no primary or candidate keys in the referenced...