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...

you can add a WHERE statment to eliminate the days, but which datefield? your sample has three fields that might be datetimes:

new_lastupdatetime, createdon or new_timesupportcallreceived?

select datename(dw,getdate())--Friday

and do something like :

WHERE...