if you change a .config file or .aspx, no recompilation is needed. if you change a .vb file, then yess you have to recompile.

i'm guessing table joining and reserved word issues here?

does this look a little better?

SELECT ICDCODE FROM DIAGS

INNER JOIN [PROCEDURE] ON  DIAGS.DIAGID = Procedure.DIAGID

i think the issue is permissions. the user running the app does not have write permissions to HKey LocalMachine;

When you type in an instance in the SQL manager, it tries...

I think something like this will work for you:

CREATE TRIGGER InsPeriods ON dbo.table2

FOR INSERT

AS

insert into dbo.table3 (itemID, installment, periodvalue, paymentdate)

select

  INSERTED.itemID,

  INSERTED.installment,

  --avoid division by zero or...

there's no good reason to limit yourself to 8 characters on the name of the database. just because that was the limit in older systems, doesn't mean you should handicap...

who owns the data? doesn't the company you deploy to own the data in the database?

We have a very similar situation...we provide a blank database with default values, and...

if you can't trust your system admin, you've got a flaw in your business;

if he's making copies, tell him to stop and destroy and copies he has made. Sysadmins are...

here's another version of a cursor to kill users off of a database; i put this in the master database;

syntax is sp_kill databasename and it will list the hostnames of...

Walter i don't know if this helps. you might not have access to change the DDL on the oracle server.

In my situation, i use a trigger to insert the sequence...

ok here's an updated version that has all the cREATE INDEX statements in it; i could not figure out how to do it without a cursor, but this is more...

hee's something i've been fiddling with; i still have to get hte column names for each index, but this finds all indexes i think; remove the top 100 for all...

what happens if you run this query?

select Distinct

ContactID,

LastName,

FirstName,

ActiveInd,

ContactTypeDescription,

ContactTypeID,

OrganizationID,

OrganizationName,

City,

State,

HomePhone

from

(

select Distinct (T_Contact.ContactID),

LastName, FirstName, T_Contact.ActiveInd, ContactTypeDescription,

T_ContactType.ContactTypeID, T_Organization.OrganizationID, OrganizationName,

City, State, HomePhone

from

T_Contact

join T_ContactTypeContact on T_Contact.ContactID =...

Hi Dave;

I think the value you are looking for is STATUS & 64=0 means index, STATUS & 64 <> 0 means statistics:

hope this helps: examples:

select  top 100 object_name(I.id) as...

yet another thought: if you have the zipcode you could just look up the city and state from a separate table and ignore parsing the addr field ...plenty of free...

here's a couple of other ideas that might help:

if we can assume that single-word city/towns have all address elements, so there is always 4 spaces in the document,something like this...