how about this idea:

don't let them change the job, nor give them access to edit the job.

Instead, change the job slightly so instead of hardcoding those parameters, change it to...

Lukes right...that proc is returning more than one value;

run the proc all by itself, or try this as a proof of concept:

EXECUTE [db_name].[dbo].[proc_name]

--or capture the results to a...

you can use a case statement in the ORDER BY clause:

ORDER BY

CASE

WHEN <something that makes the first row first>

...

it does seem to me to be the WINS\DNS, wher ethe WINS service might not be returning the IP address connected to the name on th network;

i assume your...

the key you are looking for is sys.triggers; i think you'd have to schedule a job to email if the condiftion of is_disabled = 1 is ever found.

here's an example

name...

I'd seen this question here before, and i believe the SQL Engine install can only occur on the %SystemDrive% drive; in most cases that is the C:\ drive;

as already...

i think it is nothing more than clicking the green arrow/debug mode, when you should have hit execute:

i confuse them myself, because the arrow in visual studio means "run";

100K records is a lot to do anything to in compact edition; it's mostly up to the processor and indexing. are you just searching in compact edition? what exactly are...

Jordon here's a simple SQL to...

i think you should NOT include the user/schema:

this should work instead, unless you are logging in a sys or system:

SELECT * FROM LS20001...user_triggers

also, Oracle can be picky on case sensitivity;

SELECT...

I'm with Elliot; you can assume that the dbID < 4, but, on my SQL 2008, I have 6 db's i'd call system db's:

master

tempdb

model

msdb

ReportServer

ReportServerTempDB

I think you are limited to using...

ok here's my assumption based on what you posted: the plan is to move the "Contact"'s address info into the Contact Table, instead of having it as a seperate reference...

there are views in Oracle named USER_TRIGGERS or even ALL_TRIGGERS

--specific table

select * from user_triggers WHERE TABLE_NAME = 'TBTITLE'

--owned by a specific user(equivilent to database)

select * from user_triggers WHERE TABLE_OWNER =...

great scott!

the structure really helps us understand the relationships of the data.

now to the meat and potatoes of the issue;

you said this:

...take information from one table within the database and...

scott this looks an aweful lot like homework; we volunteer our time here to help you learn and understand concepts, so lets make sure we help you the right way.

inserting...